View Issue Details

IDProjectCategoryView StatusLast Update
0000849Database Workbench v5Visual Query Builderpublic2014-09-18 10:36
ReporterGlenn Assigned ToMartijn Tonies  
Status closedResolutionfixed 
PlatformWindowsOSWin 7OS VersionPro
Product Version4.x 
Fixed in Version5.0.2 
Summary0000849: Visual Query Builder fails to handle escaped single quotes (MySQL)
DescriptionIf a MySQL query contains an escaped single quote it is not recognized as escaped.

ie: WHERE Template = 'July\'12'

Clicking the Visual Query Builder button will create the error

"Unexpected token "12" at line xxx, pos xxx"

Note the Syntax Highlighting in SQL Editor does not recognize the escaped \' either.

Running the query works fine and returns the correct records.
Steps To ReproduceOpen SQL Editor for MySQL and paste this query:

WHERE Template = 'July\'12'

Note 12 is in red not green.
Clicking Visual Query Builder button creates error.

Running the query works fine if LoadDataTemplates exists of course.

Additional InformationOnly tested with MySQL.
Problem affects all version I believe.
TagsNo tags attached.



2014-05-26 17:32

reporter   ~0000280

The MySQL function CHAR() also creates an error in Visual Query Builder

Issue History

Date Modified Username Field Change
2014-03-19 13:31 Glenn New Issue
2014-03-24 08:51 Martijn Tonies Assigned To => Martijn Tonies
2014-03-24 08:51 Martijn Tonies Status new => acknowledged
2014-05-26 17:32 Glenn Note Added: 0000280
2014-09-09 14:59 Martijn Tonies Status acknowledged => assigned
2014-09-09 15:00 Martijn Tonies Project Database Workbench v4 => Database Workbench v5
2014-09-12 09:05 Martijn Tonies Status assigned => resolved
2014-09-12 09:05 Martijn Tonies Fixed in Version => 5.0.2
2014-09-12 09:05 Martijn Tonies Resolution open => fixed
2014-09-18 10:36 Martijn Tonies Status resolved => closed