Bug #1946 You can always mysql_real_query a query with placeholders after mysql_prepare()
Submitted: 25 Nov 2003 7:38 Modified: 26 Nov 2003 13:11
Reporter: Konstantin Osipov
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (all)
Assigned to: Konstantin Osipov Target Version:

[25 Nov 2003 7:38] Konstantin Osipov 
Description:
  const char *query= "INSERT INTO prepare_command VALUES (?)";

  stmt = mysql_prepare(mysql, query, strlen(query));
  mystmt_init(stmt);
  rc= mysql_real_query(mysql, query, strlen(query));
  assert(rc != 0);

assertion fails 

How to repeat:
issue C API calls mentioned above having prepare_command table like 
CREATE TABLE prepare_command (id int)

Suggested fix:
Eliminate THD::prepare_command and use THD->command for checks in sql_yacc.yy
[26 Nov 2003 13:11] Konstantin Osipov 
Fixed in 4.1.1, ChangeSet (konstantin:1.1639)