[GitHub] [shardingsphere] strongduanmu commented on issue #20491: Sometimes `schema` in proxy case sensitive,sometimes `schema` in proxy not case sensitive？

[GitBox]

strongduanmu commented on issue #20491:
URL: 
https://github.com/apache/shardingsphere/issues/20491#issuecomment-1226880091

   ```sql
   postgres=> create database test;
   CREATE DATABASE
   postgres=> \c test;
   psql (13.3 (Debian 13.3-1.pgdg100+1), server 12.3-ShardingSphere-Proxy 
5.1.3-SNAPSHOT-dirty-f9a3e84)
   You are now connected to database "test" as user "root".
   test=> create schema SYSTEM;
   ERROR:  There are no resources in the database test.
   test=> ADD RESOURCE ds_0 (
   test(>     URL="jdbc:postgresql://127.0.0.1:5432/demo_ds_0",
   test(>     USER="postgres",
   test(>     PASSWORD="123456",
   test(>     
PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000")
   test(> );
   SUCCESS
   test=> create schema SYSTEM;
   CREATE SCHEMA
   ```
   
   <img width="764" alt="image" 
src="https://user-images.githubusercontent.com/10829171/186601473-e11184b6-76b5-4ffd-9b8c-c35de000048b.png";>
   
   ```sql
   test=> create table system.acmg_t_cust_info_base(cust_no varchar(32) not 
null);
   CREATE TABLE
   ```
   
   
   <img width="755" alt="image" 
src="https://user-images.githubusercontent.com/10829171/186601662-aa6a83be-083a-4bc9-b4b1-88114244cdc5.png";>
   


-- 
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

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