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

DATETIME field doesn't match with MySQL standard

    XMLWordPrintable

Details

    • 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

              dleeyh Daniel Lee (Inactive)
              ernstae Andrew Ernst
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.