mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-23 07:05:36 +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>
32 lines
325 B
Plaintext
32 lines
325 B
Plaintext
USE tpch1;
|
|
create table if not exists mkr (c1 int, select_b int) engine=columnstore;
|
|
insert into mkr (c1, select_b) (select n_nationkey, n_regionkey from nation);
|
|
select * from mkr;
|
|
c1 select_b
|
|
0 0
|
|
1 1
|
|
2 1
|
|
3 1
|
|
4 4
|
|
5 0
|
|
6 3
|
|
7 3
|
|
8 2
|
|
9 2
|
|
10 4
|
|
11 4
|
|
12 2
|
|
13 4
|
|
14 0
|
|
15 0
|
|
16 0
|
|
17 1
|
|
18 2
|
|
19 3
|
|
20 4
|
|
21 2
|
|
22 3
|
|
23 3
|
|
24 1
|
|
drop table mkr;
|