[jira] [Resolved] (AMBARI-12836) During upgrade, ALTER statements to change nullability of columns are not taking effect

["Dmytro Sen (JIRA)" <ji...@apache.org>]

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

Dmytro Sen resolved AMBARI-12836.
---------------------------------
    Resolution: Fixed

Committed to trunk, branch-2.1, branch-2.1.1

> 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_2.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)