[
https://issues.apache.org/jira/browse/IGNITE-18654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17697962#comment-17697962
]
Yury Gerzhedovich commented on IGNITE-18654:
--------------------------------------------
The bug relates to the current implementation of the transaction protocol. The
already-started scan could return data inserted after the scan started.
> Sql. test_scan_big_varchar.test_slow incorrect results.
> -------------------------------------------------------
>
> Key: IGNITE-18654
> URL: https://issues.apache.org/jira/browse/IGNITE-18654
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: calcite3-required, ignite-3
> Fix For: 3.0.0-beta2
>
>
> 1)
> {code:java}
> query IIIR
> SELECT COUNT(*), COUNT(a), MAX(CHARACTER_LENGTH(a)), SUM(CHARACTER_LENGTH(a))
> FROM bigtable
> ----
> 8192 8192 10000 81920000.000000 {code}
> {code:java}
> Not expected result at: (test_scan_big_varchar.test_slow:145). [row=0, col=0,
> expected=8192, actual=15026] java.lang.AssertionError: Not expected result
> at: (test_scan_big_varchar.test_slow:145). [row=0, col=0, expected=8192,
> actual=15026]
> {code}
> 2)
>
> {code:java}
> query IIIR
> SELECT COUNT(*), COUNT(a), MAX(CHARACTER_LENGTH(a)), SUM(CHARACTER_LENGTH(a))
> FROM bigtable
> ----
> 16384 16384 10000 163840000.000000{code}
> {code:java}
> Not expected result at: (test_scan_big_varchar.test_slow:154). [row=0, col=0,
> expected=16384, actual=40598] {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
