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)