You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/09/04 07:49:21 UTC
[shardingsphere] branch master updated: feat: add test case (#26911)
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 <87...@users.noreply.github.com>
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>