[
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)
