apache / apache/ignite

Ignite 2.16.0 cannot query a data back through sql in a transaction

Open
#11,747 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.