Details
- 
    Task 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    None
- 
    None
Description
The script:
| DROP DATABASE IF EXISTS MCOL_678; | 
|  | 
| CREATE DATABASE MCOL_678; | 
|  | 
| USE MCOL_678; | 
|  | 
| CREATE TABLE t(ci1 integer, ci2 integer) engine=columnstore; | 
|  | 
| INSERT INTO t(ci1, ci2) VALUES (NULL, 1), (NULL, 2), (1,3), (1,4), (2,5), (2,6), (3,7), (3,8); | 
| SELECT ci1+ci2, ci1+ci2, SUM(ci2), AVG(ci2) FROM t GROUP BY ci1+ci2, ci1+ci2; | 
| DROP TABLE t; | 
|  | 
| DROP DATABASE MCOL_678; | 
Columnstore complains with ERROR 1815 (HY000) at line 14: Internal error: MCS-2021: 'ci1+ci2' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be included in the GROUP BY clause..
Server accepts and returns correct results.