[jira] [Created] (PHOENIX-4566) Add the minimum possible value to start range for not null columns

["James Taylor (JIRA)" <ji...@apache.org>]

James Taylor created PHOENIX-4566:
-------------------------------------

             Summary: Add the minimum possible value to start range for not null columns
                 Key: PHOENIX-4566
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4566
             Project: Phoenix
          Issue Type: Improvement
            Reporter: James Taylor


We can increase the start key by appending the minimum value of any not null trailing primary key columns. For example:
{code}
CREATE TABLE T (
    A CHAR(1) NOT NULL, 
    B CHAR(1) NOT NULL,
    C CHAR(1) NOT NULL,
    CONSTRAINT PK PRIMARY KEY (A,B,C));
SELECT * FROM T WHERE A = 'A';
{code}
In this case, the start range of the scan could be 'A\0\0' instead of 'A'



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