CMDBuild Forum

Re: "Massive change" bug with classes with boolean attributes

Because the impact of the bug on the data could be significant, I report a problem with this forum (which Tecnoteca already know) on the use of the utility of massive change of the cards.

Changing any attribute in a selection of records in a class in which some attributes are boolean, we have that any boolean attributes of the class are set to FALSE.

Here's an excerpt of the query that made me find the problem:

10/21/2010 16:21:56 DEBUG [SQL] UPDATE "Server" SET "Virtual" = false, "MprocModel" = 139026 "PowerRedundancy" = false, "BootOnSAN" = false WHERE ("classid", "Id ") IN (SELECT DISTINCT" Server "." classid ":: int4 AS 'Server_IdClass", "Server". "Id" AS "server_id" FROM "Server" AS "Server" WHERE (("Server". "classid" :: int4, "Server". "Id") IN

Obviously the state of the Boolean attributes changed involuntarily is recoverable from the history table. But prevention is better than cure ...

Regards,

Luca

Thank you again for you report.

As said yesterday by mail the solution for this problem will be included in the next release of CMDBuild (1.3)

 

Best regards,

Lisa