Bug #109704 Selecting table_a but mysql returns table_b
Submitted: 19 Jan 2023 14:41 Modified: 28 Feb 2023 12:18
Reporter: Samantha Loh Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S5 (Performance)
Version:8.0.32 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[19 Jan 2023 14:41] Samantha Loh 
Description:
I'm just trying to do a simple select (at line 66) but no matter what table name I use, it will only return the 'products' table. I've tried running the same line on a new sql tab and it works. I also tried running the same line in the same sql tab on another line above 66 and it also works.

How to repeat:
run a select command in my sql tab
[20 Jan 2023 13:12] MySQL Verification Team 
Hello Samantha,

Thank you for the bug report.
Could you please provide SQL query you are running along with the screenshot of the issue?

Regards,
Ashwini Patil
[21 Jan 2023 13:36] Samantha Loh 
screenshot of the error

Attachment: Screenshot 2023-01-21 213535.png (image/png, text), 78.01 KiB.
[21 Jan 2023 13:37] Samantha Loh 
I have since changed my code and now running the select query gives me an error.
[31 Jan 2023 12:18] MySQL Verification Team 
Hello Samantha,

Thank you for the details.
Could you please provide error details?

Regards,
Ashwini Patil
[1 Mar 2023 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".