Bug #6210 Test case hangs when using the prepared statement protocol
Submitted: 22 Oct 2004 6:27 Modified: 24 Oct 2004 9:01
Reporter: Kent Boortz Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (any)
Assigned to: Michael Widenius CPU Architecture:Any

[22 Oct 2004 6:27] Kent Boortz
With my patch to run "mysqltest.c" using the prepared statement C API
the test case "alter_table" hangs in

           1 Prepare     CREATE TABLE t1 (
Host varchar(16) binary NOT NULL default '',
User varchar(16) binary NOT NULL default '',
PRIMARY KEY  (Host,User)
           2 Query       ALTER TABLE t1 DISABLE KEYS
           2 Query       LOCK TABLES t1 WRITE
           1 Prepare     INSERT INTO t1 VALUES ('localhost','root'),

If part of independent statements before this one is removed the test
case will succeed.

How to repeat:
Last changeset was ChangeSet@1.2118.

Apply the patch file to add the --ps-protocol option and build. Run the test

  % ./mysql-test-run --local --ps-protocol --do-test=alter_table

It hangs on both MacOS X 10.3 and Solaris 9.
[22 Oct 2004 6:34] Kent Boortz
Patch to add --ps-protocol option to mysqltest/mysql-test-run

Attachment: ps-protocol-2.patch (application/octet-stream, text), 26.85 KiB.

[24 Oct 2004 9:01] Michael Widenius
Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

This was a bug in the patch, not in MySQL.