[
https://issues.apache.org/jira/browse/AMBARI-12836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705733#comment-14705733
]
Hudson commented on AMBARI-12836:
---------------------------------
FAILURE: Integrated in Ambari-trunk-Commit #3304 (See
[https://builds.apache.org/job/Ambari-trunk-Commit/3304/])
AMBARI-12836 During upgrade, ALTER statements to change nullability of columns
are not taking effect (dsen) (dsen:
http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=2b1a0f62d7e1636942d862b37eaf28349ef30a60)
*
ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog211Test.java
* ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
* ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessor.java
*
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog211.java
*
ambari-server/src/main/java/org/apache/ambari/server/orm/helpers/dbms/PostgresHelper.java
> 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)
