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/05/26 00:29:21 UTC

[shardingsphere] branch master updated: Fix system table query e2e (#25900)

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 15e676a5ca5 Fix system table query e2e (#25900)
15e676a5ca5 is described below

commit 15e676a5ca5f42c3d2d1cb6c0998190ed37fb154
Author: ZhangCheng <ch...@apache.org>
AuthorDate: Fri May 26 08:29:05 2023 +0800

    Fix system table query e2e (#25900)
---
 .../cases/dql/dql-integration-select-system-schema.xml      | 13 +++++++------
 1 file changed, 7 insertions(+), 6 deletions(-)

diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
index 9714c8c12f3..afa4cbc94ab 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
@@ -177,8 +177,8 @@
         <assertion expected-data-file="select_mysql_information_schema_parameters.xml" />
     </test-case>
     
-    <test-case sql="SELECT * FROM information_schema.partitions" db-types="MySQL" scenario-types="db">
-        <assertion expected-data-file="select_mysql_information_schema_partitions.xml" />
+    <test-case sql="SELECT * FROM information_schema.partitions limit 10" db-types="MySQL" scenario-types="db">
+        <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
     <test-case sql="SELECT * FROM information_schema.plugins" db-types="MySQL" scenario-types="db">
@@ -205,9 +205,10 @@
         <assertion expected-data-file="select_mysql_information_schema_schema_privileges.xml" />
     </test-case>
 
-    <test-case sql="SELECT * FROM information_schema.schemata" db-types="MySQL" scenario-types="db">
-        <assertion expected-data-file="select_mysql_information_schema_schemata.xml" />
-    </test-case>
+    <!-- FIXME issue #25899 -->
+<!--    <test-case sql="SELECT * FROM information_schema.schemata" db-types="MySQL" scenario-types="db">-->
+<!--        <assertion expected-data-file="select_mysql_information_schema_schemata.xml" />-->
+<!--    </test-case>-->
     
     <test-case sql="SELECT * FROM information_schema.session_status" db-types="MySQL" scenario-types="db">
         <assertion expected-data-file="select_mysql_information_schema_session_status.xml" />
@@ -238,7 +239,7 @@
     </test-case>
     
     <test-case sql="SELECT * FROM information_schema.triggers" db-types="MySQL" scenario-types="db">
-        <assertion expected-data-file="select_mysql_information_schema_triggers.xml" />
+        <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
     <test-case sql="SELECT * FROM information_schema.user_privileges" db-types="MySQL" scenario-types="db">