You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2026/01/02 05:01:30 UTC
(shardingsphere) branch master updated: Add presto SQL parse test cases (#37618)
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 260ed945bbc Add presto SQL parse test cases (#37618)
260ed945bbc is described below
commit 260ed945bbca410e23e004249ebf240b33744845
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Fri Jan 2 13:01:23 2026 +0800
Add presto SQL parse test cases (#37618)
* Load railroad diagrams via same-domain hash path
* Add presto SQL parse test cases
---
.../parser/src/main/resources/case/ddl/presto.xml | 15 +++
.../parser/src/main/resources/case/dml/presto.xml | 117 +++++++++++++++++++++
.../main/resources/sql/supported/ddl/presto.xml | 3 +
.../main/resources/sql/supported/dml/presto.xml | 5 +
4 files changed, 140 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/presto.xml b/test/it/parser/src/main/resources/case/ddl/presto.xml
index d9c9f989902..38f9fea7518 100644
--- a/test/it/parser/src/main/resources/case/ddl/presto.xml
+++ b/test/it/parser/src/main/resources/case/ddl/presto.xml
@@ -27,4 +27,19 @@
<column name="amount" />
</column-definition>
</create-table>
+
+ <create-table sql-case-id="presto_create_table_varchar">
+ <table name="t_alpha" start-index="13" stop-index="19" />
+ <column-definition type="VARCHAR" start-index="21" stop-index="36">
+ <column name="name" />
+ </column-definition>
+ </create-table>
+
+ <drop-table sql-case-id="presto_drop_table_if_exists">
+ <table name="t_price" start-index="21" stop-index="27" />
+ </drop-table>
+
+ <drop-view sql-case-id="presto_drop_view_if_exists">
+ <view name="v_price" start-index="20" stop-index="26" />
+ </drop-view>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/presto.xml b/test/it/parser/src/main/resources/case/dml/presto.xml
index ebcb60c08eb..c72fd6a598a 100644
--- a/test/it/parser/src/main/resources/case/dml/presto.xml
+++ b/test/it/parser/src/main/resources/case/dml/presto.xml
@@ -371,4 +371,121 @@
</expr>
</where>
</select>
+
+ <select sql-case-id="presto_select_xor">
+ <from>
+ <simple-table name="t_order" start-index="14" stop-index="20" />
+ </from>
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <where start-index="22" stop-index="37">
+ <expr>
+ <binary-operation-expression start-index="28" stop-index="37">
+ <left>
+ <column name="flag" start-index="28" stop-index="31" />
+ </left>
+ <operator>XOR</operator>
+ <right>
+ <literal-expression value="1" start-index="37" stop-index="37" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="presto_select_safe_equal">
+ <from>
+ <simple-table name="t_order" start-index="14" stop-index="20" />
+ </from>
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <where start-index="22" stop-index="40">
+ <expr>
+ <binary-operation-expression start-index="28" stop-index="40">
+ <left>
+ <column name="flag" start-index="28" stop-index="31" />
+ </left>
+ <operator><=></operator>
+ <right>
+ <literal-expression value="true" start-index="37" stop-index="40" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="presto_select_member_of">
+ <from>
+ <simple-table name="t_order" start-index="14" stop-index="20" />
+ </from>
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <where start-index="22" stop-index="54">
+ <expr>
+ <binary-operation-expression start-index="28" stop-index="54">
+ <left>
+ <column name="order_id" start-index="28" stop-index="35" />
+ </left>
+ <operator>MEMBER OF</operator>
+ <right>
+ <expression-projection text=""[1,2]"" start-index="47" stop-index="53" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="presto_select_in_params">
+ <from>
+ <simple-table name="t_order" start-index="14" stop-index="20" />
+ </from>
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <where start-index="22" stop-index="45">
+ <expr>
+ <in-expression start-index="28" stop-index="45">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="28" stop-index="35" />
+ </left>
+ <right>
+ <list-expression start-index="40" stop-index="45">
+ <items>
+ <literal-expression value="1" start-index="41" stop-index="41" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="44" stop-index="44" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </expr>
+ </where>
+ </select>
+
+ <select sql-case-id="presto_select_sounds_like">
+ <from>
+ <simple-table name="t_order" start-index="14" stop-index="20" />
+ </from>
+ <projections start-index="7" stop-index="7">
+ <shorthand-projection start-index="7" stop-index="7" />
+ </projections>
+ <where start-index="22" stop-index="50">
+ <expr>
+ <binary-operation-expression start-index="28" stop-index="50">
+ <left>
+ <column name="status" start-index="28" stop-index="33" />
+ </left>
+ <operator>SOUNDS LIKE</operator>
+ <right>
+ <literal-expression value="ok" start-index="47" stop-index="50" />
+ </right>
+ </binary-operation-expression>
+ </expr>
+ </where>
+ </select>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/presto.xml b/test/it/parser/src/main/resources/sql/supported/ddl/presto.xml
index 607ab07d1de..748c68c4e40 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/presto.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/presto.xml
@@ -18,4 +18,7 @@
<sql-cases>
<sql-case id="presto_create_table_decimal" value="CREATE TABLE catalog.schem1.t_price (amount DECIMAL(10,2))" db-types="Presto" />
+ <sql-case id="presto_create_table_varchar" value="CREATE TABLE t_alpha(name VARCHAR(20))" db-types="Presto" />
+ <sql-case id="presto_drop_table_if_exists" value="DROP TABLE IF EXISTS t_price" db-types="Presto" />
+ <sql-case id="presto_drop_view_if_exists" value="DROP VIEW IF EXISTS v_price" db-types="Presto" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/presto.xml b/test/it/parser/src/main/resources/sql/supported/dml/presto.xml
index b878305a582..ceebc985233 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/presto.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/presto.xml
@@ -27,4 +27,9 @@
<sql-case id="presto_select_case_binary_variable" value="SELECT CASE catalog.schem1.order_id WHEN 1 THEN 'one' ELSE 'other' END, BINARY status, @user_value FROM t_order" db-types="Presto" />
<sql-case id="presto_select_concat_match_interval" value="SELECT status || 'X', MATCH(status) AGAINST ('kw'), INTERVAL '1' DAY, catalog.fn(order_id) FROM t_order" db-types="Presto" />
<sql-case id="presto_select_is_true" value="SELECT * FROM t_order WHERE flag IS TRUE" db-types="Presto" />
+ <sql-case id="presto_select_xor" value="SELECT * FROM t_order WHERE flag XOR 1" db-types="Presto" />
+ <sql-case id="presto_select_safe_equal" value="SELECT * FROM t_order WHERE flag <=> TRUE" db-types="Presto" />
+ <sql-case id="presto_select_member_of" value="SELECT * FROM t_order WHERE order_id MEMBER OF("[1,2]")" db-types="Presto" />
+ <sql-case id="presto_select_in_params" value="SELECT * FROM t_order WHERE order_id IN (1, 2)" db-types="Presto" />
+ <sql-case id="presto_select_sounds_like" value="SELECT * FROM t_order WHERE status SOUNDS LIKE 'ok'" db-types="Presto" />
</sql-cases>