You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ambari.apache.org by "Jonathan Hurley (JIRA)" <ji...@apache.org> on 2014/06/12 17:13:01 UTC

[jira] [Created] (AMBARI-6099) Change restart_required from BOOLEAN to SMALLINT

Jonathan Hurley created AMBARI-6099:
---------------------------------------

             Summary: Change restart_required from BOOLEAN to SMALLINT
                 Key: AMBARI-6099
                 URL: https://issues.apache.org/jira/browse/AMBARI-6099
             Project: Ambari
          Issue Type: Task
    Affects Versions: 1.6.0
            Reporter: Jonathan Hurley
            Priority: Minor


We avoid the use of the "boolean" data type in our databases since many vendors do not support it and sometimes the behavior can be unpredictable in JPA.

BUG-18772 addresses and issue where the Postgres upgrade to schema 1.6.0 was failing because Postgres can not convert a SMALLINT to a boolean.

We should aim to be consistent in our approach to databases, and that means that we should continue to treat 0/1 fields like restart_required as a SMALLINT in Postgres, even though newer version of that database do support BOOLEAN fields.



--
This message was sent by Atlassian JIRA
(v6.2#6252)