Ignite 2.16.0 cannot query a data back through sql in a transaction
- Dominant language
- Java
- Stars
- 5.1k
- Forks
- 1.9k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 46
Description
Hi there,
It seems a bug or a known issue? I cannot query back the data after saving a data within a transaction, but works through cache API, here is the simple code to reproduce it.
[IgniteTransactionTest.java](https://github.com/BeamLiu/codesnippet/blob/main/IgniteTransactionTest.java)
Above will output:
```
Starting transaction...
Entity saved in transaction
Direct cache get result: IgniteTransactionTest.TestEntity(id=1734338880949, name=Test Entity)
Expect to have result, but SQL query result is empty : []
```
Regards,
Beam
Contributor guide
Research direction
Start by running the linked IgniteTransactionTest.java reproduction against Ignite 2.16.0 and compare the direct cache get with the SQL query inside the transaction. Trace the transaction and SQL query paths to determine why the uncommitted entity is invisible to SQL; done when the query returns the saved entity as shown by the reproduction.
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
- Mostly clear
- Newbie friendliness
- 35/100