1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-23 07:05:36 +03:00
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

13 lines
1.2 KiB
Plaintext

USE tpch1;
select *
from lineitem
where l_orderkey in (1248, 315118979, 315119076, 315119136, 315119777, 315119878, 120957670, 235282085, 341482786, 426406758, 521332416, 578786432, 599692096)
order by l_orderkey, l_linenumber;
l_orderkey l_partkey l_suppkey l_linenumber l_quantity l_extendedprice l_discount l_tax l_returnflag l_linestatus l_shipdate l_commitdate l_receiptdate l_shipinstruct l_shipmode l_comment
1248 163061 3062 1 45.00 50582.70 0.00 0.08 A F 1992-04-17 1992-03-31 1992-05-13 NONE RAIL ter the pending pl
1248 150275 2791 2 37.00 49034.99 0.06 0.06 R F 1992-01-26 1992-02-05 1992-02-13 COLLECT COD TRUCK . final requests integrate quickly. blit
1248 55368 2884 3 26.00 34407.36 0.09 0.06 A F 1992-01-16 1992-03-01 1992-02-06 TAKE BACK RETURN AIR ironic dependen
1248 155169 5170 4 49.00 59983.84 0.02 0.01 A F 1992-04-24 1992-02-18 1992-05-03 TAKE BACK RETURN AIR beans run quickly according to the carefu
1248 121465 3978 5 20.00 29729.20 0.08 0.00 A F 1992-03-12 1992-03-23 1992-04-07 TAKE BACK RETURN AIR nal foxes cajole carefully slyl
1248 61457 6470 6 30.00 42553.50 0.10 0.01 R F 1992-02-01 1992-03-24 1992-02-08 TAKE BACK RETURN MAIL fily special foxes kindle am