# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug3791.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select cidx, CDATE, date_format(cdate, '%Y%m') x, PERIOD_DIFF(
date_format(cdate, '%Y%m') ,'201105') y from datatypetestm order by cidx;

select cidx, CDATETIME, date_format(cdatetime, '%Y%m') x, PERIOD_DIFF(
date_format(cdatetime, '%Y%m') ,'201105') y from datatypetestm order by cidx;
#