[jira] [Resolved] (PHOENIX-745) Why isn't my query doing a RANGE SCAN?

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-745.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Why isn't my query doing a RANGE SCAN?
> --------------------------------------
>
>                 Key: PHOENIX-745
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-745
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: Dmitry Salychev
>              Labels: question
>
> This is my DDL:
>     CREATE TABLE IF NOT EXISTS myTable (
>         d DATE NOT NULL, 
>         o BIGINT NOT NULL, 
>         l UNSIGNED_TINYINT NOT NULL, 
>         s UNSIGNED_TINYINT NOT NULL, 
>         r UNSIGNED_TINYINT NOT NULL, 
>         c BINARY(16) NOT NULL, 
>         t BINARY(16) NOT NULL, 
>         m BINARY(16) NOT NULL, 
>         k BINARY(16) NOT NULL, 
>         e VARCHAR NOT NULL, 
>         i VARCHAR NULL, 
>         q BINARY(16) NULL 
>         CONSTRAINT pk PRIMARY KEY (d DESC, o DESC, l, s, r, c, t, m, k)) IMMUTABLE_ROWS=true
> This is my query:
>     explain select *  from myTable where c=1 and t=3;
> And this is my result:
>     +------------+
>     |    PLAN    |
>     +------------+
>     | CLIENT PARALLEL 1-WAY FULL SCAN OVER myTable  |
>     |     SERVER FILTER BY (C = [B@4ad9da94 AND T = [B@249d50f0) |
>     +------------+
> This is my expectation of a result:
>     +------------+
>     |    PLAN    |
>     +------------+
>     | DEGENERATE SCAN OVER <myTable_pk_index> |
>     +------------+
> When I try to select something, I've got a "FULL SCAN" instead of "DEGENERATE SCAN". Is it my mistake? Or a bug?



--
This message was sent by Atlassian JIRA
(v6.2#6252)