Iurii Gerzhedovich created IGNITE-21534:
-------------------------------------------
Summary: 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
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)
