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 "charbel (JIRA)" <ji...@apache.org> on 2007/04/26 19:22:15 UTC

[jira] Created: (DDLUTILS-171) If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.
------------------------------------------------------------------------------------------------------------------------------

                 Key: DDLUTILS-171
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-171
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - Sybase
    Affects Versions: 1.0
            Reporter: charbel
         Assigned To: Thomas Dudziak
            Priority: Blocker
             Fix For: 1.0


If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DDLUTILS-171) If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

Posted by "charbel (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DDLUTILS-171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

charbel updated DDLUTILS-171:
-----------------------------

    Attachment: patch.txt

For each column change (data type,size, required) the change is removed from the list.

> If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.
> ------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DDLUTILS-171
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-171
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - Sybase
>    Affects Versions: 1.0
>            Reporter: charbel
>         Assigned To: Thomas Dudziak
>            Priority: Blocker
>             Fix For: 1.0
>
>         Attachments: patch.txt
>
>
> If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DDLUTILS-171) If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DDLUTILS-171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Dudziak updated DDLUTILS-171:
------------------------------------

    Fix Version/s:     (was: 1.0)

> If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.
> ------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DDLUTILS-171
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-171
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - Sybase
>    Affects Versions: 1.0
>            Reporter: charbel
>         Assigned To: Thomas Dudziak
>            Priority: Blocker
>         Attachments: patch.txt
>
>
> If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Resolved: (DDLUTILS-171) If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DDLUTILS-171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Dudziak resolved DDLUTILS-171.
-------------------------------------

    Resolution: Invalid

That's what the Sybase platform is actually doing. Note that there are some cases however where it is not possible to use an ALTER TABLE MODIFY statement:

* adding or removing IDENTITY
* adding a non-IDENTITY required column that has no default value

If you have a specific error case, then please open a separate issue for this particular error, and if possible, please provide some more info about it.

> If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.
> ------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DDLUTILS-171
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-171
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - Sybase
>    Affects Versions: 1.0
>            Reporter: charbel
>         Assigned To: Thomas Dudziak
>            Priority: Blocker
>         Attachments: patch.txt
>
>
> If there is just a column change (data type,required, size) all the table is recreated. The alter comands are enough, i think.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.