Bug #14017 mysql_stmt_param_metadata() needs to be implemented in C API

• Submitted: 13 Oct 2005 20:06
• Modified: 7 Aug 2014 14:37
• Reporter: J Jorgenson
• Status: Verified
• Category: MySQL Server: C API (client library)
• Severity: S4 (Feature request)
• Version: 5.0.9, 6.0.x, 5.5.x, 5.6.x
• OS: Any (Linux/Windows)
• CPU Architecture: Any
• Tags: mysql_stmt_param

[13 Oct 2005 20:06] J Jorgenson

Description:
Client API function mysql_stmt_param_metadata() is not implemented.

This would greatly help with handling prepared statements & providing higher-performance of data transfer within applications & 'over-the-wire' by not always defaulting to a char[]... This would reduce the need to convert data to/from a string (ex: when working with date/time/double/long/bool/etc...) in applications when setting Parameter values for Prepared SQL Statements.

How to repeat:
The function mysql_stmt_param_metadata() is not implemented in the C API.

Suggested fix:
Please implement the function mysql_stmt_param_metadata() within the C API.

[13 Nov 2007 16:42] Valeriy Kravchuk

MySQL++ is not supported by MySQL any more. Send your feature request to http://tangentsoft.net/mysql++/.

[13 Nov 2007 16:47] J Jorgenson

The mysql_stmt_param_metadata() is part of the **CORE** Mysql C API client library.  Please refer to the C API function call of: mysql_stmt_result_metadata() for existing functionality that needs to be extended to mysql_stmt_param_metadata().

This is NOT a request for Mysql++...

[8 Dec 2007 19:08] Valeriy Kravchuk

Thank you for a reasonable feature request. According to http://dev.mysql.com/doc/refman/6.0/en/mysql-stmt-param-metadata.html, this function still "does nothing" :(

[2 Feb 2013 9:09] MySQL Verification Team

bug #68166 is a duplicate

[2 Feb 2013 9:12] MySQL Verification Team

Still does nothing.
http://dev.mysql.com/doc/refman/5.6/en/mysql-stmt-param-metadata.html

And checking the libmysql.c source code of the function, we have a comment there:
"
/*
    TODO: Fix this when server sends the information.
    Till then keep a dummy prototype.
*/
"

[7 Aug 2014 11:45] Daniel Kelly

Still does nothing... I have come across the want (not need) to use this function, would be great to get rid of some query bloat.

http://dev.mysql.com/doc/refman/5.7/en/mysql-stmt-param-metadata.html

[7 Aug 2014 14:37] J Jorgenson

Updated Versions affected.
Updated OS affected.