bug #8702
Updated by Andreas Müller over 4 years ago
Some databases do have uuid NOT NULL contraints in some _AUD tables. In caryo_spp I found the following tables with this problem, which is probably created by the model update script for these tables: AmplificationResult_AUD CdmLink_AUD DnaQuality_AUD Identifier_AUD Registration_AUD In other DBs also: SingleReadAlignment_AUD TaxonNodeAgentRelation_AUD ~~The strange thing is that for caryo_nepenthes CdmLink_AUD does allow NULL for CdmLink_AUD (a very new model update) while in caryo_spp it is NOT NULL. While it is not very likely that someone changed this manually already it is not clear why the 2 databases were updated in a different way.~~ This is not so strange as CdmLink_AUD was only renamed, it was IntextReference before. The exception that is thrwon otherwise is: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'uuid' cannot be null is thrown.