strongduanmu commented on issue #9996:
URL: https://github.com/apache/shardingsphere/issues/9996#issuecomment-817257492
@307434169 `Cannot support Multiple-Table` verification logic has been
optimized in version 5.0.0-alpha. You can follow what @RaigorJiang said, use
`update order_info set status=? where orderid=?` to avoid this exception.
During the investigation, I found an abnormality in the rewriting of the
table in the set clause, and I will fix it soon.
```
[INFO ] 14:17:54.500 [ShardingSphere-Command-6] ShardingSphere-SQL - Logic
SQL: /* ApplicationName=DataGrip 2021.1 */ UPDATE t_order SET t_order.content =
'111111' WHERE t_order.order_id = 1
[INFO ] 14:17:54.500 [ShardingSphere-Command-6] ShardingSphere-SQL -
SQLStatement: MySQLUpdateStatement(orderBy=Optional.empty, limit=Optional.empty)
[INFO ] 14:17:54.500 [ShardingSphere-Command-6] ShardingSphere-SQL - Actual
SQL: ds_1 ::: /* ApplicationName=DataGrip 2021.1 */ UPDATE t_order_1 SET
t_order.content = '111111' WHERE t_order_1.order_id = 1
[ERROR] 14:17:54.502 [ShardingSphere-Command-6]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
't_order.content' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
```
--
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.
For queries about this service, please contact Infrastructure at:
[email protected]
