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

[cezar0001]

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

2. 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

<between_expr>
<first_expr expr_type="simple_object_name_t">
<column_referenced_expr>

<full_name>name</full_name>
<part_name>name</part_name>

</column_referenced_expr>
</first_expr>
<second_expr expr_type="simple_constant_t">
<constant_expr>

1

</constant_expr>
</second_expr>
<third_expr expr_type="simple_constant_t">
<constant_expr>

2

</constant_expr>
</third_expr>
</between_expr>

Thanks

[sqlparser]

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