[I] Missing logic database in query information_schema.SCHEMATA with 'NOT IN' [shardingsphere]

[via GitHub]

RaigorJiang opened a new issue, #33346:
URL: https://github.com/apache/shardingsphere/issues/33346

   ## Bug Report
   Maybe related to #32510
   
   ### Which version of ShardingSphere did you use?
   5.5.2-SNAPSHOT 9e6ad631837c040fdd3caedfe1c6aa53d8bcd678
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Actual behavior
   1. create logic database
   ```sql
   CREATE DATABASE sharding_db;
   USE sharding_db;
   
   REGISTER STORAGE UNIT ds_0 (
       
URL="jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true",
       USER="root",
       PASSWORD="123456",
       PROPERTIES("maximumPoolSize"=10)
   );
   ```
   
   2. query information_schema.SCHEMATA
   ```sql
   SELECT SCHEMA_NAME AS dbname FROM information_schema.SCHEMATA;
   ```
   <img width="505" alt="image" 
src="https://github.com/user-attachments/assets/2b0fc354-737d-4e2b-8e99-437ffc64a418";>
   
   
   
   2. query information_schema.SCHEMATA with 'NOT IN'
   ```sql
   SELECT SCHEMA_NAME AS dbname 
   FROM information_schema.SCHEMATA
   WHERE SCHEMA_NAME NOT IN 
('mysql','information_schema','performance_schema','sys')
   ORDER BY SCHEMA_NAME;
   ```
   - Missing sharding_db
   <img width="639" alt="image" 
src="https://github.com/user-attachments/assets/40de47e4-0bdc-421b-8437-e0f0235f9e7c";>
   
   


-- 
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: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org