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

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.1
• Component/s: ambari-server, ambari-upgrade
• Assignee: Dmytro Sen
• Reporter: Dmytro Sen
• Created: 20/Aug/15 16:24
• Updated: 20/Aug/15 20:55
• Resolved: 20/Aug/15 19:12

Description

I think that the alterColumn in the upgrade catalog may not be working.

dbAccessor.alterColumn("viewinstanceproperty", new DBColumnInfo("value",
    String.class, 2000, null, true));

Performed a deployment of 1.6.1 and upgraded to 2.0.1. The column is still not nullable.

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 |

Issue Links

• links to: Review Board