search

sqlparser / gsp_demo_java

Java demos for the General SQL Parser library
127 stars 68 forks source link

XML serialization is not correct for Oracle for negative operators - IN/LIKE/BETWEEN #24

Open cezar0001 opened 1 year ago

cezar0001 commented 1 year ago

Hi, I have identified that the prepared XML tree for Oracle SQL is not entirely correct for operators NOT IN/NOT LIKE/NOT BETWEEN

  1. NOT IN - see the example below, in_expr tag contains the attribute not but the xsd doesn't specify it

Stmt - select * from table1 where name not in (1,2,3) XML tree part

**** name name 1 2 3
  1. NOT LIKE/NOT BETWEEN Despite the fact that xsd defines that both these operators should contain attribute NOT, it is not populated for any of them (see example below)

Stmt - select * from table1 where name not between 1 and 2 XML tree part

**__** name name 1 2

Thanks

sqlparser commented 1 year ago

checking this issue now: /gudusoft/projects/149484/tasks/list?issue_type_category=task&issue=I69P61