Bug #7279 Test failure: 'trigger' (using '--ps-protocol': 'unable to prepare ...')
Submitted: 14 Dec 2004 16:47 Modified: 14 Jan 2005 18:58
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: Konstantin Osipov CPU Architecture:Any

[14 Dec 2004 16:47] Joerg Bruehe 
Description:
Test 'trigger' 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 ===
trigger                        [ fail ]

Errors are (from /M50/push-5.0/mysql-test/var/log/mysqltest-time) :
/M50/push-5.0/client/.libs/mysqltest: At line 72: unable to prepare statement 'select @update_failed;
select * from t1': 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 * from t1' at line 1 (mysql_stmt_errno=1064 returned=1)
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon
=== 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:58] Joerg Bruehe 
I cannot reproduce it any more, seems to have been corrected (there were corrections for the '--ps-protocol' case).