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

ADDDATE & DATE_FORMAT combo breaks datetime

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.8
    • Fix Version/s: 1.0.9, 1.1.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      centos7
    • Sprint:
      2017-9

      Description

      Tableau generated queries which manipulate dates are broken in Columnstore but worked in InfiniDB. In the query below you can see that the first column "breaks" in that the returned value is not a date.

      Query example:

      SELECT 
          ADDDATE(DATE_FORMAT(datecol, '%Y-%m-%d %H:00:00'), INTERVAL 0 SECOND) AS `tableau_date`,
          cast(ADDDATE(DATE_FORMAT(datecol, '%Y-%m-%d %H:00:00'), INTERVAL 0 SECOND) as datetime) AS `casted_date`,
          datecol as raw_date
      FROM
          columnstore_table
      WHERE
          datecol >= CURRENT_DATE()
      

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            gcleaves Geoff Cleaves
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.