felipebz / zpa

Parser and static code analysis tool for PL/SQL and Oracle SQL.
https://zpa.felipebz.com
GNU Lesser General Public License v3.0
211 stars 77 forks source link

A few leagal sql statements that fail #181

Closed dados closed 6 months ago

dados commented 6 months ago

select 'hello' , 'oracle.dbs' , 'jackie''s raincoat' , '09-mar-98' , '' , '''' , q'!name like '%dbms_%%'!' , q'<'so,' she said, 'it's finished.'>' , q'{select from employees where last_name = 'smith'}' , q'"name like '['"' , q'#name like #smth #' , q''name like 'smth '' , q'(name like )) )' , n'nchar literal' from dual / select :1, :X, :1 + 1, 1 + :2 from A where A=:3 and b= : 4 and c= :5and :A = :b / select from dual where 1 < > 2 and 1 ! = 2 and 1 ^ /aaa / -- testing = 2

felipebz commented 6 months ago

Hi,

Thank you for reporting these issues!

felipebz commented 6 months ago

Hi,

The next release will parse all the examples correctly:

image

dados commented 3 months ago

Thank you