This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 41acc6d2114 Add SQL parser test cases for SQL92 (#37727)
41acc6d2114 is described below
commit 41acc6d2114f7fd8d192be10c6ebbc2c389af61c
Author: Liang Zhang <[email protected]>
AuthorDate: Tue Jan 13 17:35:20 2026 +0800
Add SQL parser test cases for SQL92 (#37727)
---
.../parser/src/main/resources/case/dcl/grant.xml | 5 +
.../parser/src/main/resources/case/dcl/revoke.xml | 5 +
.../src/main/resources/case/ddl/create-table.xml | 11 +
.../src/main/resources/case/ddl/drop-table.xml | 4 +
.../parser/src/main/resources/case/dml/delete.xml | 17 ++
.../parser/src/main/resources/case/dml/insert.xml | 33 +++
.../src/main/resources/case/dml/select-join.xml | 32 +++
.../main/resources/case/dml/select-sub-query.xml | 74 +++++++
.../parser/src/main/resources/case/dml/select.xml | 241 +++++++++++++++++++++
.../parser/src/main/resources/case/dml/update.xml | 27 +++
.../parser/src/main/resources/case/tcl/commit.xml | 1 +
.../src/main/resources/case/tcl/rollback.xml | 1 +
.../main/resources/case/tcl/set-transaction.xml | 1 +
.../resources/sql/supported/dcl/grant-user.xml | 1 +
.../resources/sql/supported/dcl/revoke-user.xml | 1 +
.../resources/sql/supported/ddl/create-table.xml | 1 +
.../resources/sql/supported/ddl/drop-table.xml | 1 +
.../main/resources/sql/supported/dml/delete.xml | 1 +
.../main/resources/sql/supported/dml/insert.xml | 2 +
.../main/resources/sql/supported/dml/select.xml | 15 ++
.../main/resources/sql/supported/dml/update.xml | 1 +
.../main/resources/sql/supported/tcl/commit.xml | 1 +
.../main/resources/sql/supported/tcl/rollback.xml | 1 +
.../sql/supported/tcl/set-transaction.xml | 1 +
24 files changed, 478 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/dcl/grant.xml
b/test/it/parser/src/main/resources/case/dcl/grant.xml
index 023a61bb8cc..cfdca4b9083 100644
--- a/test/it/parser/src/main/resources/case/dcl/grant.xml
+++ b/test/it/parser/src/main/resources/case/dcl/grant.xml
@@ -304,4 +304,9 @@
<grant sql-case-id="grant_create_tablespace_doris" />
<grant sql-case-id="grant_create_role_privilege_doris" />
<grant sql-case-id="grant_drop_role_privilege_doris" />
+
+ <grant sql-case-id="grant_select_sql92">
+ <table name="t_order" start-index="27" stop-index="33" />
+ <column name="order_id" start-index="14" stop-index="21" />
+ </grant>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dcl/revoke.xml
b/test/it/parser/src/main/resources/case/dcl/revoke.xml
index 3c5c27a9a76..aa2200e20dc 100644
--- a/test/it/parser/src/main/resources/case/dcl/revoke.xml
+++ b/test/it/parser/src/main/resources/case/dcl/revoke.xml
@@ -261,4 +261,9 @@
<revoke sql-case-id="revoke_create_tablespace_doris" />
<revoke sql-case-id="revoke_create_role_privilege_doris" />
<revoke sql-case-id="revoke_drop_role_privilege_doris" />
+
+ <revoke sql-case-id="revoke_select_sql92">
+ <table name="t_order" start-index="28" stop-index="34" />
+ <column name="order_id" start-index="14" stop-index="21" />
+ </revoke>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-table.xml
b/test/it/parser/src/main/resources/case/ddl/create-table.xml
index 327f93a0fe3..c8c8d562d23 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-table.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-table.xml
@@ -586,6 +586,17 @@
</column-definition>
</create-table>
+ <create-table sql-case-id="create_table_constraint_sql92">
+ <table name="t_constraint" start-index="13" stop-index="24" />
+ <column-definition type="INT" primary-key="true" start-index="27"
stop-index="50">
+ <column name="order_id" />
+ </column-definition>
+ <column-definition type="VARCHAR" start-index="53" stop-index="70">
+ <column name="status" />
+ </column-definition>
+ <constraint-definition start-index="73" stop-index="119" />
+ </create-table>
+
<create-table sql-case-id="create_table_with_inline_constraints">
<table name="t_order" start-index="13" stop-index="19" />
<column-definition type="INT" primary-key="true" start-index="22"
stop-index="52">
diff --git a/test/it/parser/src/main/resources/case/ddl/drop-table.xml
b/test/it/parser/src/main/resources/case/ddl/drop-table.xml
index 153832b8d52..d0c6951a3b4 100644
--- a/test/it/parser/src/main/resources/case/ddl/drop-table.xml
+++ b/test/it/parser/src/main/resources/case/ddl/drop-table.xml
@@ -123,4 +123,8 @@
<drop-table sql-case-id="drop_table_firebird">
<table name="t_firebird_drop" start-index="11" stop-index="25" />
</drop-table>
+
+ <drop-table sql-case-id="drop_table_sql92">
+ <table name="t_drop" start-index="11" stop-index="16" />
+ </drop-table>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/delete.xml
b/test/it/parser/src/main/resources/case/dml/delete.xml
index a597f2cdbfd..d98dbcb2304 100644
--- a/test/it/parser/src/main/resources/case/dml/delete.xml
+++ b/test/it/parser/src/main/resources/case/dml/delete.xml
@@ -874,4 +874,21 @@
<delete sql-case-id="delete_without_where_sql92">
<table name="t_order" start-index="12" stop-index="18" />
</delete>
+
+ <delete sql-case-id="delete_with_where_sql92">
+ <table name="t_order" start-index="12" stop-index="18" />
+ <where start-index="20" stop-index="37">
+ <expr>
+ <binary-operation-expression start-index="26" stop-index="37">
+ <left>
+ <column name="order_id" start-index="26"
stop-index="33" />
+ </left>
+ <operator>=</operator>
+ <right>
+ <literal-expression value="1" start-index="37"
stop-index="37" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </delete>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/insert.xml
b/test/it/parser/src/main/resources/case/dml/insert.xml
index 34aa02ddea1..2d8fb685f24 100644
--- a/test/it/parser/src/main/resources/case/dml/insert.xml
+++ b/test/it/parser/src/main/resources/case/dml/insert.xml
@@ -5548,4 +5548,37 @@
</value>
</values>
</insert>
+
+ <insert sql-case-id="insert_with_columns_sql92">
+ <table name="t_order" start-index="12" stop-index="18" />
+ <columns start-index="19" stop-index="36">
+ <column name="order_id" start-index="20" stop-index="27" />
+ <column name="status" start-index="30" stop-index="35" />
+ </columns>
+ <values>
+ <value>
+ <assignment-value>
+ <literal-expression value="1" start-index="46"
stop-index="46" />
+ </assignment-value>
+ <assignment-value>
+ <literal-expression value="ok" start-index="49"
stop-index="52" />
+ </assignment-value>
+ </value>
+ </values>
+ </insert>
+
+ <insert sql-case-id="insert_without_columns_sql92">
+ <table name="t_order" start-index="12" stop-index="18" />
+ <columns start-index="19" stop-index="19" />
+ <values>
+ <value>
+ <assignment-value>
+ <literal-expression value="1" start-index="28"
stop-index="28" />
+ </assignment-value>
+ <assignment-value>
+ <literal-expression value="ok" start-index="31"
stop-index="34" />
+ </assignment-value>
+ </value>
+ </values>
+ </insert>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/select-join.xml
b/test/it/parser/src/main/resources/case/dml/select-join.xml
index 7aa9081259d..34d7590eccf 100644
--- a/test/it/parser/src/main/resources/case/dml/select-join.xml
+++ b/test/it/parser/src/main/resources/case/dml/select-join.xml
@@ -3581,4 +3581,36 @@
</join-table>
</from>
</select>
+
+ <select sql-case-id="select_comma_join_sql92">
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <from>
+ <join-table join-type="COMMA">
+ <left>
+ <simple-table name="t_order" alias="o" start-index="14"
stop-index="22" />
+ </left>
+ <right>
+ <simple-table name="t_order_item" alias="i"
start-index="25" stop-index="38" />
+ </right>
+ </join-table>
+ </from>
+ </select>
+
+ <select sql-case-id="select_cross_join_sql92">
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <from>
+ <join-table join-type="CROSS">
+ <left>
+ <simple-table name="t_order" start-index="14"
stop-index="20" />
+ </left>
+ <right>
+ <simple-table name="t_order_item" start-index="33"
stop-index="44" />
+ </right>
+ </join-table>
+ </from>
+ </select>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/select-sub-query.xml
b/test/it/parser/src/main/resources/case/dml/select-sub-query.xml
index e17adcc89e3..cc833386ff1 100644
--- a/test/it/parser/src/main/resources/case/dml/select-sub-query.xml
+++ b/test/it/parser/src/main/resources/case/dml/select-sub-query.xml
@@ -972,4 +972,78 @@
</subquery-table>
</from>
</select>
+
+ <select sql-case-id="select_subquery_projection_sql92">
+ <from>
+ <simple-table name="t_order" start-index="27" stop-index="33" />
+ </from>
+ <projections start-index="7" stop-index="20">
+ <subquery-projection start-index="7" stop-index="16" alias="sub"
text="(SELECT 1)" literal-text="(SELECT 1)">
+ <subquery>
+ <select>
+ <projections start-index="15" stop-index="15">
+ <expression-projection text="1" start-index="15"
stop-index="15">
+ <expr>
+ <literal-expression value="1"
start-index="15" stop-index="15" />
+ </expr>
+ </expression-projection>
+ </projections>
+ </select>
+ </subquery>
+ </subquery-projection>
+ </projections>
+ </select>
+
+ <select sql-case-id="select_not_in_subquery_sql92">
+ <projections start-index="7" stop-index="14">
+ <column-projection name="order_id" start-index="7" stop-index="14"
/>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="21" stop-index="27" />
+ </from>
+ <where start-index="29" stop-index="60">
+ <expr>
+ <in-expression start-index="35" stop-index="60">
+ <not>true</not>
+ <left>
+ <column name="order_id" start-index="35"
stop-index="42" />
+ </left>
+ <right>
+ <subquery start-index="51" stop-index="60">
+ <select>
+ <projections start-index="59" stop-index="59">
+ <expression-projection text="1"
start-index="59" stop-index="59">
+ <expr>
+ <literal-expression value="1"
start-index="59" stop-index="59" />
+ </expr>
+ </expression-projection>
+ </projections>
+ </select>
+ </subquery>
+ </right>
+ </in-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="select_subquery_table_sql92">
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <from>
+ <subquery-table alias="t" start-index="14" stop-index="25">
+ <subquery start-index="14" stop-index="23">
+ <select>
+ <projections start-index="22" stop-index="22">
+ <expression-projection text="1" start-index="22"
stop-index="22">
+ <expr>
+ <literal-expression value="1"
start-index="22" stop-index="22" />
+ </expr>
+ </expression-projection>
+ </projections>
+ </select>
+ </subquery>
+ </subquery-table>
+ </from>
+ </select>
</sql-parser-test-cases>
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 e6e2ff86c46..d709d18f84b 100644
--- a/test/it/parser/src/main/resources/case/dml/select.xml
+++ b/test/it/parser/src/main/resources/case/dml/select.xml
@@ -12654,6 +12654,247 @@
</from>
</select>
+ <select sql-case-id="select_all_param_alias_schema_sql92" parameters="1">
+ <projections start-index="11" stop-index="20">
+ <expression-projection text="1" start-index="11" stop-index="20"
alias="aid">
+ <expr>
+ <literal-expression value="1" start-index="11"
stop-index="11" />
+ <parameter-marker-expression parameter-index="0"
start-index="11" stop-index="11" />
+ </expr>
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="27" stop-index="41">
+ <owner name="schema1" start-index="27" stop-index="33" />
+ </simple-table>
+ </from>
+ <where start-index="43" stop-index="80">
+ <expr>
+ <binary-operation-expression start-index="49" stop-index="80">
+ <left>
+ <binary-operation-expression start-index="50"
stop-index="61">
+ <left>
+ <column name="order_id" start-index="50"
stop-index="57" />
+ </left>
+ <operator>=</operator>
+ <right>
+ <literal-expression value="1" start-index="61"
stop-index="61" />
+ </right>
+ </binary-operation-expression>
+ </left>
+ <operator>OR</operator>
+ <right>
+ <binary-operation-expression start-index="67"
stop-index="80">
+ <left>
+ <column name="active" start-index="67"
stop-index="72" />
+ </left>
+ <operator>IS</operator>
+ <right>
+ <literal-expression value="NULL"
start-index="77" stop-index="80" />
+ </right>
+ </binary-operation-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="select_like_between_and_sql92">
+ <projections start-index="7" stop-index="12">
+ <column-projection name="status" start-index="7" stop-index="12" />
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="19" stop-index="25" />
+ </from>
+ <where start-index="27" stop-index="78">
+ <expr>
+ <binary-operation-expression start-index="33" stop-index="78">
+ <left>
+ <binary-operation-expression start-index="33"
stop-index="48">
+ <left>
+ <column name="status" start-index="33"
stop-index="38" />
+ </left>
+ <operator>LIKE</operator>
+ <right>
+ <list-expression start-index="45"
stop-index="48">
+ <items>
+ <literal-expression value="1%"
start-index="45" stop-index="48" />
+ </items>
+ </list-expression>
+ </right>
+ </binary-operation-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="54" stop-index="78">
+ <left>
+ <column name="order_id" start-index="54"
stop-index="61" />
+ </left>
+ <between-expr>
+ <literal-expression value="1" start-index="71"
stop-index="71" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10"
start-index="77" stop-index="78" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="select_safe_eq_sql92">
+ <projections start-index="7" stop-index="14">
+ <column-projection name="order_id" start-index="7" stop-index="14"
/>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="21" stop-index="27" />
+ </from>
+ <where start-index="29" stop-index="48">
+ <expr>
+ <binary-operation-expression start-index="35" stop-index="48">
+ <left>
+ <column name="order_id" start-index="35"
stop-index="42" />
+ </left>
+ <operator><=></operator>
+ <right>
+ <literal-expression value="1" start-index="48"
stop-index="48" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="select_in_list_sql92">
+ <projections start-index="7" stop-index="14">
+ <column-projection name="order_id" start-index="7" stop-index="14"
/>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="21" stop-index="27" />
+ </from>
+ <where start-index="29" stop-index="52">
+ <expr>
+ <in-expression start-index="35" stop-index="52">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="35"
stop-index="42" />
+ </left>
+ <right>
+ <list-expression start-index="47" stop-index="52">
+ <items>
+ <literal-expression value="1" start-index="48"
stop-index="48" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="51"
stop-index="51" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="select_not_between_sql92">
+ <projections start-index="7" stop-index="14">
+ <column-projection name="order_id" start-index="7" stop-index="14"
/>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="21" stop-index="27" />
+ </from>
+ <where start-index="29" stop-index="62">
+ <expr>
+ <between-expression start-index="35" stop-index="62">
+ <not>true</not>
+ <left>
+ <column name="order_id" start-index="35"
stop-index="42" />
+ </left>
+ <between-expr>
+ <literal-expression value="1" start-index="56"
stop-index="56" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="2" start-index="62"
stop-index="62" />
+ </and-expr>
+ </between-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="select_addition_expr_sql92">
+ <projections start-index="7" stop-index="18">
+ <expression-projection text="order_id + 1" start-index="7"
stop-index="18">
+ <expr>
+ <binary-operation-expression start-index="7"
stop-index="18">
+ <left>
+ <column name="order_id" start-index="7"
stop-index="14" />
+ </left>
+ <operator>+</operator>
+ <right>
+ <literal-expression value="1" start-index="18"
stop-index="18" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="25" stop-index="31" />
+ </from>
+ </select>
+
+ <select sql-case-id="select_hex_literal_sql92">
+ <projections start-index="7" stop-index="9">
+ <column-projection name="0x1" start-index="7" stop-index="9" />
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="16" stop-index="22" />
+ </from>
+ </select>
+
+ <select sql-case-id="select_bit_literal_sql92">
+ <projections start-index="7" stop-index="10">
+ <expression-projection text="B'1'" start-index="7" stop-index="10">
+ <expr>
+ <common-expression text="B'1'" start-index="7"
stop-index="10" />
+ </expr>
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="17" stop-index="23" />
+ </from>
+ </select>
+
+ <select sql-case-id="select_cast_literal_sql92">
+ <projections start-index="7" stop-index="20">
+ <expression-projection text="CAST(1 AS INT)" start-index="7"
stop-index="20">
+ <expr>
+ <function function-name="CAST" text="CAST(1 AS INT)"
start-index="7" stop-index="20">
+ <parameter>
+ <literal-expression value="1" start-index="12"
stop-index="12" />
+ </parameter>
+ <parameter>
+ <data-type value="INT" start-index="17"
stop-index="19" />
+ </parameter>
+ </function>
+ </expr>
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="27" stop-index="33" />
+ </from>
+ </select>
+
+ <select sql-case-id="select_boolean_literal_sql92">
+ <projections start-index="7" stop-index="10">
+ <expression-projection text="true" start-index="7" stop-index="10">
+ <expr>
+ <literal-expression value="true" start-index="7"
stop-index="10" />
+ </expr>
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table name="t_order" start-index="17" stop-index="23" />
+ </from>
+ </select>
+
<select sql-case-id="select_subquery_with_with_firebird">
<projections start-index="7" stop-index="7">
<shorthand-projection start-index="7" stop-index="7" />
diff --git a/test/it/parser/src/main/resources/case/dml/update.xml
b/test/it/parser/src/main/resources/case/dml/update.xml
index eb984c1752c..c2cf2997585 100644
--- a/test/it/parser/src/main/resources/case/dml/update.xml
+++ b/test/it/parser/src/main/resources/case/dml/update.xml
@@ -280,6 +280,33 @@
</set>
</update>
+ <update sql-case-id="update_with_where_sql92">
+ <table start-index="7" stop-index="13">
+ <simple-table name="t_order" start-index="7" stop-index="13" />
+ </table>
+ <set start-index="15" stop-index="30">
+ <assignment start-index="19" stop-index="30">
+ <column name="status" start-index="19" stop-index="24" />
+ <assignment-value>
+ <literal-expression value="x" start-index="28"
stop-index="30" />
+ </assignment-value>
+ </assignment>
+ </set>
+ <where start-index="32" stop-index="49">
+ <expr>
+ <binary-operation-expression start-index="38" stop-index="49">
+ <left>
+ <column name="order_id" start-index="38"
stop-index="45" />
+ </left>
+ <operator>=</operator>
+ <right>
+ <literal-expression value="1" start-index="49"
stop-index="49" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </update>
+
<update sql-case-id="update_with_extra_keywords" parameters="'update', 1,
1">
<table start-index="27" stop-index="33">
<simple-table name="t_order" start-index="27" stop-index="33" />
diff --git a/test/it/parser/src/main/resources/case/tcl/commit.xml
b/test/it/parser/src/main/resources/case/tcl/commit.xml
index edfd8b6ca14..07b955d644b 100644
--- a/test/it/parser/src/main/resources/case/tcl/commit.xml
+++ b/test/it/parser/src/main/resources/case/tcl/commit.xml
@@ -28,4 +28,5 @@
<commit sql-case-id="commit_work" />
<commit sql-case-id="commit_write_batch" />
<commit sql-case-id="commit_work_force" />
+ <commit sql-case-id="commit_sql92" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/tcl/rollback.xml
b/test/it/parser/src/main/resources/case/tcl/rollback.xml
index 221f27ed03e..bd364ed0ebc 100644
--- a/test/it/parser/src/main/resources/case/tcl/rollback.xml
+++ b/test/it/parser/src/main/resources/case/tcl/rollback.xml
@@ -26,4 +26,5 @@
<rollback sql-case-id="rollback_in_pg" />
<rollback sql-case-id="rollback_work_force" />
<rollback sql-case-id="abort" />
+ <rollback sql-case-id="rollback_sql92" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
b/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
index c0d906c5941..3526a18032d 100644
--- a/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
+++ b/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
@@ -31,6 +31,7 @@
<set-transaction sql-case-id="set_transaction_with_name" />
<set-transaction sql-case-id="set_transaction_snapshot" />
<set-transaction sql-case-id="set_session_transaction_doris" />
+ <set-transaction sql-case-id="set_transaction_sql92" />
<xa sql-case-id="xa_recover" />
<xa sql-case-id="xa_start" />
<xa sql-case-id="xa_begin" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
index 0d025e663c1..0e08d93f4eb 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
@@ -179,4 +179,5 @@
<sql-case id="grant_create_tablespace_doris" value="GRANT CREATE
TABLESPACE ON *.* TO user1" db-types="Doris" />
<sql-case id="grant_create_role_privilege_doris" value="GRANT CREATE ROLE
ON *.* TO user1" db-types="Doris" />
<sql-case id="grant_drop_role_privilege_doris" value="GRANT DROP ROLE ON
*.* TO user1" db-types="Doris" />
+ <sql-case id="grant_select_sql92" value="GRANT SELECT (order_id) ON
t_order TO user1" db-types="SQL92" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
index 8209c4967bb..d7e452f6566 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
@@ -158,4 +158,5 @@
<sql-case id="revoke_create_tablespace_doris" value="REVOKE CREATE
TABLESPACE ON *.* FROM user1" db-types="Doris" />
<sql-case id="revoke_create_role_privilege_doris" value="REVOKE CREATE
ROLE ON *.* FROM user1" db-types="Doris" />
<sql-case id="revoke_drop_role_privilege_doris" value="REVOKE DROP ROLE ON
*.* FROM user1" db-types="Doris" />
+ <sql-case id="revoke_select_sql92" value="REVOKE SELECT (order_id) ON
t_order FROM user1" db-types="SQL92" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
index 52813c2283d..3b45824e766 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
@@ -67,6 +67,7 @@
<sql-case id="create_table_with_inline_unique_key" value="CREATE TABLE
t_order (order_id INT UNIQUE, user_id INT, status VARCHAR(10), column1
VARCHAR(10), column2 VARCHAR(10), column3 VARCHAR(10))"
db-types="MySQL,Oracle,PostgreSQL,openGauss" />
<sql-case id="create_table_with_inline_foreign_key" value="CREATE TABLE
t_order_item (item_id INT, order_id INT REFERENCES t_order (order_id) ON UPDATE
CASCADE ON DELETE CASCADE, user_id INT, status VARCHAR(10), column1
VARCHAR(10), column2 VARCHAR(10), column3 VARCHAR(10))" db-types="MySQL" />
<sql-case id="create_table_with_inline_foreign_key_sql92" value="CREATE
TABLE t_order_item (item_id INT, order_id INT REFERENCES t_order (order_id) ON
UPDATE CASCADE ON DELETE CASCADE, user_id INT, status VARCHAR(10), column1
VARCHAR(10), column2 VARCHAR(10), column3 VARCHAR(10))" db-types="SQL92" />
+ <sql-case id="create_table_constraint_sql92" value="CREATE TABLE
t_constraint (order_id INT PRIMARY KEY, status VARCHAR(10), CONSTRAINT
ck_status CHECK (status IS NOT NULL))" db-types="SQL92" />
<sql-case id="create_table_with_inline_constraints" value="CREATE TABLE
t_order (order_id INT PRIMARY KEY UNIQUE, user_id INT, status VARCHAR(10),
column1 VARCHAR(10), column2 VARCHAR(10), column3 VARCHAR(10))"
db-types="MySQL,Oracle,PostgreSQL,openGauss" />
<sql-case id="create_table_with_out_of_line_primary_key" value="CREATE
TABLE t_order (order_id INT, user_id INT, status VARCHAR(10), column1
VARCHAR(10), column2 VARCHAR(10), column3 VARCHAR(10), CONSTRAINT pk_order_id
PRIMARY KEY (order_id))" />
<sql-case id="create_table_with_out_of_line_composite_primary_key"
value="CREATE TABLE t_order (order_id INT, user_id INT, status VARCHAR(10),
column1 VARCHAR(10), column2 VARCHAR(10), column3 VARCHAR(10), CONSTRAINT
pk_order_id PRIMARY KEY (order_id, user_id, status))" />
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/drop-table.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/drop-table.xml
index 50800d0f5c3..b84d17dcbd0 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/drop-table.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/drop-table.xml
@@ -42,4 +42,5 @@
<sql-case id="drop_table_purge_hive_with_db" value="DROP TABLE
test_db.t_log PURGE" db-types="Hive" />
<sql-case id="drop_table_if_exists_purge_hive_with_db" value="DROP TABLE
IF EXISTS test_db.t_log PURGE" db-types="Hive" />
<sql-case id="drop_table_firebird" value="DROP TABLE t_firebird_drop"
db-types="Firebird"/>
+ <sql-case id="drop_table_sql92" value="DROP TABLE t_drop" db-types="SQL92"
/>
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
b/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
index 6bfea83ac69..7aa585eac20 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
@@ -51,4 +51,5 @@
<sql-case id="delete_hive_basic" value="DELETE FROM orders"
db-types="Hive" />
<sql-case id="delete_with_where" value="DELETE FROM orders WHERE order_id
= 9527;" db-types="Hive" />
<sql-case id="delete_without_where_sql92" value="DELETE FROM t_order"
db-types="SQL92" />
+ <sql-case id="delete_with_where_sql92" value="DELETE FROM t_order WHERE
order_id = 1" db-types="SQL92" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
b/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
index 8e0e10c8333..5228c46e804 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
@@ -200,4 +200,6 @@
<sql-case id="insert_into_with_partition" value="INSERT INTO TABLE sales
PARTITION (region='Asia') VALUES (1001, 'Laptop', 5999);" db-types="Hive" />
<sql-case id="insert_into_without_val1" value="INSERT INTO TABLE sales
PARTITION (region) VALUES (1001, 'Laptop', 5999);" db-types="Hive" />
<sql-case id="insert_into_with_null" value="INSERT INTO TABLE user_info
VALUES (301, NULL, 'New York'), (302, 'Charlie', NULL);" db-types="Hive" />
+ <sql-case id="insert_with_columns_sql92" value="INSERT INTO
t_order(order_id, status) VALUES (1, 'ok')" db-types="SQL92" />
+ <sql-case id="insert_without_columns_sql92" value="INSERT INTO t_order
VALUES (1, 'ok')" db-types="SQL92" />
</sql-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 29e673be5d4..5a74a2d99a9 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
@@ -430,4 +430,19 @@
<sql-case id="select_distinct_with_count_sql92" value="SELECT
COUNT(DISTINCT order_id) c FROM t_order WHERE order_id < 1100"
db-types="SQL92" />
<sql-case id="select_having_sql92" value="SELECT user_id, COUNT(*) AS cnt
FROM t_order GROUP BY user_id HAVING COUNT(*) > 1" db-types="SQL92" />
<sql-case id="select_cast_int_sql92" value="SELECT CAST(user_id AS INT)
FROM t_order" db-types="SQL92" />
+ <sql-case id="select_all_param_alias_schema_sql92" value="SELECT ALL ? AS
"aid" FROM schema1.t_order WHERE (order_id = 1) OR active IS NULL"
db-types="SQL92" />
+ <sql-case id="select_like_between_and_sql92" value="SELECT status FROM
t_order WHERE status LIKE '1%' AND order_id BETWEEN 1 AND 10" db-types="SQL92"
/>
+ <sql-case id="select_safe_eq_sql92" value="SELECT order_id FROM t_order
WHERE order_id <=> 1" db-types="SQL92" />
+ <sql-case id="select_in_list_sql92" value="SELECT order_id FROM t_order
WHERE order_id IN (1, 2)" db-types="SQL92" />
+ <sql-case id="select_not_in_subquery_sql92" value="SELECT order_id FROM
t_order WHERE order_id NOT IN (SELECT 1)" db-types="SQL92" />
+ <sql-case id="select_not_between_sql92" value="SELECT order_id FROM
t_order WHERE order_id NOT BETWEEN 1 AND 2" db-types="SQL92" />
+ <sql-case id="select_addition_expr_sql92" value="SELECT order_id + 1 FROM
t_order" db-types="SQL92" />
+ <sql-case id="select_subquery_projection_sql92" value="SELECT (SELECT 1)
sub FROM t_order" db-types="SQL92" />
+ <sql-case id="select_hex_literal_sql92" value="SELECT 0x1 FROM t_order"
db-types="SQL92" />
+ <sql-case id="select_bit_literal_sql92" value="SELECT B'1' FROM t_order"
db-types="SQL92" />
+ <sql-case id="select_cast_literal_sql92" value="SELECT CAST(1 AS INT) FROM
t_order" db-types="SQL92" />
+ <sql-case id="select_boolean_literal_sql92" value="SELECT TRUE FROM
t_order" db-types="SQL92" />
+ <sql-case id="select_subquery_table_sql92" value="SELECT * FROM (SELECT 1)
t" db-types="SQL92" />
+ <sql-case id="select_comma_join_sql92" value="SELECT * FROM t_order o,
t_order_item i" db-types="SQL92" />
+ <sql-case id="select_cross_join_sql92" value="SELECT * FROM t_order CROSS
JOIN t_order_item" db-types="SQL92" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/update.xml
b/test/it/parser/src/main/resources/sql/supported/dml/update.xml
index 4a63da44fcd..43a1ef409f8 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/update.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/update.xml
@@ -75,4 +75,5 @@
<sql-case id="update_multiple_cols" value="UPDATE customers SET email =
'[email protected]', status = 'active' WHERE customer_id = 1001;"
db-types="Hive" />
<sql-case id="update_basic" value="UPDATE products SET stock = 0;"
db-types="Hive" />
<sql-case id="update_with_null" value="UPDATE user_profiles SET last_login
= NULL;" db-types="Hive" />
+ <sql-case id="update_with_where_sql92" value="UPDATE t_order SET status =
'x' WHERE order_id = 1" db-types="SQL92" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
index 41e2c99ac5c..60c4af95632 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
@@ -28,4 +28,5 @@
<sql-case id="commit_work" value="COMMIT WORK" db-types="Oracle" />
<sql-case id="commit_write_batch" value="COMMIT WRITE BATCH"
db-types="Oracle" />
<sql-case id="commit_work_force" value="COMMIT WORK FORCE '22.14.67'"
db-types="Oracle" />
+ <sql-case id="commit_sql92" value="COMMIT" db-types="SQL92" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
index a8012522c71..29f4233c46c 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
@@ -26,4 +26,5 @@
<sql-case id="rollback_in_pg" value="ROLLBACK TRANSACTION AND CHAIN"
db-types="PostgreSQL,openGauss" />
<sql-case id="rollback_work_force" value="ROLLBACK WORK FORCE 'string1'"
db-types="Oracle" />
<sql-case id="abort" value="ABORT" db-types="PostgreSQL,openGauss" />
+ <sql-case id="rollback_sql92" value="ROLLBACK" db-types="SQL92" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
index c9aa3a38d5d..6df52200341 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
@@ -37,4 +37,5 @@
<sql-case id="xa_prepare" value="XA prepare 'abcdef7'"
db-types="MySQL,Doris" />
<sql-case id="xa_commit" value="XA commit 'abcdef7'"
db-types="MySQL,Doris" />
<sql-case id="xa_rollback" value="XA rollback 'abcdef7'"
db-types="MySQL,Doris" />
+ <sql-case id="set_transaction_sql92" value="SET TRANSACTION ISOLATION
LEVEL READ COMMITTED" db-types="SQL92" />
</sql-cases>
