MySQL Bugs: #20044: \tab is not allowed in DML

Bug #20044	\tab is not allowed in DML
Submitted:	24 May 2006 13:00	Modified:	24 May 2006 14:09
Reporter:	Xin Li	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.20	OS:	Windows (WIndows)
Assigned to:		CPU Architecture:	Any

Description:
We have a script which can be executed in MySQL Query Browser. Further investigation found out that MySQL Query Browser doesn't like tab. 

For example, the following SQL statements doesn't work:

create table test (
	a int not null,
	b null);

	START TRANSACTION;
	INSERT INTO test (a, b) VALUES (0, 1);
	select * from test;

(there is a tab in front of lines; not spaces)

The error messages are:

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 'null' at line 3

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

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

Table 'xli.tes' doesn't exist

It seems like the last 1 or 2 characters are ignored. If I add a space before ";" for the last 3 cases and add crlf before ");" for the first case, they all works well.

How to repeat:
in MySQL Query Browser, execute the following:

(please cut-and-paste; don't type; because there is a tab for each line)

create table test (
	a int not null,
	b null);

	START TRANSACTION;
	INSERT INTO test (a, b) VALUES (0, 1);
	select * from test;

Thank you for the bug report. Please see bug: http://bugs.mysql.com/bug.php?id=16441

Thanks for taking care of this issue. It seems like the bug exists for a long time. Any plan to fix that? It stops us to support MySQL Query Browser for our products!