ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmytro Sen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AMBARI-12836) During upgrade, ALTER statements to change nullability of columns are not taking effect
Date Thu, 20 Aug 2015 17:05:45 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-12836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dmytro Sen updated AMBARI-12836:
--------------------------------
    Attachment: AMBARI-12836.patch

> During upgrade, ALTER statements to change nullability of columns are not taking effect
> ---------------------------------------------------------------------------------------
>
>                 Key: AMBARI-12836
>                 URL: https://issues.apache.org/jira/browse/AMBARI-12836
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server, ambari-upgrade
>    Affects Versions: 2.1.0
>            Reporter: Dmytro Sen
>            Assignee: Dmytro Sen
>            Priority: Blocker
>             Fix For: 2.1.1
>
>         Attachments: AMBARI-12836.patch
>
>
> I think that the alterColumn in the upgrade catalog may not be working.
> {code}
> dbAccessor.alterColumn("viewinstanceproperty", new DBColumnInfo("value",
>     String.class, 2000, null, true));{code}
> Performed a deployment of 1.6.1 and upgraded to 2.0.1. The column is still not nullable.

> {code}ambari=> \d+ viewinstanceproperty;
>                         Table "ambari.viewinstanceproperty"
>        Column       |          Type           | Modifiers | Storage  | Description
> --------------------+-------------------------+-----------+----------+-------------
>  view_name          | character varying(255)  | not null  | extended |
>  view_instance_name | character varying(255)  | not null  | extended |
>  name               | character varying(255)  | not null  | extended |
>  value              | character varying(2000) | not null  | extended |
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message