cannot be cast to com.alibaba.druid.sql.dialect......
#2,846 opened on Sep 8, 2021
Repository metrics
- Stars
- (9,451 stars)
- PR merge metrics
- (No merged PRs in 30d)
Description
模拟方法：使用navicat手动运行自定义函数并输入参数名后其某个表的值没有被更新。
Mycat版本：mycat-1.6.7.6-20210831
Mycat日志内容：
2021-09-08 10:20:26.430 DEBUG [$_NIOREACTOR-2-RW] (io.mycat.net.FrontendConnection.query(FrontendConnection.java:358)) - ServerConnection [id=6, schema=cloud_one, host=10.10.81.249, user=mycat_user,txIsolation=3, autocommit=true, schema=cloud_one, executeSql=null] SET @in_queue_name = 'InitialWeight'
2021-09-08 10:20:26.430 DEBUG [$_NIOREACTOR-2-RW] (io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:70)) - ServerConnection [id=6, schema=cloud_one, host=10.10.81.249, user=mycat_user,txIsolation=3, autocommit=true, schema=cloud_one, executeSql=SET @in_queue_name = 'InitialWeight']SET @in_queue_name = 'InitialWeight'
2021-09-08 10:20:26.431 DEBUG [$_NIOREACTOR-2-RW] (io.mycat.server.interceptor.impl.GlobalTableUtil.consistencyInterceptor(GlobalTableUtil.java:89)) - before intercept: SET @in_queue_name = 'InitialWeight'
2021-09-08 10:20:26.431 WARN [$_NIOREACTOR-2-RW] (io.mycat.server.interceptor.impl.GlobalTableUtil.convertUpdateSQL(GlobalTableUtil.java:514)) - com.alibaba.druid.sql.ast.statement.SQLSetStatement cannot be cast to com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlUpdateStatement
2021-09-08 10:20:26.431 DEBUG [$_NIOREACTOR-2-RW] (io.mycat.server.interceptor.impl.GlobalTableUtil.consistencyInterceptor(GlobalTableUtil.java:102)) - after intercept: SET @in_queue_name = 'InitialWeight'
2021-09-08 10:20:26.431 DEBUG [$_NIOREACTOR-2-RW] (io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:362)) - add queue,executeSqlQueue size 1