You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +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>
479 lines
5.6 KiB
Plaintext
479 lines
5.6 KiB
Plaintext
USE tpch1;
|
|
select c_custkey, o_orderkey from orders right outer join customer on c_custkey = o_custkey where c_custkey < 1000 and c_nationkey = 4 order by 1, 2;
|
|
c_custkey o_orderkey
|
|
4 164711
|
|
4 385825
|
|
4 1192231
|
|
4 1226497
|
|
4 1590469
|
|
4 1755398
|
|
4 1944711
|
|
4 1953441
|
|
4 1978756
|
|
4 2459619
|
|
4 2765152
|
|
4 2986913
|
|
4 3251169
|
|
4 3421092
|
|
4 3683623
|
|
4 3951331
|
|
4 4320612
|
|
4 4960614
|
|
4 5453440
|
|
4 5612065
|
|
54 NULL
|
|
74 14656
|
|
74 849312
|
|
74 1362726
|
|
74 1458755
|
|
74 1733158
|
|
74 2942945
|
|
74 3084997
|
|
74 3217060
|
|
74 3498530
|
|
74 4529089
|
|
74 4906690
|
|
74 5745185
|
|
74 5982466
|
|
128 484198
|
|
128 527621
|
|
128 1396804
|
|
128 3152870
|
|
128 4713092
|
|
128 5108934
|
|
128 5218630
|
|
128 5788550
|
|
128 5921799
|
|
132 NULL
|
|
140 2096870
|
|
140 2230400
|
|
140 2242595
|
|
140 2352160
|
|
140 2631298
|
|
140 5046725
|
|
164 236545
|
|
164 1303399
|
|
164 1624417
|
|
164 1984643
|
|
164 2065794
|
|
164 2669571
|
|
164 3001284
|
|
164 3002851
|
|
164 3741927
|
|
164 5177123
|
|
164 5254976
|
|
164 5364001
|
|
164 5633600
|
|
179 607969
|
|
179 785413
|
|
179 803750
|
|
179 1254022
|
|
179 3506177
|
|
179 3774563
|
|
179 3903716
|
|
179 3971907
|
|
179 4894465
|
|
179 5146470
|
|
179 5397029
|
|
187 471075
|
|
187 598208
|
|
187 716583
|
|
187 963203
|
|
187 1026757
|
|
187 1352419
|
|
187 2390433
|
|
187 2394657
|
|
187 2640167
|
|
187 3203845
|
|
187 3277601
|
|
187 3560001
|
|
187 4146305
|
|
187 4391943
|
|
187 4476896
|
|
187 4658048
|
|
187 4928672
|
|
187 5023810
|
|
187 5186562
|
|
187 5363457
|
|
187 5375943
|
|
187 5507463
|
|
187 5622276
|
|
199 538209
|
|
199 780164
|
|
199 815394
|
|
199 1116039
|
|
199 1380581
|
|
199 1571812
|
|
199 1868837
|
|
199 2218498
|
|
199 2387846
|
|
199 2499782
|
|
199 2614567
|
|
199 3093761
|
|
199 3327747
|
|
199 3566470
|
|
199 3805092
|
|
199 3981441
|
|
199 4179361
|
|
199 4305924
|
|
199 5010914
|
|
199 5148226
|
|
199 5608871
|
|
199 5613027
|
|
199 5736549
|
|
218 1928771
|
|
218 3112037
|
|
218 3728736
|
|
218 3915233
|
|
218 3945094
|
|
218 4138213
|
|
218 4157798
|
|
218 4646916
|
|
218 4897253
|
|
218 5254048
|
|
262 10688
|
|
262 177731
|
|
262 255302
|
|
262 799905
|
|
262 1296224
|
|
262 1782628
|
|
262 2260993
|
|
262 2539205
|
|
262 2852358
|
|
262 3259651
|
|
262 4127588
|
|
262 4895015
|
|
262 5328737
|
|
262 5403047
|
|
262 5426757
|
|
262 5628997
|
|
287 174340
|
|
287 1008993
|
|
287 1527618
|
|
287 2035399
|
|
287 2522502
|
|
290 3562656
|
|
290 4476741
|
|
290 5103873
|
|
290 5465569
|
|
299 465957
|
|
299 2006624
|
|
299 2181574
|
|
299 2469669
|
|
299 3212006
|
|
299 3216066
|
|
299 4844100
|
|
299 5159622
|
|
299 5614086
|
|
302 320
|
|
302 1726882
|
|
302 2248998
|
|
302 2367015
|
|
302 2575747
|
|
302 2808807
|
|
302 2976391
|
|
302 4438851
|
|
302 4512263
|
|
302 5209862
|
|
334 1177089
|
|
334 1265826
|
|
334 1592836
|
|
334 1935621
|
|
334 1940645
|
|
334 1969476
|
|
334 2169026
|
|
334 2336709
|
|
334 2852003
|
|
334 2906150
|
|
334 4815364
|
|
334 5387267
|
|
334 5958306
|
|
390 NULL
|
|
437 52673
|
|
437 95813
|
|
437 225506
|
|
437 443041
|
|
437 1993254
|
|
437 2067526
|
|
437 2848871
|
|
437 3782401
|
|
437 4137703
|
|
437 5240353
|
|
437 5381155
|
|
449 2689828
|
|
449 3042688
|
|
449 3683431
|
|
449 4680737
|
|
449 4802339
|
|
449 5588966
|
|
449 5788544
|
|
458 1848679
|
|
458 3415843
|
|
458 3507074
|
|
458 3692198
|
|
458 4472455
|
|
458 5902209
|
|
471 NULL
|
|
489 NULL
|
|
500 2478403
|
|
500 2539047
|
|
500 2650085
|
|
500 2651397
|
|
500 2709124
|
|
500 3054497
|
|
500 3092290
|
|
500 4008418
|
|
500 4012736
|
|
500 4361062
|
|
500 5760422
|
|
509 129953
|
|
509 645988
|
|
509 1782369
|
|
509 4650278
|
|
509 4791236
|
|
509 4804998
|
|
509 4995205
|
|
509 5009409
|
|
509 5231589
|
|
548 385088
|
|
548 693156
|
|
548 798529
|
|
548 908868
|
|
548 1748519
|
|
548 2332839
|
|
548 3143555
|
|
548 3332194
|
|
548 3626982
|
|
548 3704838
|
|
548 4070917
|
|
548 4079301
|
|
548 4632865
|
|
548 4639265
|
|
548 5905671
|
|
553 687334
|
|
553 1235491
|
|
553 1450662
|
|
553 2042823
|
|
553 2141701
|
|
553 2548485
|
|
553 2739618
|
|
553 3384515
|
|
553 4131717
|
|
553 4464033
|
|
553 4581090
|
|
553 4792067
|
|
553 5159459
|
|
553 5256133
|
|
553 5416455
|
|
553 5598722
|
|
553 5783461
|
|
553 5793153
|
|
553 5997601
|
|
564 NULL
|
|
565 13031
|
|
565 603587
|
|
565 902660
|
|
565 935237
|
|
565 1472644
|
|
565 2031783
|
|
565 2042721
|
|
565 2138466
|
|
565 2154723
|
|
565 2165280
|
|
565 2268480
|
|
565 2650371
|
|
565 2738087
|
|
565 3011554
|
|
565 3548386
|
|
565 4101219
|
|
565 4311267
|
|
565 4460483
|
|
565 4705958
|
|
565 4989703
|
|
565 5181796
|
|
565 5515460
|
|
565 5620547
|
|
565 5851110
|
|
573 NULL
|
|
599 50592
|
|
599 1062400
|
|
599 1164225
|
|
599 1584352
|
|
599 1928480
|
|
599 1996133
|
|
599 2515619
|
|
599 2788704
|
|
599 3570759
|
|
599 4180837
|
|
599 4951558
|
|
599 5347680
|
|
613 126468
|
|
613 632994
|
|
613 1003269
|
|
613 1313286
|
|
613 1607047
|
|
613 1996928
|
|
613 2035329
|
|
613 2106243
|
|
613 2373799
|
|
613 2944419
|
|
613 2988322
|
|
613 3051171
|
|
613 3152481
|
|
613 3352229
|
|
613 3446690
|
|
613 4232421
|
|
613 5080771
|
|
613 5093249
|
|
613 5174341
|
|
613 5249507
|
|
613 5272642
|
|
613 5494340
|
|
624 NULL
|
|
661 178561
|
|
661 435620
|
|
661 1001284
|
|
661 1020998
|
|
661 1439650
|
|
661 2110886
|
|
661 2376097
|
|
661 2825380
|
|
661 3067748
|
|
661 3139015
|
|
661 3278756
|
|
661 3784608
|
|
661 4199175
|
|
661 4533504
|
|
661 4556801
|
|
661 5138433
|
|
661 5481249
|
|
661 5876516
|
|
673 379109
|
|
673 1107138
|
|
673 1400354
|
|
673 2085121
|
|
673 2699713
|
|
673 3046018
|
|
673 3543105
|
|
673 3626535
|
|
673 3737701
|
|
673 4241154
|
|
673 4393255
|
|
673 4411812
|
|
673 5283617
|
|
673 5761122
|
|
673 5877475
|
|
697 313792
|
|
697 373094
|
|
697 614663
|
|
697 666241
|
|
697 738055
|
|
697 1566727
|
|
697 2034528
|
|
697 2856417
|
|
697 2973091
|
|
697 3433920
|
|
697 3511106
|
|
697 4153248
|
|
697 4505506
|
|
697 4862786
|
|
699 NULL
|
|
798 NULL
|
|
820 40387
|
|
820 126339
|
|
820 185030
|
|
820 281156
|
|
820 953632
|
|
820 1003174
|
|
820 1296321
|
|
820 1335430
|
|
820 1384103
|
|
820 1423043
|
|
820 1508390
|
|
820 1560032
|
|
820 1598082
|
|
820 1673923
|
|
820 1834977
|
|
820 2115909
|
|
820 2172228
|
|
820 2373698
|
|
820 2473284
|
|
820 2826341
|
|
820 3135873
|
|
820 3198215
|
|
820 3417795
|
|
820 4121252
|
|
820 4171622
|
|
820 4294407
|
|
820 4631111
|
|
820 4815175
|
|
820 5527684
|
|
820 5637541
|
|
820 5820772
|
|
820 5888514
|
|
881 56775
|
|
881 80324
|
|
881 210119
|
|
881 388769
|
|
881 1417186
|
|
881 2381543
|
|
881 2834916
|
|
881 3151107
|
|
881 3265697
|
|
881 3409827
|
|
881 3449472
|
|
881 3634048
|
|
881 4205895
|
|
881 4705569
|
|
881 5003399
|
|
881 5016992
|
|
881 5400578
|
|
890 834567
|
|
890 965508
|
|
890 1399585
|
|
890 1604453
|
|
890 1703201
|
|
890 3286244
|
|
890 4175202
|
|
890 5674084
|
|
902 245281
|
|
902 1650304
|
|
902 1681476
|
|
902 2299907
|
|
902 3147079
|
|
902 3697731
|
|
902 3801028
|
|
902 4285319
|
|
902 4313383
|
|
902 4551719
|
|
902 5290434
|
|
944 1015847
|
|
944 1561218
|
|
944 1840643
|
|
944 2964711
|
|
944 4072773
|
|
944 4871808
|
|
944 5208421
|
|
944 5510819
|
|
959 496770
|
|
959 958916
|
|
959 1062976
|
|
959 1939744
|
|
959 2211936
|
|
959 2335553
|
|
959 4344576
|
|
959 5504133
|
|
960 NULL
|
|
962 640197
|
|
962 765156
|
|
962 1191330
|
|
962 2786180
|
|
962 2792485
|
|
962 2793763
|
|
962 3511046
|
|
962 3672260
|
|
962 5383365
|
|
962 5465830
|
|
962 5873536
|
|
972 NULL
|