#763 NULL insertion in NOT NULL column.

[Giovanni Cerretani]

Hello. Here at Virgo, we have upgraded a TANGO8 database to TANGO9 using the update_db.sql generated during the compilation. Inside the file, lines 113-122, you are trying do insert a NULL value in a NOT NULL column. For full compatibility, they should be changed in this way:

INSERT INTO property_class VALUES('Database','AllowedAccessCmd',[...],'[...]',NOW(),NOW(),NULL);

MyISAM allows this, while it returns an error while using nbdcluster. It is similar to what has been fixed in commit 28284.

Cheers,

Giovanni, Luca and Franco

[Emmanuel Taurel]

Hi Giovanni,

Thank's for the info. This will be fixed for next release

Regards

Emmanuel