Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Sql wrong lexical analysis for string literals - escaped single quotes are misparsed

Description

Regression in version 3.5

same xml + sql file work perfectly fine up till version 3.4.2

In SimpleSqlGrammer.jj
Token of S_CHAR_LITERAL is not parsed well when an escaped single quote character is included in the literal ( \' )

results in an exception

attached xml and sql files

Environment

Windows, Linux

Attachments

2

Activity

Show:

Nathan Voxland 
February 19, 2018 at 5:36 AM

I've made some additional changes for 3.6.0 and I am no longer able to replicate the issue

Eduard Panov 
January 24, 2018 at 11:59 AM

Me too, I found the same bug in 3.5.3 on MSSQL database.

Matthieu Truchet 
January 17, 2018 at 2:10 PM

Me too, I found the same bug in 3.5.3 on Oracle database.

Jonas Santos Bezerra 
October 9, 2017 at 1:16 PM

I found the same bug still occurs on version 3.5.3.

I am using SQL Server 2012.

Nathan Voxland 
August 4, 2016 at 2:55 PM

Merged pull request

Fixed

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created July 30, 2016 at 12:04 PM
Updated December 16, 2019 at 11:42 AM
Resolved February 19, 2018 at 5:36 AM