[
https://issues.apache.org/jira/browse/TRAFODION-1983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15277475#comment-15277475
]
ASF GitHub Bot commented on TRAFODION-1983:
-------------------------------------------
GitHub user zellerh opened a pull request:
https://github.com/apache/incubator-trafodion/pull/471
TRAFODION-1983 error in preCodeGen plus more items
This also constains a fix for TRAFODION-1710 (setString in UDFs does not
accept numeric values with scale) as well as misc small fixes. It may make more
sense to review the three commits in this PR separately, as they are on
different topics.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zellerh/incubator-trafodion bug/1910
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/471.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #471
----
commit a2786b57d71e7876b204c0925047cf736b1ee44d
Author: Hans Zeller <hzel...@apache.org>
Date: 2016-05-10T01:47:19Z
TRAFODION-1983 Generator error 7000 with a salted table
commit a4caa9ac4afe331358a74b211784a08779ca298e
Author: Hans Zeller <hzel...@apache.org>
Date: 2016-05-10T01:49:18Z
TRAFODION-1710 setString() method and numerics with scale
The setString() method did not accept strings with digits after
the decimal point, like setString(1, "123.45").
commit 855759f387e7ab0fc677f6138ac5e580b2eeca39
Author: Hans Zeller <hzel...@apache.org>
Date: 2016-05-10T01:56:35Z
Misc cleanup items
Added a debugging method to print information for the list of all
Trafodion IPC connections in a process - that method can be called
from the debugger.
Removed unneeded code in preCodeGen - ValueIdSets for predicates imply
an AND, so no AND operators must be found in them.
Removed unnecessary flags in a makefile.
----
> 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)
