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

ADDDATE & DATE_FORMAT combo breaks datetime

    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: