ricky
ricky
It would be very nice if you could provide the test code and the table schema. @ltylty
fe.log ``` 2022-09-21 17:09:29,272 WARN (starrocks-mysql-nio-pool-2|202) [ConnectProcessor.handleQuery():306] Process one query failed because. com.starrocks.common.AnalysisException: extraneous input 't' expecting {',', ')'} at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:266) ~[starrocks-fe.jar:?] at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:432) ~[starrocks-fe.jar:?] at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:668) ~[starrocks-fe.jar:?] at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55)...
> replace "tes't" to "test" insert success . I guess sqlParser‘s bug. I agree. The SQL printed in audit log `INSERT INTO db0.test (x_id,x_uid,nickname,x_time) VALUES(1, 1, 'tes\'t', '2022-09-09')` is wrong.
run starrocks_fe_unittest
run starrocks_fe_unittest
@mergifyio rebase
run starrocks_fe_unittest
@mergifyio backport branch-2.4
run starrocks_fe_unittest
@roseduan HI, I have created a PR to fix this. PTAL.