[
https://issues.apache.org/jira/browse/TRAFODION-1983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279057#comment-15279057
]
ASF GitHub Bot commented on TRAFODION-1983:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/471
> Generator error 7000 (should never reach ...) with a salted table
> -----------------------------------------------------------------
>
> Key: TRAFODION-1983
> URL: https://issues.apache.org/jira/browse/TRAFODION-1983
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.0-incubating
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.1-incubating
>
>
> Preparing such a query results in the following error:
> *** ERROR[7000] An internal error occurred in the code generator in file
> ../generator/GenItemExpr.cpp at line nnn:
> VEGRef_100((TRAFODION.MYSCHEMA.ORDERS.O_ORDERKEY = 1000000)) should never
> reach ItemExpr::codeGen.
> To reproduce:
> CREATE TABLE ORDERS
> (
> O_ORDERKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , O_CUSTKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , O_ORDERSTATUS CHAR(1) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , O_TOTALPRICE NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
> DROPPABLE 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 SERIALIZED
> , O_CLERK CHAR(15) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , O_SHIPPRIORITY INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , O_COMMENT VARCHAR(79) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , PRIMARY KEY (O_ORDERKEY ASC)
> )
> SALT USING 8 PARTITIONS
> ;
> cqd QUERY_CACHE '0';
> cqd CACHE_HISTOGRAMS reset;
> cqd HBASE_HASH2_PARTITIONING 'OFF';
> cqd HBASE_RANGE_PARTITIONING 'ON';
> prepare XX from select * from orders where o_orderkey = 1000000;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
