[ https://issues.apache.org/jira/browse/IGNITE-21330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Pereslegin updated IGNITE-21330: -------------------------------------- Issue Type: Improvement (was: Bug) > 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: Improvement > Components: sql > Reporter: Konstantin Orlov > Assignee: Pavel Pereslegin > Priority: Major > Labels: ignite-3 > Time Spent: 0.5h > Remaining Estimate: 0h > > 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)