[ https://issues.apache.org/jira/browse/PHOENIX-2853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-2853: ---------------------------------- Labels: SFDC (was: ) > Delete Immutable rows from View does not work if immutable index(secondary > index) exists > ---------------------------------------------------------------------------------------- > > Key: PHOENIX-2853 > URL: https://issues.apache.org/jira/browse/PHOENIX-2853 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.7.0 > Reporter: Jiping Zhou > Labels: SFDC > Fix For: 4.8.1 > > > REPRO: > --create a immutable table > CREATE TABLE IF NOT EXISTS TEST_TABLE ( > FIELD1 CHAR(3) NOT NULL, > FIELD2 CHAR(3) NOT NULL, > CONSTRAINT PK PRIMARY KEY ( > FIELD1, > FIELD2 > ) > ) VERSIONS=1, IMMUTABLE_ROWS=true, MULTI_TENANT=true, REPLICATION_SCOPE=1 > --create a new view on the immutable table > CREATE VIEW IF NOT EXISTS TEST_VIEW ( > FIELD3 INTEGER NOT NULL, > FIELD4 VARCHAR NOT NULL, > CONSTRAINT PKVIEW PRIMARY KEY > ( > FIELD3 DESC > ) > ) > AS SELECT * FROM TEST_TABLE WHERE FIELD2 = '001' > -- create secondary index on the > CREATE INDEX IF NOT EXISTS TEST_SECONDARY_INDEX > ON TEST_VIEW (FIELD4 DESC) > INCLUDE (FIELD3) > REPLICATION_SCOPE=1 > --Delete rows for TEST_VIEW > delete from TEST_VIEW where FIELD1 = '000'; > [Expect] The rows can be removed > [Actual] Under DeleteCompiler.Compile(), the secondary index will be > considered as immutable index. And as line 408, table.getType will be VIEW > instead of PTableType.INDEX, we will get error in line 425 with the exception. -- This message was sent by Atlassian JIRA (v6.3.4#6332)