(shardingsphere) branch master updated: Fix system schema query test (#29996)

[duanzhengqiang]

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 394e8285585 Fix system schema query test (#29996)
394e8285585 is described below

commit 394e8285585f2ee8f8ced34ca427afdbe1985488
Author: ZhangCheng <chengzh...@apache.org>
AuthorDate: Mon Feb 5 09:46:05 2024 +0800

    Fix system schema query test (#29996)
---
 .../cases/dql/dql-integration-select-system-schema-mysql.xml        | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
 
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
index 025a8539e35..1273a93159d 100644
--- 
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
+++ 
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
@@ -17,7 +17,7 @@
   -->
 
 <integration-test-cases>
-    <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru 
limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+    <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru 
where POOL_ID=1000 limit 1" db-types="MySQL" scenario-types="tbl" 
adapters="proxy">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
@@ -37,11 +37,11 @@
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT * FROM information_schema.innodb_buffer_page limit 
1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+    <test-case sql="SELECT * FROM information_schema.innodb_buffer_page where 
POOL_ID=1000 limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru 
limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+    <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru 
where POOL_ID=1000 limit 1" db-types="MySQL" scenario-types="tbl" 
adapters="proxy">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>