cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alena Prokharchyk (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-2676) Add Not Null Constraint to UUID columns for cloudstack schema to avoid empty UUID column
Date Wed, 31 Jul 2013 23:23:49 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13725826#comment-13725826
] 

Alena Prokharchyk commented on CLOUDSTACK-2676:
-----------------------------------------------

I think its too late to add as it will affect the db upgrade for all the tables in cloud/cloud_usage
tables.
                
> 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

Mime
View raw message