apache / apache/incubator-seata

seata1.2接入oracle时使用update xxx set x=1 where id in (select id from tb2 where type=1)报错

Open
#2,789 6 comments 0 reactions 1 assignee Claimed by @slievrly View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.