Bug #9186 Ready for Commands prompt inside comment blocks

Submitted: 15 Mar 2005 7:23 Modified: 12 May 2005 21:04
Reporter: Emanuele Dolis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.1.9 OS:
Assigned to: Jim Winstead CPU Architecture:Any

[15 Mar 2005 7:23] Emanuele Dolis
Description:
The reason why I'm classifying this thing as S3 is that the manual reads that "the mysql> prompt indicates that MySQL is ready for a new command".
When you issue a comment in the command line client starting with the /* statement, every following line starts with the mysql> prompt, which is incorrect.
MySQL in not ready for commands, at least as much as it isn't when you're typing a string or naming a field (which corrrectly causes '> and `> prompt to appear)..

This is a bit confusing if you copy a long script and paste in the client to test it.... 

How to repeat:
open a command line client and paste the following commands:

mysql> /*
mysql>
mysql>
mysql> select current_user();
mysql>
mysql>
mysql> */
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| root@%         |
+----------------+
1 row in set (0.00 sec)

mysql>

Suggested fix:
Create a new prompt to take in account that a comment block closure is pending.
[16 Mar 2005 1:33] 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/internals/23069
[7 May 2005 15:13] Jim Winstead
Fixed in 4.1.12 and 5.0.6.
[12 May 2005 21:04] Paul DuBois
Noted in 4.1.12, 5.0.6 changelogs, and in the
"Entering Queries" section.

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

Page generated in 0.051 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.