[
https://issues.apache.org/jira/browse/PHOENIX-6999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth reassigned PHOENIX-6999:
------------------------------------
Assignee: Istvan Toth
> Uncovered index with skip-scan-join plan doesn't return result for reverse
> scan
> -------------------------------------------------------------------------------
>
> Key: PHOENIX-6999
> URL: https://issues.apache.org/jira/browse/PHOENIX-6999
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.2.0
> Reporter: Istvan Toth
> Assignee: Istvan Toth
> Priority: Major
>
> {noformat}
> create table d (k1 varchar primary key, v1 varchar, v2 varchar);
> create index i on d(v1);
> upsert into d values ('a','a','a');
> upsert into d values ('b','b','b');
> upsert into d values ('c','c','c');{noformat}
> {noformat}
> 0: jdbc:phoenix:localhost:55375> select /*+ INDEX(d i) NO_INDEX_SERVER_MERGE
> */ * from d where v1='b' order by k1 asc;
> +----+----+----+
> | K1 | V1 | V2 |
> +----+----+----+
> | b | b | b |
> +----+----+----+
> 1 row selected (0.035 seconds)
> 0: jdbc:phoenix:localhost:55375> select /*+ INDEX(d i) NO_INDEX_SERVER_MERGE
> */ * from d where v1='b' order by k1 desc;
> +----+----+----+
> | K1 | V1 | V2 |
> +----+----+----+
> No rows selected (0.03 seconds)
> 0: jdbc:phoenix:localhost:55375> explain select /*+ INDEX(d i)
> NO_INDEX_SERVER_MERGE */ * from d where v1='b' order by k1 asc;
> +---------------------------------------------------------------------------+----------------+---------------+-------------+
> | PLAN |
> EST_BYTES_READ | EST_ROWS_READ | EST_INFO_TS |
> +---------------------------------------------------------------------------+----------------+---------------+-------------+
> | CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER D |
> null | null | null |
> | SKIP-SCAN-JOIN TABLE 0 |
> null | null | null |
> | CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN RANGE SCAN OVER I ['b'] |
> null | null | null |
> | SERVER FILTER BY FIRST KEY ONLY |
> null | null | null |
> | DYNAMIC SERVER FILTER BY "D.K1" IN ($107.$109) |
> null | null | null |
> +---------------------------------------------------------------------------+----------------+---------------+-------------+
> 5 rows selected (0.029 seconds)
> 0: jdbc:phoenix:localhost:55375> explain select /*+ INDEX(d i)
> NO_INDEX_SERVER_MERGE */ * from d where v1='b' order by k1 desc;
> +---------------------------------------------------------------------------+----------------+---------------+-------------+
> | PLAN |
> EST_BYTES_READ | EST_ROWS_READ | EST_INFO_TS |
> +---------------------------------------------------------------------------+----------------+---------------+-------------+
> | CLIENT 1-CHUNK PARALLEL 1-WAY REVERSE FULL SCAN OVER D |
> null | null | null |
> | SKIP-SCAN-JOIN TABLE 0 |
> null | null | null |
> | CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN RANGE SCAN OVER I ['b'] |
> null | null | null |
> | SERVER FILTER BY FIRST KEY ONLY |
> null | null | null |
> | DYNAMIC SERVER FILTER BY "D.K1" IN ($113.$115) |
> null | null | null |
> +---------------------------------------------------------------------------+----------------+---------------+-------------+
> 5 rows selected (0.029 seconds)
> 0: jdbc:phoenix:localhost:55375>
> {noformat}
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
