Bug #1220 Segfault after SELECT PASSWORD() in embedded mysql
Submitted: 8 Sep 2003 2:45 Modified: 8 Sep 2003 6:23
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:4.1.1 OS:Linux (Linux)
Assigned to: Alexey Botchkov CPU Architecture:Any

[8 Sep 2003 2:45] Georg Richter
After executing SELECT PASSWORD(string) next query segfaults


How to repeat:
mysql_server_init(0, NULL, NULL);

mysql = mysql_init(NULL);
mysql_real_connect(mysql, NULL, NULL, NULL, "emb_test", 0, NULL, 0);

mysql_query(mysql, "SELECT PASSWORD('foo')");

/* segfault */
mysql_query(mysql, "SELECT 1");


[8 Sep 2003 3:07] Georg Richter
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

sorry, better to use mysql_real_connect next time (mysql_query in php also stores the resultset :(
[8 Sep 2003 6:23] Alexey Botchkov
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 

Actually it was a bug. Library should return understandable error message here.

changeset 1.1610