[dbunit-developer] [ dbunit-Bugs-1791489 ] Multiple inserts on the same table with optional values

[SourceForge.net <no...@so...>]

Bugs item #1791489, was opened at 2007-09-10 07:20
Message generated for change (Comment added) made by jigarzon
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=1791489&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: v2.2
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Alessandro (aleruz)
Assigned to: Nobody/Anonymous (nobody)
Summary: Multiple inserts on the same table with optional values

Initial Comment:
Inserting multiple rows on the same table, there is a problem when some columns are optional: if the first row inserted hasn't set an optional value, the second row, even if that value is set, will be inserted without that value.

----------------------------------------------------------------------

Comment By: Juan Ignacio Garzón (jigarzon)
Date: 2007-09-19 15:04

Message:
Logged In: YES 
user_id=1478367
Originator: NO

I have the same issue:

If I write this in my datasource:
 <CATEGORIA_VALOR ID_CATEGORIA_VALOR="-1" DESCRIPCION="PROVED" />
 <CATEGORIA_VALOR ID_CATEGORIA_VALOR="-2" DESCRIPCION="DEVELOPED" />
 <CATEGORIA_VALOR ID_CATEGORIA_VALOR="-3" ID_CATEGORIA_BASE="-1"
ID_CATEGORIA_AGREGADA="-2" DESCRIPCION="PROVED DEVELOPED" />

I get in my log:
INSERT INTO CATEGORIA_VALOR VALUES(-1,NULL,NULL,'PROVED')
INSERT INTO CATEGORIA_VALOR VALUES(-2,NULL,NULL,'DEVELOPED')
INSERT INTO CATEGORIA_VALOR VALUES(-3,NULL,NULL,'PROVED DEVELOPED')

The error is that in the 3rd insert statement both middle columns are in
NULL, while they have values in the datasource XML.

BUT, if I write this (I changed the order and disabled constraint
checking):
  <CATEGORIA_VALOR ID_CATEGORIA_VALOR="-3" ID_CATEGORIA_BASE="-1"
ID_CATEGORIA_AGREGADA="-2" DESCRIPCION="PROVED DEVELOPED" />
  <CATEGORIA_VALOR ID_CATEGORIA_VALOR="-1" DESCRIPCION="PROVED" />
  <CATEGORIA_VALOR ID_CATEGORIA_VALOR="-2" DESCRIPCION="DEVELOPED" />

The records get correctly inserted:
INSERT INTO CATEGORIA_VALOR VALUES(-3,-1,-2,'PROVED DEVELOPED')
INSERT INTO CATEGORIA_VALOR VALUES(-1,NULL,NULL,'PROVED')
INSERT INTO CATEGORIA_VALOR VALUES(-2,NULL,NULL,'DEVELOPED')


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=1791489&group_id=47439