You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2016/12/12 23:32:58 UTC
[jira] [Created] (TRAFODION-2397) Inserting null into BOOLEAN
column via trafci fails
David Wayne Birdsall created TRAFODION-2397:
-----------------------------------------------
Summary: Inserting null into BOOLEAN column via trafci fails
Key: TRAFODION-2397
URL: https://issues.apache.org/jira/browse/TRAFODION-2397
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.1-incubating
Environment: All, via trafci
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
Create the following table:
create table tbool (a int not null, b boolean, primary key (a));
Then try inserting a null value into column b. If it is done via sqlci, it works:
>>insert into table tbool values (3,null );
--- 1 row(s) inserted.
But if it is done via trafci, it fails:
SQL>insert into tbool values (4,null);
*** ERROR[4039] Column B is of type BOOLEAN, incompatible with the value's type, VARCHAR(5). [2016-12-12 23:25:49]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)