[GitHub] [shardingsphere] RaigorJiang commented on issue #20285: Syntax error when execute `ADD RESOURCE`

[GitBox <gi...@apache.org>]

RaigorJiang commented on issue #20285:
URL: https://github.com/apache/shardingsphere/issues/20285#issuecomment-1220283525

   @kutouziUk 
   In versions 5.1.1 and 5.1.2, `HOST`, `DB`, `USER`, `PASSWORD` do not require quotes, but do not support special characters such as '`- @ . `' .
   In order to better standardize DistSQL parameters, the master branch has required strings to be quoted, so that they can contain some special characters.
   
   Therefore, if you use 5.1.1, the DB name has special characters, you cannot `ADD RESOURCE` in this way, you can refer to the URL method:
   https://shardingsphere.apache.org/document/5.1.1/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/resource-definition/
   
   eg.
   ```sql
   ADD RESOURCE ds_0 (
       URL="jdbc:mysql://127.0.0.1:3306/db0?serverTimezone=UTC&useSSL=false",
       USER=root,
       PASSWORD=root
   );
   ```


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