Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-274

DATETIME field doesn't match with MySQL standard

    XMLWordPrintable

    Details

    • Sprint:
      1.0.3

      Description

      This isn't a dealbreaker, by any means – but I'm curious why ColumnStore restricts the range by 400 years?

      ColumnStore supports:

      A date and time combination. Supported range is 1400-01-01 00:00:00 to 9999-12-31 23:59:59.

      That differs from MySQL 5.5+ which supports

      The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

      ColumnStore reports (when attempting a value out of range):

      ERROR 1815 (HY000) at line 306: Internal error: The default value is out of range for the specified data type.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              ernstae Andrew Ernst
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: