Bug #19890 mysqltest: "query" command is broken

• Submitted: 17 May 2006 16:19
• Modified: 15 Aug 2006 3:50
• Reporter: Paul DuBois
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: all
• Assigned to: Magnus Blåudd
• CPU Architecture: Any

[17 May 2006 16:19] Paul DuBois

Description:
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:

  http://lists.mysql.com/commits/9580

[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.