apache / apache/incubator-seata

oracle多表空间的情况下执行获取快照sql报错

Open
#7,525 4 comments 0 reactions 0 assignees View on GitHub
type: bug
Dominant language
Java
Stars
26k
Forks
8.8k
Avg merge
1d 8h
Merged PRs (30d)
4

Description

### Check Ahead

- [x] I have searched the [issues](https://github.com/seata/seata/issues) of this repository and believe that this is not a duplicate.

- [ ] I am willing to try to fix this bug myself.

### Ⅰ. Issue Description

Image

我用的是oracle数据库,seata事务模式是AT,这个事务获取快照的时候这个sql语句的第一个字段怎么跟我实际查的表不一样?

### Ⅱ. Describe what happened

_No response_

### Ⅲ. Describe what you expected to happen

_No response_

### Ⅳ. How to reproduce it (as minimally and precisely as possible)

_No response_

### Ⅴ. Anything else we need to know?

_No response_

### Ⅵ. Environment

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by examining Seata's Oracle AT snapshot SQL generation and compare the first selected field with the actual table definition in a multi-tablespace setup. Reproduce the reported snapshot operation against Oracle; done means the generated SQL uses the correct table fields and executes successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.