Bug #66887 cant able execute query starting with open bracket and ending with close bracket
Submitted: 20 Sep 2012 7:15 Modified: 9 Jan 2015 9:50
Reporter: mohan raja Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.43 OS:Linux (Linux 3.2.0-30-generic-pae)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[20 Sep 2012 7:15] mohan raja
i cant able to execute some of the query which worked in previous version.
(select * from tablename;)

(select * from tn1) union (select * from tn2)

----- Developer Notes -----

MySQL Workbench CE for Linux/Unix version 5.2.43  revision 9869
Configuration Directory: /home/user1/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.10.2
OS: Linux 3.2.0-30-generic-pae
CPU: 2x Intel(R) Core(TM)2 Duo CPU     E7500  @ 2.93GHz 1603.000 MHz, 3.9 GB RAM
Distribution: Ubuntu 12.04.1 LTS

How to repeat:
just try to execute the following queries
(select * from tablename)

(select * from tn1) union (select * from tn2)
[20 Sep 2012 7:27] mohan raja
Query is not returning any error. But it fails to show the result. No rows are returning.
[20 Sep 2012 15:47] MySQL Verification Team
Thank you for the bug report. Verified on Windows.
[4 Nov 2012 2:55] Alfredo Kojima
Bug #67298 is a duplicate