Bug #79371 Bug in error detection
Submitted: 21 Nov 2015 8:46 Modified: 18 May 2016 3:44
Reporter: Zero Wu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.4, 6.3.5 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[21 Nov 2015 8:46] Zero Wu
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Ranger\AppData\Roaming\MySQL\Workbench\log\wb.log]

How to repeat:
Open SQL editor and put the flowing lines in it.

SELECT 
    name
FROM
    instructor
WHERE
    salary > SOME (SELECT 
            salary
        FROM
            instructor
        WHERE
            dept_name = 'Biology');

An syntax error warning will occur in the left parenthesis prompting 'missing 'closing parenthesis''. But actually this piece of SQL script can be successfully executed and produces the correct results.
[21 Nov 2015 12:56] MySQL Verification Team
Hello!

Thank you for the report.
Verified as described with WB 6.3.5 on Win7.

Thanks,
Umesh
[21 Nov 2015 12:58] MySQL Verification Team
//
Use valid SQL statement and observe that SQL Editor shows SYNTAX error

SELECT 
    1
FROM DUAL WHERE
    1 <> SOME (SELECT 
            1
        FROM DUAL WHERE
            1 = 1);
[18 May 2016 3:44] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

Under certain circumstances, sub-queries were reported as syntax errors.

Thank you for the bug report.