You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +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>
527 lines
8.8 KiB
Plaintext
527 lines
8.8 KiB
Plaintext
USE tpch1;
|
|
select cidx from datatypetestm where cidx is null order by 1;
|
|
cidx
|
|
select cbigint from datatypetestm where cbigint is null order by 1;
|
|
cbigint
|
|
select cdecimal1 from datatypetestm where cdecimal1 is null order by 1;
|
|
cdecimal1
|
|
select cdecimal4 from datatypetestm where cdecimal4 is null order by 1;
|
|
cdecimal4
|
|
select cdecimal4_2 from datatypetestm where cdecimal4_2 is null order by 1;
|
|
cdecimal4_2
|
|
select cdecimal5 from datatypetestm where cdecimal5 is null order by 1;
|
|
cdecimal5
|
|
select cdecimal9 from datatypetestm where cdecimal9 is null order by 1;
|
|
cdecimal9
|
|
select cdecimal9_2 from datatypetestm where cdecimal9_2 is null order by 1;
|
|
cdecimal9_2
|
|
select cdecimal10 from datatypetestm where cdecimal10 is null order by 1;
|
|
cdecimal10
|
|
select cdecimal18 from datatypetestm where cdecimal18 is null order by 1;
|
|
cdecimal18
|
|
select cdecimal18_2 from datatypetestm where cdecimal18_2 is null order by 1;
|
|
cdecimal18_2
|
|
select cinteger from datatypetestm where cinteger is null order by 1;
|
|
cinteger
|
|
select csmallint from datatypetestm where csmallint is null order by 1;
|
|
csmallint
|
|
select ctinyint from datatypetestm where ctinyint is null order by 1;
|
|
ctinyint
|
|
select cdate from datatypetestm where cdate is null order by 1;
|
|
cdate
|
|
select cdatetime from datatypetestm where cdatetime is null order by 1;
|
|
cdatetime
|
|
select cchar1 from datatypetestm where cchar1 is null order by 1;
|
|
cchar1
|
|
NULL
|
|
select cchar2 from datatypetestm where cchar2 is null order by 1;
|
|
cchar2
|
|
NULL
|
|
select cchar3 from datatypetestm where cchar3 is null order by 1;
|
|
cchar3
|
|
NULL
|
|
select cchar4 from datatypetestm where cchar4 is null order by 1;
|
|
cchar4
|
|
NULL
|
|
select cchar5 from datatypetestm where cchar5 is null order by 1;
|
|
cchar5
|
|
NULL
|
|
select cchar6 from datatypetestm where cchar6 is null order by 1;
|
|
cchar6
|
|
NULL
|
|
select cchar7 from datatypetestm where cchar7 is null order by 1;
|
|
cchar7
|
|
NULL
|
|
select cchar8 from datatypetestm where cchar8 is null order by 1;
|
|
cchar8
|
|
NULL
|
|
select cchar9 from datatypetestm where cchar9 is null order by 1;
|
|
cchar9
|
|
NULL
|
|
select cchar255 from datatypetestm where cchar255 is null order by 1;
|
|
cchar255
|
|
NULL
|
|
select cvchar1 from datatypetestm where cvchar1 is null order by 1;
|
|
cvchar1
|
|
NULL
|
|
select cvchar2 from datatypetestm where cvchar2 is null order by 1;
|
|
cvchar2
|
|
NULL
|
|
select cvchar3 from datatypetestm where cvchar3 is null order by 1;
|
|
cvchar3
|
|
NULL
|
|
select cvchar4 from datatypetestm where cvchar4 is null order by 1;
|
|
cvchar4
|
|
NULL
|
|
select cvchar5 from datatypetestm where cvchar5 is null order by 1;
|
|
cvchar5
|
|
NULL
|
|
select cvchar6 from datatypetestm where cvchar6 is null order by 1;
|
|
cvchar6
|
|
NULL
|
|
select cvchar7 from datatypetestm where cvchar7 is null order by 1;
|
|
cvchar7
|
|
NULL
|
|
select cvchar8 from datatypetestm where cvchar8 is null order by 1;
|
|
cvchar8
|
|
NULL
|
|
select cvchar255 from datatypetestm where cvchar255 is null order by 1;
|
|
cvchar255
|
|
NULL
|
|
select cidx from datatypetestm where cidx is not null order by 1;
|
|
cidx
|
|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
6
|
|
7
|
|
8
|
|
9
|
|
10
|
|
11
|
|
select cbigint from datatypetestm where cbigint is not null order by 1;
|
|
cbigint
|
|
-72036854775806
|
|
-72036854775805
|
|
-72036854775804
|
|
-72036854775803
|
|
-72036854775802
|
|
0
|
|
72036854775803
|
|
72036854775804
|
|
72036854775805
|
|
72036854775806
|
|
72036854775807
|
|
select cdecimal1 from datatypetestm where cdecimal1 is not null order by 1;
|
|
cdecimal1
|
|
-9
|
|
-8
|
|
-7
|
|
-6
|
|
-5
|
|
0
|
|
5
|
|
6
|
|
7
|
|
8
|
|
9
|
|
select cdecimal4 from datatypetestm where cdecimal4 is not null order by 1;
|
|
cdecimal4
|
|
-999
|
|
-998
|
|
-997
|
|
-996
|
|
-995
|
|
0
|
|
995
|
|
996
|
|
997
|
|
998
|
|
999
|
|
select cdecimal4_2 from datatypetestm where cdecimal4_2 is not null order by 1;
|
|
cdecimal4_2
|
|
-9.99
|
|
-9.98
|
|
-9.97
|
|
-9.96
|
|
-9.95
|
|
0.00
|
|
9.95
|
|
9.96
|
|
9.97
|
|
9.98
|
|
9.99
|
|
select cdecimal5 from datatypetestm where cdecimal5 is not null order by 1;
|
|
cdecimal5
|
|
-999
|
|
-998
|
|
-997
|
|
-996
|
|
-995
|
|
0
|
|
995
|
|
996
|
|
997
|
|
998
|
|
999
|
|
select cdecimal9 from datatypetestm where cdecimal9 is not null order by 1;
|
|
cdecimal9
|
|
-999999
|
|
-999998
|
|
-999997
|
|
-999996
|
|
-999995
|
|
0
|
|
999995
|
|
999996
|
|
999997
|
|
999998
|
|
999999
|
|
select cdecimal9_2 from datatypetestm where cdecimal9_2 is not null order by 1;
|
|
cdecimal9_2
|
|
-9999.99
|
|
-9999.98
|
|
-9999.97
|
|
-9999.96
|
|
-9999.95
|
|
0.00
|
|
9999.95
|
|
9999.96
|
|
9999.97
|
|
9999.98
|
|
9999.99
|
|
select cdecimal10 from datatypetestm where cdecimal10 is not null order by 1;
|
|
cdecimal10
|
|
-9999999
|
|
-9999998
|
|
-9999997
|
|
-9999996
|
|
-9999995
|
|
0
|
|
9999995
|
|
9999996
|
|
9999997
|
|
9999998
|
|
9999999
|
|
select cdecimal18 from datatypetestm where cdecimal18 is not null order by 1;
|
|
cdecimal18
|
|
-9999999999999
|
|
-9999999999998
|
|
-9999999999997
|
|
-9999999999996
|
|
-9999999999995
|
|
0
|
|
9999999999995
|
|
9999999999996
|
|
9999999999997
|
|
9999999999998
|
|
9999999999999
|
|
select cdecimal18_2 from datatypetestm where cdecimal18_2 is not null order by 1;
|
|
cdecimal18_2
|
|
-99999999999.99
|
|
-99999999999.98
|
|
-99999999999.97
|
|
-99999999999.96
|
|
-99999999999.95
|
|
0.00
|
|
99999999999.95
|
|
99999999999.96
|
|
99999999999.97
|
|
99999999999.98
|
|
99999999999.99
|
|
select cinteger from datatypetestm where cinteger is not null order by 1;
|
|
cinteger
|
|
-7483646
|
|
-7483645
|
|
-7483644
|
|
-7483643
|
|
-7483642
|
|
0
|
|
7483643
|
|
7483644
|
|
7483645
|
|
7483646
|
|
7483647
|
|
select csmallint from datatypetestm where csmallint is not null order by 1;
|
|
csmallint
|
|
-766
|
|
-765
|
|
-764
|
|
-763
|
|
-762
|
|
0
|
|
763
|
|
764
|
|
765
|
|
766
|
|
767
|
|
select ctinyint from datatypetestm where ctinyint is not null order by 1;
|
|
ctinyint
|
|
-26
|
|
-25
|
|
-24
|
|
-23
|
|
-22
|
|
0
|
|
23
|
|
24
|
|
25
|
|
26
|
|
27
|
|
select cdate from datatypetestm where cdate is not null order by 1;
|
|
cdate
|
|
1997-01-01
|
|
1997-01-01
|
|
1997-01-02
|
|
1997-01-03
|
|
1997-01-04
|
|
2009-12-28
|
|
2009-12-29
|
|
2009-12-30
|
|
2009-12-31
|
|
2009-12-31
|
|
2009-12-31
|
|
select cdatetime from datatypetestm where cdatetime is not null order by 1;
|
|
cdatetime
|
|
1997-01-01 00:00:00
|
|
1997-01-01 00:00:01
|
|
1997-01-02 00:00:01
|
|
1997-01-03 00:00:02
|
|
1997-01-04 00:00:03
|
|
2009-12-31 23:59:56
|
|
2009-12-31 23:59:57
|
|
2009-12-31 23:59:58
|
|
2009-12-31 23:59:59
|
|
2009-12-31 23:59:59
|
|
2009-12-31 23:59:59
|
|
select cchar1 from datatypetestm where cchar1 is not null order by 1;
|
|
cchar1
|
|
a
|
|
a
|
|
a
|
|
a
|
|
a
|
|
z
|
|
z
|
|
z
|
|
z
|
|
z
|
|
select cchar2 from datatypetestm where cchar2 is not null order by 1;
|
|
cchar2
|
|
aa
|
|
b
|
|
bb
|
|
bb
|
|
bb
|
|
yy
|
|
yy
|
|
yy
|
|
yy
|
|
zz
|
|
select cchar3 from datatypetestm where cchar3 is not null order by 1;
|
|
cchar3
|
|
aaa
|
|
c
|
|
cc
|
|
ccc
|
|
ccc
|
|
xxx
|
|
xxx
|
|
xxx
|
|
xxx
|
|
zzz
|
|
select cchar4 from datatypetestm where cchar4 is not null order by 1;
|
|
cchar4
|
|
aaaa
|
|
d
|
|
dd
|
|
ddd
|
|
dddd
|
|
wwww
|
|
wwww
|
|
wwww
|
|
wwww
|
|
zzzz
|
|
select cchar5 from datatypetestm where cchar5 is not null order by 1;
|
|
cchar5
|
|
aaaaa
|
|
e
|
|
ee
|
|
eee
|
|
eeee
|
|
vvvvv
|
|
vvvvv
|
|
vvvvv
|
|
vvvvv
|
|
zzzzz
|
|
select cchar6 from datatypetestm where cchar6 is not null order by 1;
|
|
cchar6
|
|
aaaaaa
|
|
f
|
|
ff
|
|
fff
|
|
ffff
|
|
uuuuuu
|
|
uuuuuu
|
|
uuuuuu
|
|
uuuuuu
|
|
zzzzzz
|
|
select cchar7 from datatypetestm where cchar7 is not null order by 1;
|
|
cchar7
|
|
aaaaaaa
|
|
g
|
|
gg
|
|
ggg
|
|
gggg
|
|
ttttttt
|
|
ttttttt
|
|
ttttttt
|
|
ttttttt
|
|
zzzzzzz
|
|
select cchar8 from datatypetestm where cchar8 is not null order by 1;
|
|
cchar8
|
|
aaaaaaaa
|
|
h
|
|
hh
|
|
hhh
|
|
hhhh
|
|
sssssss
|
|
ssssssss
|
|
ssssssss
|
|
ssssssss
|
|
zzzzzzzz
|
|
select cchar9 from datatypetestm where cchar9 is not null order by 1;
|
|
cchar9
|
|
aaaaaaaaa
|
|
i
|
|
ii
|
|
iii
|
|
iiii
|
|
rrrrrrr
|
|
rrrrrrrr
|
|
rrrrrrrrr
|
|
rrrrrrrrr
|
|
zzzzzzzzz
|
|
select cchar255 from datatypetestm where cchar255 is not null order by 1;
|
|
cchar255
|
|
aaaaaaaaaa
|
|
j
|
|
jj
|
|
jjj
|
|
jjjj
|
|
qqqqqqq
|
|
qqqqqqqq
|
|
qqqqqqqqq
|
|
qqqqqqqqqq
|
|
zzzzzzzzzz
|
|
select cvchar1 from datatypetestm where cvchar1 is not null order by 1;
|
|
cvchar1
|
|
a
|
|
a
|
|
a
|
|
a
|
|
a
|
|
z
|
|
z
|
|
z
|
|
z
|
|
z
|
|
select cvchar2 from datatypetestm where cvchar2 is not null order by 1;
|
|
cvchar2
|
|
aa
|
|
b
|
|
bb
|
|
bb
|
|
bb
|
|
yy
|
|
yy
|
|
yy
|
|
yy
|
|
zz
|
|
select cvchar3 from datatypetestm where cvchar3 is not null order by 1;
|
|
cvchar3
|
|
aaa
|
|
c
|
|
cc
|
|
ccc
|
|
ccc
|
|
xxx
|
|
xxx
|
|
xxx
|
|
xxx
|
|
zzz
|
|
select cvchar4 from datatypetestm where cvchar4 is not null order by 1;
|
|
cvchar4
|
|
aaaa
|
|
d
|
|
dd
|
|
ddd
|
|
dddd
|
|
wwww
|
|
wwww
|
|
wwww
|
|
wwww
|
|
zzzz
|
|
select cvchar5 from datatypetestm where cvchar5 is not null order by 1;
|
|
cvchar5
|
|
aaaaa
|
|
e
|
|
ee
|
|
eee
|
|
eeee
|
|
vvvvv
|
|
vvvvv
|
|
vvvvv
|
|
vvvvv
|
|
zzzzz
|
|
select cvchar6 from datatypetestm where cvchar6 is not null order by 1;
|
|
cvchar6
|
|
aaaaaa
|
|
f
|
|
ff
|
|
fff
|
|
ffff
|
|
uuuuuu
|
|
uuuuuu
|
|
uuuuuu
|
|
uuuuuu
|
|
zzzzzz
|
|
select cvchar7 from datatypetestm where cvchar7 is not null order by 1;
|
|
cvchar7
|
|
aaaaaaa
|
|
g
|
|
gg
|
|
ggg
|
|
gggg
|
|
ttttttt
|
|
ttttttt
|
|
ttttttt
|
|
ttttttt
|
|
zzzzzzz
|
|
select cvchar8 from datatypetestm where cvchar8 is not null order by 1;
|
|
cvchar8
|
|
aaaaaaaa
|
|
h
|
|
hh
|
|
hhh
|
|
hhhh
|
|
sssssss
|
|
ssssssss
|
|
ssssssss
|
|
ssssssss
|
|
zzzzzzzz
|
|
select cvchar255 from datatypetestm where cvchar255 is not null order by 1;
|
|
cvchar255
|
|
aaaaaaaaaa
|
|
j
|
|
jj
|
|
jjj
|
|
jjjj
|
|
qqqqqqq
|
|
qqqqqqqq
|
|
qqqqqqqqq
|
|
qqqqqqqqqq
|
|
zzzzzzzzzz
|