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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
