# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug2892.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select cdatetime, year(cdatetime), week(cdatetime) from datatypetestm group by 1, 2, 3 order by 1;
select cdatetime, week(cdatetime) from datatypetestm group by 1, 2 order by 1;
select cdatetime, year(cdatetime) from datatypetestm group by 1, 2 order by 1;

#