1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-26 11:48:52 +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

10 lines
414 B
Plaintext

USE tpch1;
select * from sub1 LEFT OUTER JOIN (select * from sub2) Meal on(sub1.c1=Meal.c1 and sub1.c2=Meal.c2) order by 1;
c1 c2 c3 s1 s2 s3 c1 c2 c3 s1 s2 s3
1 1 1 1 1 1 1 1 1 1 1 1
2 2 2 2 2 2 NULL NULL NULL NULL NULL NULL
3 3 3 3 3 3 NULL NULL NULL NULL NULL NULL
4 1 1 1 1 1 NULL NULL NULL NULL NULL NULL
5 99 99 99 99 99 NULL NULL NULL NULL NULL NULL
6 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL