[
https://issues.apache.org/jira/browse/IGNITE-21534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-21534:
----------------------------------------
Epic Link: IGNITE-20729
> Sql. Improve test coverage for Indexes
> --------------------------------------
>
> Key: IGNITE-21534
> URL: https://issues.apache.org/jira/browse/IGNITE-21534
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> During implementation support of indexes were added set of tests. However
> added set of tests is insufficient.
> Let's add the following test scenarios:
> Integration tests:
> * Ensuring validation errors for creating indexes with wrong type (not HASH
> and SORTED)
> * Ensuring query conditions on indexed columns transform to valid scan bounds.
>
> {code:java}
> For each supported column type and sorting order:
> Create a sorted index on a column of given type. Run a query with various
> supported range conditions. Check correct index bounds are passed to the
> index scan method.
> For each supported column type:
> Create a hash index on a column of given type. Run a query with equality
> conditions on the indexed column. Check correct index bounds are passed to
> the index lookup method.
> For composite indexes of multiple columns of some types, do similar checks.
> Hash index should support lookup. Sorted index should support scan by range
> condition and also scan by a prefix condiion{code}
> *Ensuring query plans can use indexes
>
> {code:java}
> 1. Check that plans for a query with an `ORDER BY` clause on indexed
> column(s) can utilize the sorted index.
> 2. Check that plans for a query with equality condition on indexed column(s)
> can utilize the hash/sorted index.
> 3. Check that plans for a query with range conditions on indexed column(s)
> can utilize the sorted index.
> 4. Check that plans for a query with conditions on indexed column(s) prefix
> can utilize the sorted index.
> 5. Check that plans with JOINS on indexed column(s) can utilize the index. 6.
> Check that plans with GROUP BY on indexed column(s) can utilize the index.
> {code}
> * Ensuring columns of supported types can be indexed.
>
> {code:java}
> For each index type and for each supported column type:
> Create an index on a column of checking type. Put/update/drop some data and
> check index scan returns the correct data. {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
