Bug #63189 bug in the SQL parser
Submitted: 10 Nov 2011 18:36 Modified: 11 Dec 2011 8:07
Reporter: nhan levan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.0.51a OS:Linux
Assigned to: CPU Architecture:Any

[10 Nov 2011 18:36] nhan levan 
Description:
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNodjUFrwzAMhd/Zv0LHDjITZc3G3FMIJhtz49ROu+NaRmGBxS1dy9Z/P6UIpE9Pjycbgg+Gaqa6
IGdbQ0wFMbOKvehQanmNK2eo1LkueXf/eRjHSxrOV7WOgXzMqGps22e0seJ/HxI1tn7zxPpZdcvK
0IOe61x1L93kyHycogrNT+SGdPlTrmobQ/ukbl9e0SLCIqAHYdp6eKEtfnHEB87Y44RR6CT0jZ0o
Aw5I+MGX0FHmVvwbVHBYS1LEDCUKzPEolcmNbz3HHRb/YCo07A==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 111
STR: �

MySQL: 5.0.51a-community
USR OS, AGENT, VER: Win GECKO 1.9
PMA: 3.4.0
PHP VER,OS: 5.2.17 Linux
LANG: en
SQL: I�N�S�E�R�T� �I�N�T�O� �`�w�p�_�t�e�r�m�_�r�e�l�a�t�i�o�n�s�h�i�p�s�`� �V�A�L�U�E�S�(�5�2�4�6�6�,� �1�,� �0�)�;

----END RAW----

SQL query:

I�N�S�E�R�T� �I�N�T�O� �`�w�p�_�t�e�r�m�_�r�e�l�a�t�i�o�n�s�h�i�p�s�`� �V�A�L�U�E�S�(�5�2�4�6�6�,� �1�,� �0�)�;

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 'I' at line 1 

How to repeat:
import sql query (zip file):

INSERT INTO `wp_term_relationships` VALUES(52466, 1, 0);
[11 Nov 2011 8:07] Valeriy Kravchuk 
Please, check if the same problem still happens with a newer version, 5.0.91 at least. If it does, please, send complete repeatable test case (the one to run from mysql command line client).
[12 Dec 2011 7:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".