Missing logic database in query information_schema.SCHEMATA with 'NOT IN'

[RaigorJiang]

Bug Report

Maybe related to #32510

Which version of ShardingSphere did you use?

5.5.2-SNAPSHOT 9e6ad63

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Actual behavior

1. create logic database

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

SELECT SCHEMA_NAME AS dbname FROM information_schema.SCHEMATA;

2. query information_schema.SCHEMATA with 'NOT IN'

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