You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2023/01/18 09:32:40 UTC

[GitHub] [shardingsphere] zhaojinchao95 opened a new issue, #23632: databaseName need to check according to SQL standard in config-xx-yaml file

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

   
   ```
   databaseName: sharding-db
   
   dataSources:
     ds_0:
       url: jdbc:mysql://127.0.0.1:3306/migration_ds_12?serverTimezone=UTC&useSSL=false
       username: root
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
   ```
   
   MySQL :
   
   
   ```
   mysql> create database test-test;
   ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-test' at line 1
   mysql>
   ```
   
   PostgreSQL : 
   
   ```
   postgres=# create database test-test;
   ERROR:  syntax error at or near "-"
   LINE 1: create database test-test;
   ```


-- 
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-unsubscribe@shardingsphere.apache.org.apache.org

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


Re: [I] DatabaseName need according to SQL standard with checking in config-xx-yaml file #23632 [shardingsphere]

Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 closed issue #23632: DatabaseName need according to SQL standard with checking in config-xx-yaml file #23632
URL: https://github.com/apache/shardingsphere/issues/23632


-- 
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-unsubscribe@shardingsphere.apache.org

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