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)
