Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1232236

Summary: Infinispan-dsl-cache translator: can't insert null into column of type boolean
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Elias <felias>
Component: TeiidAssignee: David Le Sage <dlesage>
Status: CLOSED ERRATA QA Contact: Filip Elias <felias>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: vhalbert
Target Milestone: ER3Keywords: Documentation
Target Release: 6.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
If the JDG protobuf definition does not define a default value for a boolean attribute, and a value is not passed when an insert is executed, the Hot Rod client will thrown an exception. To work around this issue, you must assign defaults in the proto def file or always pass a value for the boolean attribute.
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-09-29 23:40:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1236665    
Bug Blocks:    
Attachments:
Description Flags
Server log
none
VDB none

Description Filip Elias 2015-06-16 10:42:54 UTC
Created attachment 1039367 [details]
Server log

Inserting null into boolean column causes exception.

Sample queries:
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
insert into smalla(intKey, stringKey) values(128,'ss');

This query works:
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);

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

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.

Comment 1 Filip Elias 2015-06-16 10:43:33 UTC
Created attachment 1039368 [details]
VDB

Comment 2 JBoss JIRA Server 2015-06-30 17:33:55 UTC
Van Halbert <vhalbert> updated the status of jira TEIID-3534 to Closed

Comment 3 Van Halbert 2015-06-30 17:35:23 UTC
This has been determined to be a JDG issue (see BZ1236665).   

The work around options are:
-  assign defaults in the proto def file
-  always pass a value for the b

Comment 4 David Le Sage 2015-09-03 05:34:55 UTC
Release note drafted.