| 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: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.
Description: 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) ) ENGINE=MyISAM 2 Query ALTER TABLE t1 DISABLE KEYS 2 Query LOCK TABLES t1 WRITE 1 Prepare INSERT INTO t1 VALUES ('localhost','root'), ('localhost',''),('games','monty') 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.