chenyunren created TRAFODION-2988:
-------------------------------------

             Summary: 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


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.
 
 This is seen on the AdvEnt2.3 20171016 daily build:
 
 >>showddl g_tpch2x.orders;
 
 CREATE TABLE TRAFODION.G_TPCH2X.ORDERS
   (
     O_ORDERKEY INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
       SERIALIZED
   , O_CUSTKEY INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
       SERIALIZED
   , O_ORDERSTATUS CHAR(1) CHARACTER SET ISO88591 COLLATE
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , O_TOTALPRICE NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
       DROPPABLE NOT SERIALIZED
   , O_ORDERDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE NOT
       SERIALIZED
   , O_ORDERPRIORITY CHAR(15) CHARACTER SET ISO88591 COLLATE
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , O_CLERK CHAR(15) CHARACTER SET ISO88591 COLLATE
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , O_SHIPPRIORITY INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
       SERIALIZED
   , O_COMMENT VARCHAR(79) CHARACTER SET ISO88591 COLLATE
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , PRIMARY KEY (O_ORDERKEY ASC)
   )
   SALT USING 8 PARTITIONS
  ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_QATEST'
 ;
 
 -- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON 
TRAFODION.G_TPCH2X.ORDERS TO DB__ROOT WITH GRANT OPTION;
 
 --- SQL operation complete.
 >>select count(*) from g_tpch2x.orders;
 
 (EXPR)
 --------------------
 
              3000000
 
 --- 1 row(s) selected.
 >>prepare XX from select * from g_tpch2x.orders where o_orderkey > 909000 or 
 >>o_orderkey < 1500;
 
 --- SQL command prepared.
 >>
 >>cqd HBASE_HASH2_PARTITIONING 'OFF';
 
 --- SQL operation complete.
 >>prepare XX from select * from g_tpch2x.orders where o_orderkey > 909000 or 
 >>o_orderkey < 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)

Reply via email to