[IGNITE-22053] Sql. Logic test without ordering compares with ordered results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 16/Apr/24 10:48
• Updated: 04/Sep/24 16:08
• Resolved: 17/Apr/24 12:18

Description

Test from test_not_distinct_from.test compare results without calling some kind of ordering. Can be reproduced by rejecting some join implementations:
select /*+ DISABLE_RULE('MergeJoinConverter', 'CorrelatedNestedLoopJoin') */ a,tbl_2.b from tbl_1 inner join tbl_2 on (a IS NOT DISTINCT FROM tbl_2.b)

Issue Links

• links to: GitHub Pull Request #3613