Bug #13655 prepared statement BC break
Submitted: 30 Sep 2005 13:35 Modified: 3 Oct 2005 23:16
Reporter: Georg Richter Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.14 OS:Any (all)
Assigned to: Assigned Account CPU Architecture:Any

[30 Sep 2005 13:35] Georg Richter
Description:
When using prepared statements, type (metadata) differs in 4.1 and 5.0:

Output:

./test
Version: 4.1.15-debug-log
Type: 5

./test
Version: 5.0.14-rc-debug-log
Type: 246

How to repeat:
#include <stdio.h>
#include <mysql.h>

int main (v) {
	MYSQL *mysql;
	MYSQL_STMT *stmt;
	MYSQL_RES *res;
	MYSQL_FIELD *field;
	char *query= "SELECT 1.234 FROM DUAL";

	mysql= mysql_init(NULL);
	mysql_real_connect(mysql, "localhost", "root", "", "", 0, NULL, 0);

	printf("Version: %s\n", mysql_get_server_info(mysql));

	stmt= mysql_stmt_init(mysql);
	mysql_stmt_prepare(stmt, query, strlen(query));

	mysql_stmt_execute(stmt);

	res= mysql_stmt_result_metadata(stmt);
	field= mysql_fetch_field(res);
	printf("Type: %d\n", field->type);
}
[30 Sep 2005 13:56] MySQL Verification Team
miguel@hegel:~/dbs/5.0> ./bug13655
Version: 5.0.14-rc-debug
Type: 246
miguel@hegel:~/dbs/5.0> 

miguel@hegel:~/dbs/4.1> ./bug13655
Version: 4.1.15-debug-log
Type: 5
miguel@hegel:~/dbs/4.1>
[3 Oct 2005 23:16] Konstantin Osipov
This is a duplicate of Bug#9491