You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Pereslegin (Jira)" <ji...@apache.org> on 2025/08/12 08:00:01 UTC

[jira] [Updated] (IGNITE-26029) Sql. Ensure that integration tests that use index value lookups use a plan with search bounds

     [ https://issues.apache.org/jira/browse/IGNITE-26029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pavel Pereslegin updated IGNITE-26029:
--------------------------------------
    Fix Version/s: 3.1

> Sql. Ensure that integration tests that use index value lookups use a plan with search bounds
> ---------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-26029
>                 URL: https://issues.apache.org/jira/browse/IGNITE-26029
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql ai3
>            Reporter: Pavel Pereslegin
>            Assignee: Andrey Mashenkov
>            Priority: Major
>              Labels: ignite-3
>             Fix For: 3.1
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> Currently, intergration tests for checking index usage use QueryChecker.matches(containsIndexScan(...
> However, containsIndexScan only checks for index usage, but does not check for presence of search bounds.
> This can lead to hidden errors, in some cases we may expect to go to the index with a specific key, but instead we get a full index scan.
> Therefore, the following proposal arose.
> Change the current behavior of {{containsIndexScan()}} so that it checks by default that some search bounds are present.
> And add a method {{containsIndexScanWithoutSearchBounds()}} (naming is discussable) that will not check for the presence of search bounds.
> Run SQL integration tests on TC and look at the failed tests.
> * If the test uses the index for ordering or this is expected behavior - change it to use {{containsIndexScanWithoutSearchBounds}}
> * If the index search is performed incorrectly, create a corresponding JIRA issue to fix it and mute the corresponding test.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)