Bug #1138 Executing Highlighted SQL text, causes an SQL Error
Submitted: 26 Aug 2003 3:23 Modified: 27 Aug 2003 0:30
Reporter: Ronan O'Connor Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.2 OS:Linux (Redhat 8)
Assigned to: CPU Architecture:Any

[26 Aug 2003 3:23] Ronan O'Connor 
Description:
If an SQL statement, in the SQL pane of a Query window, is highlighted and then then executed, this causes "Error 1064: You have an error in your syntax near..." to be returned.

How to repeat:
Open a query window, 
type an SQL statement into the SQL pane, e.g SELECT version(); 
Highlight part of the sql statement with the mouse (eg "version();")
Execute Statement (Hit execute button or ^E).

Returns:
<HOST> ERROR 1064: You have an error in your SQL syntax near 'version()' at line 1

Suggested fix:
Highlighting shouldn't interfere with SQL :)
[26 Aug 2003 3:27] Ronan O'Connor 
Corrected Version number
[27 Aug 2003 0:30] Jorge del Conde 
Hi!

This isn't a bug;  It's the intended functionality.  What happens is if you have multiple queries in the SQL pane and you just want to execute one of them, you highlight the complete query and execute it instead of having to create another query window or query tab and type the new query there.