Bug #101167 "(" is not valid at this position
Submitted: 14 Oct 2020 12:08 Modified: 11 Feb 12:56
Reporter: vamshi j Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.21 OS:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[14 Oct 2020 12:08] vamshi j
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\HP\AppData\Roaming\MySQL\Workbench\log\wb.log]

(SELECT DISTINCT Pnumber,
FROM project,department,employee
WHERE Dnum=Dnumber and Mgr_ssn and lname ='javvaji')
UNION
(SELECT DISTINCT Pnumber
FROM project,works_on,employee
WHERE Pnumber=Pno and Essn=ssn
and lname='javvaji');

How to repeat:
and kindly update 

Suggested fix:
(SELECT DISTINCT Pnumber,
FROM project,department,employee
WHERE Dnum=Dnumber and Mgr_ssn and lname ='javvaji')
UNION
(SELECT DISTINCT Pnumber
FROM project,works_on,employee
WHERE Pnumber=Pno and Essn=ssn
and lname='javvaji');
[11 Jan 12:56] MySQL Verification Team
Hello vamshi,

Thank you for the bug report.
Could you please provide table structure with test data in .sql format to investigate at our end? Thank you.

Regards,
Ashwini Patil
[12 Feb 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".