linghengqian commented on code in PR #29982:
URL: https://github.com/apache/shardingsphere/pull/29982#discussion_r1477226510


##########
test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml:
##########
@@ -156,6 +156,10 @@
     <test-case sql="SELECT * FROM information_schema.key_column_usage 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.keywords limit 1" 
db-types="MySQL" scenario-types="tbl" adapters="proxy">
+        <assertion expected-data-source-name="read_dataset" />
+    </test-case>

Review Comment:
   - @FlyingZC Is there any background issue for #27905? I don't quite 
understand why the table cannot be found in 
https://github.com/apache/shardingsphere/actions/runs/7772894056/job/21195958057?pr=29982#step:7:3426.
   ```shell
   Error:  2024-02-04 09:09:24.319 [main] o.a.s.t.e2e.framework.E2EExtension - 
Error case: proxy: tbl -> MySQL -> Literal -> SELECT * FROM 
information_schema.keywords limit 1, message: java.sql.SQLSyntaxErrorException: 
Unknown table 'keywords' in information_schema
   ```



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to