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 05a003afb2c feat: add test case (#26911)
05a003afb2c is described below
commit 05a003afb2cdb45e9dc77a1b19859866d67b3b2d
Author: Yunbo Ni <[email protected]>
AuthorDate: Mon Sep 4 15:49:13 2023 +0800
feat: add test case (#26911)
---
test/it/optimizer/src/test/resources/converter/select-table.xml | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
diff --git a/test/it/optimizer/src/test/resources/converter/select-table.xml
b/test/it/optimizer/src/test/resources/converter/select-table.xml
index 5c0dc9575a5..ac7b5683446 100644
--- a/test/it/optimizer/src/test/resources/converter/select-table.xml
+++ b/test/it/optimizer/src/test/resources/converter/select-table.xml
@@ -17,5 +17,9 @@
-->
<sql-node-converter-test-cases>
- <test-cases sql-case-id="select_from_with_table" expected-sql="SELECT *
FROM (SELECT * FROM `t0`) AS `dt`" db-types="MySQL" />
+ <test-cases sql-case-id="select_from_with_table" expected-sql="SELECT *
FROM (TABLE `t0`) AS `dt`" db-types="MySQL" />
+ <test-cases sql-case-id="select_not_in_with_single_table"
expected-sql="SELECT * FROM `t_order_item` WHERE `item_id` IS NOT NULL AND
`item_id` NOT IN (?, ?) ORDER BY `item_id`" db-types="MySQL"
sql-case-types="PLACEHOLDER" />
+ <test-cases sql-case-id="select_not_in_with_single_table"
expected-sql="SELECT * FROM `t_order_item` WHERE `item_id` IS NOT NULL AND
`item_id` NOT IN (100000, 100001) ORDER BY `item_id`" db-types="MySQL"
sql-case-types="LITERAL" />
+ <test-cases sql-case-id="select_not_in_with_single_table"
expected-sql="SELECT * FROM "t_order_item" WHERE "item_id"
IS NOT NULL AND "item_id" NOT IN (?, ?) ORDER BY "item_id""
db-types="openGauss, PostgreSQL" sql-case-types="PLACEHOLDER" />
+ <test-cases sql-case-id="select_not_in_with_single_table"
expected-sql="SELECT * FROM "t_order_item" WHERE "item_id"
IS NOT NULL AND "item_id" NOT IN (100000, 100001) ORDER BY
"item_id"" db-types="openGauss, PostgreSQL" sql-case-types="LITERAL"
/>
</sql-node-converter-test-cases>
