You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2016/05/20 01:20:16 UTC
[jira] [Updated] (TRAFODION-1801) Inserting NULL for all key
columns in a table causes a failure
[ https://issues.apache.org/jira/browse/TRAFODION-1801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller updated TRAFODION-1801:
-----------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> Inserting NULL for all key columns in a table causes a failure
> --------------------------------------------------------------
>
> Key: TRAFODION-1801
> URL: https://issues.apache.org/jira/browse/TRAFODION-1801
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 1.2-incubating
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Fix For: 2.1-incubating
>
>
> cqd allow_nullable_unique_key_constraint 'on' ;
> >>create table t1 (a int, b int, primary key (a,b)) ;
> --- SQL operation complete.
> >>showddl t1 ;
> CREATE TABLE TRAFODION.JIRA.T1
> (
> A INT DEFAULT NULL SERIALIZED
> , B INT DEFAULT NULL SERIALIZED
> , PRIMARY KEY (A ASC, B ASC)
> )
> ;
> --- SQL operation complete.
> >>insert into t1(a) values (1);
> --- 1 row(s) inserted.
> >>insert into t1(b) values (2) ;
> --- 1 row(s) inserted.
> >>select * from t1 ;
> A B
> ----------- -----------
> 1 ?
> ? 2
> --- 2 row(s) selected.
> >>insert into t1(a) values(3) ;
> --- 1 row(s) inserted.
> >>select * from t1 ;
> A B
> ----------- -----------
> 1 ?
> 3 ?
> ? 2
> --- 3 row(s) selected.
> -- fails
> >>insert into t1 values (null, null) ;
> *** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::checkAndInsertRow returned error HBASE_ACCESS_ERROR(-706). Cause:
> org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=35, exceptions:
> Tue Feb 02 19:58:34 UTC 2016, org.apache.hadoop.hbase.client.RpcRetryingCaller@4c2e0b96, java.io.IOException: com.google.protobuf.ServiceException: java.lang.NullPointerException
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)