1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-06-10 17:41:44 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/include/regression_create_empsalary.inc
Daniel Lee 4c9d6e39ac Dlee mtr restructure (#2494)
* 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>
2022-08-09 21:20:56 +03:00

22 lines
910 B
PHP
Executable File

DROP TABLE if exists empsalary;
CREATE TABLE empsalary (
depname varchar(100),
empno bigint,
salary int,
enroll_date date
)engine=columnstore;
insert into empsalary values ('develop' , 10, 5200, '2007-08-01');
insert into empsalary values ('sales' , 1, 5000, '2006-10-01');
insert into empsalary values ('personnel', 5, 3500, '2007-12-10');
insert into empsalary values ('sales' , 4, 4800, '2007-08-08');
insert into empsalary values ('personnel', 2, 3900, '2006-12-23');
insert into empsalary values ('develop' , 7, 4200, '2008-01-01');
insert into empsalary values ('develop' , 9, 4500, '2008-01-01');
insert into empsalary values ('sales' , 3, 4800, '2007-08-01');
insert into empsalary values ('develop' , 8, 6000, '2006-10-01');
insert into empsalary values ('develop' , 11, 5200, '2007-08-15');
insert into empsalary values ('develop' , 12, null, '2008-08-09');