Bug #94160 cannot search with WHERE clause

• Submitted: 31 Jan 2019 23:57
• Modified: 1 Mar 2019 12:00
• Reporter: Tiffany Leek
• Status: No Feedback
• Category: MySQL Server: DML
• Severity: S2 (Serious)
• Version: 8.0.14
• OS: MacOS
• CPU Architecture: Any

[31 Jan 2019 23:57] Tiffany Leek

Description:
If I put any where clause in a SQL statement, I get the error 'SELECT' is not valid at this position for this server version, expecting : '(' , WITH 

sample SQL:

SELECT * FROM staging.last_message 
where table = 'controller';

How to repeat:
search with any where clause

[1 Feb 2019 0:03] Tiffany Leek

Connecting to  a 5.6 MySQl DB but preferred version is set to 5.6, so that should be OK??

[1 Feb 2019 12:00] MySQL Verification Team

Thank you for the bug report. Please provide a complete repeatable test case (create table, insert data, queries).

[2 Mar 2019 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".