Bug #94160 cannot search with WHERE clause
Submitted: 31 Jan 23:57 Modified: 1 Mar 12:00
Reporter: Tiffany Leek Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:8.0.14 OS:Mac OS X
Assigned to: CPU Architecture:Any

[31 Jan 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 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 12:00] Miguel Solorzano
Thank you for the bug report. Please provide a complete repeatable test case (create table, insert data, queries).
[2 Mar 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".