[
https://issues.apache.org/jira/browse/IGNITE-21330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin reassigned IGNITE-21330:
-----------------------------------------
Assignee: Pavel Pereslegin
> 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
> Assignee: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> 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)
