[ https://issues.apache.org/jira/browse/PHOENIX-4163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal resolved PHOENIX-4163. ------------------------------------ Resolution: Duplicate > type BIGINT DEFAULT COLUMN unexpect value in the covered index column > --------------------------------------------------------------------- > > Key: PHOENIX-4163 > URL: https://issues.apache.org/jira/browse/PHOENIX-4163 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.11.0 > Reporter: hanzhi > Assignee: Richárd Antal > Priority: Major > > the result should be 1000,but it is an expected value. below is an example > CREATE TABLE PHOENIX.TEST_DEFAULT ( > A INTEGER NOT NULL, > B VARCHAR NOT NULL DEFAULT 'AB', > C BIGINT DEFAULT 200, > D BIGINT DEFAULT 200, > E BIGINT DEFAULT 200, > F VARCHAR DEFAULT 'AB', > CONSTRAINT DOS_PK PRIMARY KEY (A,B)); > CREATE INDEX IDX_TEST_DEFAULT ON PHOENIX.TEST_DEFAULT(C, F) INCLUDE(D,E); > upsert into PHOENIX.TEST_DEFAULT values(1000); > select A from PHOENIX.TEST_DEFAULT; -- This message was sent by Atlassian Jira (v8.20.1#820001)