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

Unexpected results using LEAST or GREATEST on aggregate

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.0.8
    • 1.0.10, 1.1.0
    • None
    • None
    • 2017-10, 2017-11

    Description

      select least(min(action_date),cast('2000-01-01' as datetime)) from test; 
      

      results in 0000-00-00 00:00:00 when it should be '1999-01-01'.

      CREATE TABLE `test` (
        `action_date` date NOT NULL
      ) ENGINE=InfiniDB;
      insert into test (action_date) values ('1999-01-01');
      insert into test (action_date) values ('2020-01-01');
      select least(min(action_date),cast('2000-01-01' as datetime)) from test; 
      

      This did not happen on InfiniDB.

      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.