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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3534:
---------------------------------------

The first two inserts are likely the same if the column is marked as nullable.  It seems surprising that a null boolean value is not allowed though, can you check if that is expected?  Does this happen if other values are null?

If null is not allowed, then the column should be marked as not null.  The if no default is specified, an exception will be thrown saying a value is required.  Or if there is a default, it will be used.


> 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)