Bug #101167 "(" is not valid at this position

• Submitted: 14 Oct 2020 12:08
• Modified: 11 Feb 12:56
• Reporter: vamshi j
• Status: No Feedback
• 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".