[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chenyunren updated TRAFODION-2988: ---------------------------------- Description: Prepare query returns a 2006 internal error at mdam.cpp:1611 when the CQD HBASE_HASH2_PARTITIONING is turned off. >>showddl t1; CREATE TABLE TRAFODION.T1 ( C1 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C2 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C3 CHAR(1) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C4 NUMERIC(12, 2) NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C5 DATE NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C6 CHAR(15) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C7 CHAR(15) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C8 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C9 VARCHAR(79) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , PRIMARY KEY (C1 ASC) ) SALT USING 8 PARTITIONS ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_QATEST' ; – GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.T1 TO DB__ROOT WITH GRANT OPTION; — SQL operation complete. >>select count( * ) from t1; (EXPR) -------------------- 3000000 — 1 row(s) selected. >>prepare XX from select * from t1 where c1 > 909000 or c1 < 1500; — SQL command prepared. >> >>cqd HBASE_HASH2_PARTITIONING 'OFF'; — SQL operation complete. >>prepare XX from select * from t1 where c1 > 909000 or c1 < 1500; ERROR[2006] Internal error: assertion failure (NOT commonPreds.isEmpty()) in file ../optimizer/mdam.cpp at line 1611. ERROR[8822] The statement was not prepared. Need update statistics first. was: This query preparation comes from an existing regression test and it used to work fine. Now it returns a 2006 internal error at mdam.cpp:1611 when the CQD HBASE_HASH2_PARTITIONING is turned off. >>showddl t1; CREATE TABLE TRAFODION.T1 ( C1 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C2 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C3 CHAR(1) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C4 NUMERIC(12, 2) NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C5 DATE NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C6 CHAR(15) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C7 CHAR(15) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C8 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , C9 VARCHAR(79) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , PRIMARY KEY (C1 ASC) ) SALT USING 8 PARTITIONS ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_QATEST' ; – GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.T1 TO DB__ROOT WITH GRANT OPTION; — SQL operation complete. >>select count( * ) from t1; (EXPR) -------------------- 3000000 — 1 row(s) selected. >>prepare XX from select * from t1 where c1 > 909000 or c1 < 1500; — SQL command prepared. >> >>cqd HBASE_HASH2_PARTITIONING 'OFF'; — SQL operation complete. >>prepare XX from select * from t1 where c1 > 909000 or c1 < 1500; ERROR[2006] Internal error: assertion failure (NOT commonPreds.isEmpty()) in file ../optimizer/mdam.cpp at line 1611. ERROR[8822] The statement was not prepared. Need update statistics first. > Prepare query returns 2006 internal error > ----------------------------------------- > > Key: TRAFODION-2988 > URL: https://issues.apache.org/jira/browse/TRAFODION-2988 > Project: Apache Trafodion > Issue Type: Bug > Reporter: chenyunren > Assignee: chenyunren > Priority: Major > > Prepare query returns a 2006 internal error at mdam.cpp:1611 when the CQD > HBASE_HASH2_PARTITIONING is turned off. > >>showddl t1; > CREATE TABLE TRAFODION.T1 > ( > C1 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT > SERIALIZED > , C2 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT > SERIALIZED > , C3 CHAR(1) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED > , C4 NUMERIC(12, 2) NO DEFAULT NOT NULL NOT > DROPPABLE NOT SERIALIZED > , C5 DATE NO DEFAULT NOT NULL NOT DROPPABLE NOT > SERIALIZED > , C6 CHAR(15) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED > , C7 CHAR(15) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED > , C8 INT NO DEFAULT NOT NULL NOT DROPPABLE NOT > SERIALIZED > , C9 VARCHAR(79) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED > , PRIMARY KEY (C1 ASC) > ) > SALT USING 8 PARTITIONS > ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_QATEST' > ; > – GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.T1 TO > DB__ROOT WITH GRANT OPTION; > — SQL operation complete. > >>select count( * ) from t1; > (EXPR) > -------------------- > 3000000 > — 1 row(s) selected. > >>prepare XX from select * from t1 where c1 > 909000 or c1 < 1500; > — SQL command prepared. > >> > >>cqd HBASE_HASH2_PARTITIONING 'OFF'; > — SQL operation complete. > >>prepare XX from select * from t1 where c1 > 909000 or c1 < 1500; > ERROR[2006] Internal error: assertion failure (NOT commonPreds.isEmpty()) in > file ../optimizer/mdam.cpp at line 1611. > ERROR[8822] The statement was not prepared. > > Need update statistics first. -- This message was sent by Atlassian JIRA (v7.6.3#76005)