[teiid-issues] [JBoss JIRA] (TEIID-3534) Infinispan-dsl-cache translator: can't insert null into column of type boolean

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13080682#comment-13080682 ] 

Van Halbert commented on TEIID-3534:
------------------------------------

I'm not sure this is a Teiid issue (entirely).   This is infinispan that throwing the error.  But thinking the options thru:

In case 1, passing null,  should the booleans be modeled as required with a default.   So that a valid boolean (true|false) is passed to infinispan.


In case 2, if it was modeled as required, and nothing is passed, then the default would be used, correct? 

> Infinispan-dsl-cache translator: can't insert null into column of type boolean
> ------------------------------------------------------------------------------
>
>                 Key: TEIID-3534
>                 URL: https://issues.jboss.org/browse/TEIID-3534
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1.6_2
>            Reporter: Filip Elias
>            Assignee: Van Halbert
>         Attachments: server.log, testVDB.vdb
>
>
> Inserting null into boolean column causes exception.
> Sample queries:
> {code}
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
> insert into smalla(intKey, stringKey) values(128,'ss');
> {code}
> This query works:
> {code}
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
> {code}
> Exception:
> {code}
>  Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
> 	class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
> 	path: 
> 	at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298)
> 	at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88)
> 	at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74)
> 	at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:56)
> {code}
> This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
> The whole exception is in the attachment.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)