View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000849 | Database Workbench v5 | Visual Query Builder | public | 2014-03-19 13:31 | 2014-09-18 10:36 |
| Reporter | Glenn | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | Windows | OS | Win 7 | OS Version | Pro |
| Product Version | 4.x | ||||
| Fixed in Version | 5.0.2 | ||||
| Summary | 0000849: Visual Query Builder fails to handle escaped single quotes (MySQL) | ||||
| Description | If 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 Reproduce | Open SQL Editor for MySQL and paste this query: SELECT LoadDataTemplates.TripID, LoadDataTemplates.Template FROM LoadDataTemplates 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 Information | Only tested with MySQL. Problem affects all version I believe. | ||||
| Tags | No tags attached. | ||||
| 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 |
