Bug #96687 sql query 'where' condition

• Submitted: 29 Aug 2019 4:08
• Modified: 29 Aug 2019 4:12
• Reporter: s k
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S7 (Test Cases)
• Version: 8.0.16
• OS: Windows (Microsoft Windows 10 Home)
• CPU Architecture: Any
• Tags: WBBugReporter

[29 Aug 2019 4:08] s k

Description:
when having a spacing behind the data on where condition, no record found

an example has a table call `Car`
column `name` Char(10)
column `color` Char(10)

Data
----
Nissan, red

--------------------------------------
select * from Car where color = 'red'
this working fine

select * from Car where color = 'red   '
no record found.

How to repeat:
NA

[29 Aug 2019 4:12] s k

NA