Bug #96687 sql query 'where' condition
Submitted: 29 Aug 2019 4:08 Modified: 29 Aug 2019 4:12
Reporter: s k Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S7 (Test Cases)
Version:8.0.16 OS:Microsoft Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[29 Aug 2019 4:08] s k
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)

Nissan, red

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

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

How to repeat:
[29 Aug 2019 4:12] s k