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

ADDDATE & DATE_FORMAT combo breaks datetime

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.8
    • 1.0.9, 1.1.0
    • None
    • None
    • centos7
    • 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

            dleeyh Daniel Lee (Inactive)
            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.