Bug #94373 Using unsupported buffer type: 245
Submitted: 18 Feb 2019 8:44 Modified: 19 Feb 2019 11:18
Reporter: NaNa Gao Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: C API (client library) Severity:S7 (Test Cases)
Version:mysql-8.0.15-winx64 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[18 Feb 2019 8:44] NaNa Gao
I install mysql-connector-c-6.1.11-winx64.msi and mysql-8.0.15-winx64.zip in my pc. 

But mysql_stmt_bind_param and mysql_stmt_bind_result can not work with json column.

error msgļ¼šUsing unsupported buffer type: 245

I can use mysql_real_query successfully to get the json string;

How to repeat:
                my_bool is_null;
		my_bool error;
		unsigned long  length;

		memset(bind, 0, sizeof(bind));

		bind[0].buffer_type = MYSQL_TYPE_STRING;
		bind[0].buffer = global_buff;
		bind[0].buffer_length = sizeof(global_buff);
		bind[0].is_null = &is_null;
		bind[0].length = &length;
		bind[0].error = &error;

		if (mysql_stmt_bind_result(stmt, bind))
			fprintf(stderr, " mysql_stmt_bind_result() failed\n");
			fprintf(stderr, " %s\n", mysql_stmt_error(stmt));
			return false;
[19 Feb 2019 11:18] NaNa Gao
It is Connector/C version problem.Now everything is ok.