Min Chen created CLOUDSTACK-2676:
------------------------------------
Summary: Add Not Null Constraint to UUID columns for cloudstack
schema to avoid empty UUID column
Key: CLOUDSTACK-2676
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2676
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Affects Versions: 4.2.0
Reporter: Min Chen
Fix For: 4.2.0
To make sure that we have a consistent upgrade base for all 4.1 customers
later, in schema-410to420.sql, we have added sql scripts to populate UUID
column of all pre-4.1 schema tables with values from their ID column if UUID
column is NULL. To make this work properly, we require that all UUID columns
should be populated with values when you add new data into both pre-4.1 schema
or post-4.1 schema. To properly enforce this, we should add Not Null constraint
at DB level to UUID columns for cloudstack schema. We need to make sure you add
those constraints after upgrading the data.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
