You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Richárd Antal (Jira)" <ji...@apache.org> on 2021/09/22 11:20:00 UTC
[jira] [Assigned] (PHOENIX-4163) type BIGINT DEFAULT COLUMN
unexpect value in the covered index column
[ https://issues.apache.org/jira/browse/PHOENIX-4163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal reassigned PHOENIX-4163:
--------------------------------------
Assignee: Richárd Antal
> 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.3.4#803005)