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

GROUP BY handler doesn't support operations on aggregate functions when projecting columns.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.2
    • 1.2.0
    • None
    • None
    • 2018-13, 2018-14, 2018-15, 2018-16, 2018-17

    Description

      Steps to reproduce:

      MariaDB [cs]> describe cs1;
      +-------+---------+------+-----+---------+-------+
      | Field | Type    | Null | Key | Default | Extra |
      +-------+---------+------+-----+---------+-------+
      | i     | int(11) | YES  |     | NULL    |       |
      | it    | int(11) | YES  |     | NULL    |       |
      +-------+---------+------+-----+---------+-------+
      2 rows in set (0.00 sec)
       
      MariaDB [cs]> select * from cs1;
      +------+------+
      | i    | it   |
      +------+------+
      |    1 |    2 |
      |    3 |    4 |
      |   25 |   26 |
      +------+------+
      3 rows in set (0.01 sec)
       
      select sum(i)+1 from cs1;
      select concat('1',sum(i)) from cs1;
      select not(sum(i)) from cs1;
      

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.