Konstantin Orlov created IGNITE-21330:
-----------------------------------------
Summary: Sql. Index is not used for IN predicate with column type
of UUID
Key: IGNITE-21330
URL: https://issues.apache.org/jira/browse/IGNITE-21330
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Konstantin Orlov
See ItUuidIndexTest#testInLookUp, false scan is used in execution although
index is available.
The query is
{code:java}
SELECT *
FROM t
WHERE test_key IN ('00000000-0000-0001-0000-000000000001'::UUID,
'00000000-0000-0003-0000-000000000001'::UUID)
ORDER BY id
{code}
and the plan is
{code:java}
IgniteExchange(distribution=[single])
IgniteSort(sort0=[$0], dir0=[ASC])
IgniteTableScan(table=[[PUBLIC, T]], tableId=[6], filters=[OR(=($t1,
CAST(_UTF-8'00000000-0000-0001-0000-000000000001'):UUID NOT NULL), =($t1,
CAST(_UTF-8'00000000-0000-0003-0000-000000000001'):UUID NOT NULL))],
requiredColumns=[{0, 1}])
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
