#2537 (ok 2.11.4) Wrong error when a string contains semicolon

[Christian Schmidt]

When entering

SELECT * FROM foo WHERE bar = ';'

or even

SELECT ';'

in an SQL window, I get the following error message:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 30
STR: '
SQL: SELECT * FROM foo WHERE bar = ';

SQL query: Documentation

SELECT * FROM foo WHERE bar = ';

MySQL said: Documentation
#1064 - 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 ''' at line 1

Both statements are valid SQL and work without problems in the MySQL command line client.

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Fixed in subversion, thanks for reporting.

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

I'll revert my fix, since it does not handle multi-statement queries.

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

the problem is that phpMyAdmin removes the last char (in booth cases the last quote) if there is at least one delimiter (;) somewhere in the query

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

Fixed in subversion, thanks for reporting.