[GitHub] [shardingsphere] fengshana commented on issue #13573: shardingjdbc Actual SQL 新增时对sql中的关键字未做处理

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

fengshana commented on issue #13573:
URL: https://github.com/apache/shardingsphere/issues/13573#issuecomment-966955052


   Hello, I would like to ask you about the problem that the keywords in SQL are not processed when shardingjdbc actual SQL is added;
   
   I saw that the query statements are processed; However, it is not processed when adding;
   
   The following is the query:
   -------------
   2021-11-12 17:12:17.609 [http-nio-20021-exec-8] INFO ShardingSphere-SQL - [traceid:5c8daba2-f432-48e2-b003-11d5fbdbd279] - [log,89] - Actual SQL: dsconfigslave ::: SELECT id,name,keys_name,val,desc,type,app_type,status,create_time,update_time,create_user_id,update_user_id,create_user_name,update_user_name,archive,unit_type FROM t_profile_config
   LIMIT ? ::: [10]
   ---------------
   
   
   The following are new:
   ---------------------
   2021-11-12 17:15:24.843 [http-nio-20021-exec-1] INFO ShardingSphere-SQL - [traceid:b2fbd69b-7e54-4bbe-a7d3-b0ff79f3e2fc] - [log,89] - Actual SQL: dsconfig ::: INSERT INTO t_profile_config (id, name, keys_name, val, desc, type, status, create_time, update_time, create_user_id, update_user_id, create_user_name, update_user_name, archive, unit_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ::: [1459087422821224450, 测试池, test_pool1111, 11, 测试描述, 测试类型, 1, 2021-11-12T17:15:24, 2021-11-12T17:15:24, 1, 1, admin, admin, 0, 测试单位]
   
   ----------------------
   
   
   You can see that in the query, the desc keyword is added with special characters [ ` desc ` ], and the new statement is not.
   
   How should this be solved?
   
   
   
   
   
   
   
   
   
   
   
   


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