MySQL Bugs: #101167: "(" is not valid at this position

Bug #101167	"(" is not valid at this position
Submitted:	14 Oct 2020 12:08	Modified:	11 Feb 2021 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:	Windows (Microsoft Windows 10 Pro)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	WBBugReporter

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');

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

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".