You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Machiel Groeneveld (JIRA)" <ji...@apache.org> on 2006/05/09 08:23:21 UTC

[jira] Created: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
-----------------------------------------------------------------------------------------------------------

         Key: DDLUTILS-105
         URL: http://issues.apache.org/jira/browse/DDLUTILS-105
     Project: DdlUtils
        Type: Bug

  Components: Core  
    Reporter: Machiel Groeneveld
 Assigned to: Thomas Dudziak 


When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Commented: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

Posted by "Machiel Groeneveld (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-105?page=comments#action_12412805 ] 

Machiel Groeneveld commented on DDLUTILS-105:
---------------------------------------------

oracle 10g

> When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
> -----------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-105
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-105
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>     Reporter: Machiel Groeneveld
>     Assignee: Thomas Dudziak

>
> When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Updated: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-105?page=all ]

Thomas Dudziak updated DDLUTILS-105:
------------------------------------

    Component: Core - Oracle
                   (was: Core (No specific database))

> When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
> -----------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-105
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-105
>      Project: DdlUtils
>         Type: Bug

>   Components: Core - Oracle
>     Reporter: Machiel Groeneveld
>     Assignee: Thomas Dudziak

>
> When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Resolved: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-105?page=all ]
     
Thomas Dudziak resolved DDLUTILS-105:
-------------------------------------

    Resolution: Fixed

DdlUtils can now at least read-back those autoincrement columns that it itself created before

> When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
> -----------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-105
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-105
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>     Reporter: Machiel Groeneveld
>     Assignee: Thomas Dudziak

>
> When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Commented: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-105?page=comments#action_12378713 ] 

Thomas Dudziak commented on DDLUTILS-105:
-----------------------------------------

Please specify the database where the problem occurred.

> When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
> -----------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-105
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-105
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>     Reporter: Machiel Groeneveld
>     Assignee: Thomas Dudziak

>
> When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Commented: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-105?page=comments#action_12412830 ] 

Thomas Dudziak commented on DDLUTILS-105:
-----------------------------------------

Please update your DdlUtils from SVN -  I have done considerable work on the database alteration part, and for Oracle this should work now.

> When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
> -----------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-105
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-105
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>     Reporter: Machiel Groeneveld
>     Assignee: Thomas Dudziak

>
> When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Commented: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-105?page=comments#action_12412831 ] 

Thomas Dudziak commented on DDLUTILS-105:
-----------------------------------------

Oh, and DdlUtils currently cannot determine whether a column is autoincrement when reading a model from a live Oracle database (I havn't figured out yet how to access this info), which will lead to all columns being autoincrement = false. 

> When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created
> -----------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-105
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-105
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>     Reporter: Machiel Groeneveld
>     Assignee: Thomas Dudziak

>
> When doing a clean create database I get a sequence for my autoincrement column. But when upgrading ddlutils doesn't 'see' that the change from autoincrement=false to autoincrement=true should lead to the creation of a sequence. This makes upgrading an existing database more difficult.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira