[IGNITE-18654] Sql. test_scan_big_varchar.test_slow incorrect results.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 10:47
• Updated: 03/May/23 08:32
• Resolved: 13/Mar/23 14:49

Description

1)

query IIIR
SELECT COUNT(*), COUNT(a), MAX(CHARACTER_LENGTH(a)), SUM(CHARACTER_LENGTH(a)) FROM bigtable
----
8192 8192 10000  81920000.000000 

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]

2)

 

query IIIR
SELECT COUNT(*), COUNT(a), MAX(CHARACTER_LENGTH(a)), SUM(CHARACTER_LENGTH(a)) FROM bigtable
----
16384  16384  10000  163840000.000000

Not expected result at: (test_scan_big_varchar.test_slow:154). [row=0, col=0, expected=16384, actual=40598] 

 

Issue Links

• duplicates: IGNITE-18994 SQL requests within RW transactions should not see their own changes.