This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 875680d91ee Support SQL parsing of Oracle not equals operators
containing spaces (#34721)
875680d91ee is described below
commit 875680d91eea493937f468479e5c2a2fb90cc726
Author: ZhangCheng <chengzh...@apache.org>
AuthorDate: Wed Feb 19 17:16:06 2025 +0800
Support SQL parsing of Oracle not equals operators containing spaces
(#34721)
---
.../src/main/antlr4/imports/oracle/BaseRule.g4 | 2 +-
.../parser/src/main/resources/case/dml/select.xml | 54 ++++++++++++++++++++++
.../main/resources/sql/supported/dml/select.xml | 1 +
3 files changed, 56 insertions(+), 1 deletion(-)
diff --git
a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
index 83bb043915b..5ae3c952ebe 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
@@ -694,7 +694,7 @@ booleanPrimary
;
comparisonOperator
- : EQ_ | GTE_ | GT_ | LTE_ | LT_ | NEQ_ | (GT_ | LT_) EQ_
+ : EQ_ | GTE_ | GT_ | LTE_ | LT_ | NEQ_ | (GT_ | LT_) EQ_ | LT_ GT_ | (NOT_
| CARET_) EQ_
;
predicate
diff --git a/test/it/parser/src/main/resources/case/dml/select.xml
b/test/it/parser/src/main/resources/case/dml/select.xml
index 5ce9ca406aa..1a38e24eda4 100644
--- a/test/it/parser/src/main/resources/case/dml/select.xml
+++ b/test/it/parser/src/main/resources/case/dml/select.xml
@@ -10106,4 +10106,58 @@
</expr>
</where>
</select>
+
+ <select sql-case-id="select_with_not_equal_comparison_with_space">
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7"/>
+ </projections>
+ <from start-index="14" stop-index="17">
+ <simple-table name="test" start-index="14" stop-index="17"/>
+ </from>
+ <where start-index="19" stop-index="62">
+ <expr start-index="25" stop-index="62">
+ <binary-operation-expression start-index="25" stop-index="62">
+ <left start-index="25" stop-index="49">
+ <binary-operation-expression start-index="25"
stop-index="49">
+ <left start-index="25" stop-index="33">
+ <binary-operation-expression start-index="25"
stop-index="33">
+ <left start-index="25" stop-index="26">
+ <column name="id" start-index="25"
stop-index="26"/>
+ </left>
+ <operator><></operator>
+ <right start-index="33" stop-index="33">
+ <literal-expression value="1"
start-index="33" stop-index="33"/>
+ </right>
+ </binary-operation-expression>
+ </left>
+ <operator>and</operator>
+ <right start-index="39" stop-index="49">
+ <binary-operation-expression start-index="39"
stop-index="49">
+ <left start-index="39" stop-index="42">
+ <column name="name" start-index="39"
stop-index="42"/>
+ </left>
+ <operator>!=</operator>
+ <right start-index="49" stop-index="49">
+ <literal-expression value="1"
start-index="49" stop-index="49"/>
+ </right>
+ </binary-operation-expression>
+ </right>
+ </binary-operation-expression>
+ </left>
+ <operator>and</operator>
+ <right start-index="55" stop-index="62">
+ <binary-operation-expression start-index="55"
stop-index="62">
+ <left start-index="55" stop-index="56">
+ <column name="id" start-index="55"
stop-index="56"/>
+ </left>
+ <operator>^=</operator>
+ <right start-index="62" stop-index="62">
+ <literal-expression value="3" start-index="62"
stop-index="62"/>
+ </right>
+ </binary-operation-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/select.xml
b/test/it/parser/src/main/resources/sql/supported/dml/select.xml
index a0bdd86fc17..e287716cc16 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/select.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/select.xml
@@ -316,4 +316,5 @@
<sql-case id="select_with_mixed_single_double_quoted_literals"
value="SELECT 'x' "x" 'x' FROM t_order WHERE status LIKE
"%" '123' "%"" db-types="MySQL"/>
<sql-case id="select_is_not_nan" value="SELECT COUNT(*) FROM employees
WHERE commission_pct IS NOT NAN" db-types="Oracle"/>
<sql-case id="select_with_comparison_with_space" value="select * from test
where id > = 1 or name < = 2" db-types="Oracle"/>
+ <sql-case id="select_with_not_equal_comparison_with_space" value="select *
from test where id < > 1 and name ! = 1 and id ^ = 3 "
db-types="Oracle"/>
</sql-cases>
