Bug #19890 mysqltest: "query" command is broken
Submitted: 17 May 2006 16:19 Modified: 15 Aug 2006 3:50
Reporter: Paul Dubois Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:all OS:
Assigned to: Magnus Blåudd CPU Architecture:Any

[17 May 2006 16:19] Paul Dubois
mysqltest supports a query command that has this syntax:

query <statement>

where <statement> is a SQL statement to send to the server.

But mysqltest sends the entire command, including the leading
"query" to the server, resulting in a syntax error.

How to repeat:
Execute mysqltest and enter any "query" command.

% mysqltest
query select 1;
mysqltest: At line 1: query 'query select 1' failed: 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 'query select 1' at line 1
not ok

If you examine the server's general log, you'll see "query select 1".
[26 Jul 2006 9:28] Magnus Blåudd
There is not supposed to be a "query" command. :)
[26 Jul 2006 11:43] Magnus Blåudd
I change my mind. "query" could be used as a prefix to force a command to be sent to the server. The query part should be stripped.
[26 Jul 2006 12:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[3 Aug 2006 16:42] Magnus Blåudd
Pushed to 5.0.25
[3 Aug 2006 17:07] Paul Dubois
Noted in 5.0.25 changelog.

The query command for mysqltest did not work.
[14 Aug 2006 21:26] Konstantin Osipov
Merged into 5.1.12
[15 Aug 2006 3:50] Paul Dubois
Noted in 5.1.12 changelog.