fengshana opened a new issue #13573:
URL: https://github.com/apache/shardingsphere/issues/13573
您好，想请问一下就是shardingjdbc Actual SQL 新增时对sql中的关键字未做处理的问题；
我看了一下在查询语句是有做处理的；但是在新增时未做处理；
以下是查询：
===========
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]
===========
以下是新增：
===========
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,
测试单位]
===========
可以看到在查询语句当中，desc该关键字是有添加上特殊字符[ `desc` ]的，而新增语句是没有的；
这个应该怎么解决呢？
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
