[MCOL-1357] Can GROUP BY NULL when infinidb_vtable_mode=0 Created: 2018-04-22  Updated: 2018-04-23  Resolved: 2018-04-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.0.13, 1.1.4
Fix Version/s: 1.1.4

Type: Bug Priority: Minor
Reporter: Roman Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

MariaDB [cs]> create table cs1(a varchar(1), i bigint) engine=columnstore;
Query OK, 0 rows affected (2.69 sec)

MariaDB [cs]> insert into cs1 values ('a',1),('b',2),('c',3),('d',4);
Query OK, 4 rows affected (0.43 sec)
Records: 4 Duplicates: 0 Warnings: 0

MariaDB [cs]> select a from cs1 group by a;
------

a

------

a
b
c
d

------
4 rows in set (0.10 sec)

MariaDB [cs]> set infinidb_vtable_mode=1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [cs]> select a from cs1 group by null;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2016: Non supported item 'NULL' on the GROUP BY list.

MariaDB [cs]> set infinidb_vtable_mode=0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [cs]>
MariaDB [cs]> select a from cs1 group by null;
------

a

------

a

------
1 row in set (0.02 sec)



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-04-23 ]

The bug is the inverse of what is described. GROUP BY NULL should work as shown when vtable mode is off, but it doesn't for vtable mode on. I am tempted to close as "Not a Bug" since vtable will eventually go away.

Comment by Roman [ 2018-04-23 ]

Read the first comment by Andrew.

Generated at Thu Feb 08 02:28:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.