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:
None 
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
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.