mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-06-10 17:41:44 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
26 lines
663 B
SQL
Executable File
26 lines
663 B
SQL
Executable File
# create dateinfo table
|
|
#
|
|
--disable_warnings
|
|
drop table if exists dateinfo;
|
|
--enable_warnings
|
|
create table `dateinfo` (
|
|
d_datekey int,
|
|
d_date char (18),
|
|
d_dayofweek char (9),
|
|
d_month char (9),
|
|
d_year int,
|
|
d_yearmonthnum int,
|
|
d_yearmonth char (7),
|
|
d_daynuminweek int,
|
|
d_daynuminmonth int,
|
|
d_daynuminyear int,
|
|
d_monthnuminyear int,
|
|
d_weeknuminyear int,
|
|
d_sellingseason varchar (12),
|
|
d_lastdayinweekfl tinyint,
|
|
d_lastdayinmonthfl tinyint,
|
|
d_holidayfl tinyint,
|
|
d_weekdayfl tinyint
|
|
) engine=Columnstore;
|
|
SHOW CREATE TABLE dateinfo;
|