Bug #7274 Test failure: 'sp' (using '--ps-protocol': 'unable to prepare ...')
Submitted: 14 Dec 2004 15:54 Modified: 14 Jan 2005 18:50
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Linux (Linux / Athlon)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[14 Dec 2004 15:54] Joerg Bruehe 
Description:
Test 'sp' fails for me in current 5.0, when I run the test suite with '--ps-protocol'.
In a standard run, this test passes.

This is a non-debug build: 'compile-pentium-max'.

Failure report:
=== cut ===
sp                             [ fail ]

Errors are (from /M50/push-5.0/mysql-test/var/log/mysqltest-time) :
/M50/push-5.0/client/.libs/mysqltest: At line 1085: unable to prepare statement 'update t1 set data=42 where id = "b";
select row_count()': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
select row_count()' at line 1 (mysql_stmt_errno=1064 returned=1)
(the last lines may be the most important ones)

Ending Tests
=== cut ===

Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
  Fix for bug #7223: information_schema: error in "views"

The error is older, as I got it already yesterday but did not yet report.

How to repeat:
Run the test suite with '--ps-protocol'.
[14 Jan 2005 18:50] Joerg Bruehe 
I cannot reproduce it any more, seems to have been corrected (there were corrections for the '--ps-protocol' case).