[
https://issues.apache.org/jira/browse/TRAFODION-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15743781#comment-15743781
]
Anoop Sharma commented on TRAFODION-2397:
-----------------------------------------
boolean support from odbc/jdbc is not yet fully supported.
JIRA 2385 is tracking that.
Once that jira is implemented, boolean inserts and selects from odbc/jdbc will
work.
can set cqd traf_boolean_io 'ON'
from trafci for this insert stmt to work.
This is not yet the default until 2385 is done.
> 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)
