Bug #18898 | SELECT * problem | ||
---|---|---|---|
Submitted: | 7 Apr 2006 20:07 | Modified: | 8 Apr 2006 1:02 |
Reporter: | Sebastien Caisse | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.19 | OS: | Windows (WindowsXP sp2) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[7 Apr 2006 20:07]
Sebastien Caisse
[8 Apr 2006 1:02]
MySQL Verification Team
Thank you for the bug report. The SQL syntax error for the Step 3 it is a bug already reported for Query Browser, not the server. Please test with the mysql.exe client tool: Step 3: SELECT * FROM `events` e; (fails) and Step 5: SELECT (* ) FROM `events` e; (fails) the server gives you the correct error message: mysql> SELECT (* ) -> FROM `events` e; ERROR 1064 (42000): 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 '* ) FROM `events` e' at line 1 So this bug is a duplicate having the category defined for Query Browser and not a bug for Category Server.