Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1330

DB2 does not support character sets in data type

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.0
    • Component/s: core
    • Labels:
      None

      Description

      I have a very small db2 database, and it does not support "varchar(100) CHARACTER SET `ISO-8859-1`".

      db2 => select TS, cast(TS as varchar(100)) from mydb.mytimestamp
      TS 2
      -------------------------- ----------------------------------------------------------------------------------------------------
      2016-07-18-01.02.03.000000 2016-07-18-01.02.03.000000
      1 record(s) selected.
      
      db2 => select TS, cast(TS as varchar(100) CHARACTER SET "ISO-8859-1") from mydb.mytimestamp
      SQL0104N An unexpected token "CHARACTER SET "ISO-8859-1"" was found following
      "t(TS as varchar(100)". Expected tokens may include: "<space>".
      SQLSTATE=42601
      

        Activity

        Hide
        jcamachorodriguez Jesus Camacho Rodriguez added a comment -

        Resolved in release 1.9.0 (2016-09-22)

        Show
        jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.9.0 (2016-09-22)
        Hide
        julianhyde Julian Hyde added a comment -
        Show
        julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/a0c98837 . Thanks for the PR, MinJi Kim !
        Show
        minjikim MinJi Kim added a comment - https://github.com/apache/calcite/pull/260

          People

          • Assignee:
            julianhyde Julian Hyde
            Reporter:
            minjikim MinJi Kim
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development