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

[GitBox]

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

   > Following is the result when I modify the metadata logic on my local 
machine.
   > 
   > ```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 alt="image" width="764" 
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 alt="image" width="755" 
src="https://user-images.githubusercontent.com/10829171/186601662-aa6a83be-083a-4bc9-b4b1-88114244cdc5.png";>
   
   I think you are right ,when proxy is in not case sensitive mode.


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