apache / apache/incubator-seata
seata1.2接入oracle时使用update xxx set x=1 where id in (select id from tb2 where type=1)报错
- Dominant language
- Java
- Stars
- 26k
- Forks
- 8.8k
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 4
Description
- [ ] I have searched the [issues](https://github.com/seata/seata/issues) of this repository and believe that this is not a duplicate.
### Ⅰ. Issue Description
seata1.2接入oracle时使用update xxx set x=1 where id in (select id from tb2 where type=1)报错
### Ⅱ. Describe what happened
If there is an exception, please attach the exception trace:
```
### Cause: java.sql.SQLException: java.lang.IllegalArgumentException: unexpected WHERE expr: SQLInSubQueryExpr
; uncategorized SQLException; SQL state [null]; error code [0]; java.lang.IllegalArgumentException: unexpected WHERE expr: SQLInSubQueryExpr; nested exception is java.sql.SQLException: java.lang.IllegalArgumentException: unexpected WHERE expr: SQLInSubQueryExpr
org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: java.lang.IllegalArgumentException: unexpected WHERE expr: SQLInSubQueryExpr
### The error may involve defaultParameterMap
### The error occurred while setting parameters
```
### Ⅲ. Describe what you expected to happen
### Ⅳ. How to reproduce it (as minimally and precisely as possible)
### Ⅴ. Anything else we need to know?
### Ⅵ. Environment:
- JDK version :1.8.0_171
- OS :centos 7.5
- Others: seata 1.2
Contributor guide
Assessment
This issue has not been assessed yet.