[jira] [Created] (IGNITE-8009) SQL local query to a cache with queryParallelism>1 doesn't use index

[Anton Vinogradov (Jira)]

Pavel Vinokurov created IGNITE-8009:
---------------------------------------

             Summary: SQL local query to a cache with queryParallelism>1  doesn't use index
                 Key: IGNITE-8009
                 URL: https://issues.apache.org/jira/browse/IGNITE-8009
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.4, 2.3
            Reporter: Pavel Vinokurov
         Attachments: ExplainAndIndexReproducer.java

queryParallelism>1 + setLocal(true)  changes the query plan and exclude usage of the sql index.

Explain query with setLocal(false) and queryParallelism=1
SELECT
    T__Z0.ID AS __C0_0
FROM TABLE(COL VARCHAR='name0') I__Z1
    /* function */
INNER JOIN PUBLIC.PERSON T__Z0
    /* PUBLIC.PERSON_NAME: NAME = I__Z1.COL */
    ON 1=1
WHERE (T__Z0.SOURNAME = 'sourname0')
    AND (T__Z0.NAME = I__Z1.COL)

Explain query with setLocal(true) and queryParallelism=2
SELECT
    T__Z1.ID AS __C0_0
FROM PUBLIC.PERSON T__Z1
    /* PUBLIC.PERSON.__SCAN_ */
    /* WHERE T__Z1.SOURNAME = 'sourname0'
    */
INNER JOIN TABLE(COL VARCHAR='name0') I__Z0
    /* function: COL = T__Z1.NAME */
    ON 1=1
WHERE (T__Z1.SOURNAME = 'sourname0')
    AND (T__Z1.NAME = I__Z0.COL)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)