You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2022/09/30 12:36:00 UTC
[jira] [Commented] (IGNITE-17791) SQL: Allow index scans for different but compatible types
[ https://issues.apache.org/jira/browse/IGNITE-17791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17611561#comment-17611561 ]
Ignite TC Bot commented on IGNITE-17791:
----------------------------------------
{panel:title=Branch: [pull/10281/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/10281/head] Base: [master] : New Tests (2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 3{color} [[tests 1|https://ci2.ignite.apache.org/viewLog.html?buildId=6639129]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite3: IndexColumnTypeMismatchTest.testIndexDifferentTypesComparable - PASSED{color}
{color:#00008b}Queries 3 (lazy=true){color} [[tests 1|https://ci2.ignite.apache.org/viewLog.html?buildId=6639130]]
* {color:#013220}IgniteBinaryCacheQueryLazyTestSuite3: IndexColumnTypeMismatchTest.testIndexDifferentTypesComparable - PASSED{color}
{panel}
[TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=6639155&buildTypeId=IgniteTests24Java8_RunAll]
> SQL: Allow index scans for different but compatible types
> ---------------------------------------------------------
>
> Key: IGNITE-17791
> URL: https://issues.apache.org/jira/browse/IGNITE-17791
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.15
> Reporter: Aleksey Plekhanov
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: ise
> Time Spent: 10m
> Remaining Estimate: 0h
>
> After IGNITE-17027, index scans for different types (when indexes type should be converted to search row type) are prohibited. It is correct for incompatible types (with different comparison rules, for example for INT and VARCHAR), but for compatible types, we can support such a scans.
> For example, if indexed type is INT and search row type is BIGINT we should allow index scan despite the fact that BIGINT is type with higher priority.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)