DdlUtils
  1. DdlUtils
  2. DDLUTILS-22

DB2 type mapping for BOOLEAN should be SMALLINT?

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Core - DB2
    • Labels:
      None

      Description

      The mapping in Db2Platform for "BOOLEAN" is currently "CHAR FOR BIT DATA". According to these docs:
      http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/ad/rjvjdata.htm#jvregou
      it looks like it should be 'SMALLINT' ?

        Activity

        Richard Bounds created issue -
        Hide
        Thomas Dudziak added a comment -

        While CHAR FOR BIT DATA should work just as well (the driver converts the value automatically), you might be right, if the docs suggest SMALLINT, I think we should follow that suggestion. I'll commit a fix.

        Show
        Thomas Dudziak added a comment - While CHAR FOR BIT DATA should work just as well (the driver converts the value automatically), you might be right, if the docs suggest SMALLINT, I think we should follow that suggestion. I'll commit a fix.
        Hide
        Thomas Dudziak added a comment -

        Fix submitted

        Show
        Thomas Dudziak added a comment - Fix submitted
        Thomas Dudziak made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Hide
        Richard Bounds added a comment -

        looks good to me.

        Show
        Richard Bounds added a comment - looks good to me.
        Richard Bounds made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Thomas Dudziak made changes -
        Component/s Core - DB2 [ 12311209 ]

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Richard Bounds
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development