|
Build tested: 1.4.2-1 (first combined build from Azura)
OS: centos 7
Stack: single server
Autopilot.features.outerJoin test case failed, returned incorrect result. The same test case passed in 1.4.1-1. The following is a simplified version of the test case
Table rows:
MariaDB [ojref]> select * from nation
-> ;
------------
| n_nationkey |
n_name |
n_regionkey |
n_comment |
------------
| -1 |
ARGENTINA |
-100 |
al foxes promise slyly according to the regular accounts. bold requests alon |
| -2 |
BRAZIL |
-100 |
y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special |
| -3 |
CANADA |
-100 |
eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold |
| NULL |
ARGENTINA |
NULL |
al foxes promise slyly according to the regular accounts. bold requests alon |
| NULL |
BRAZIL |
NULL |
y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special |
| NULL |
CANADA |
NULL |
eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold |
------------
6 rows in set (0.001 sec)
MariaDB [ojref]> select * from region;
------------
| r_regionkey |
r_name |
r_comment |
------------
| -1 |
AMERICA |
hs use ironic, even requests. s |
| -2 |
ASIA |
ges. thinly even pinto beans ca |
| NULL |
AMERICA |
hs use ironic, even requests. s |
| NULL |
ASIA |
ges. thinly even pinto beans ca |
------------
4 rows in set (0.001 sec)
ColumnStore tables returned two rows:
MariaDB [ojtest]> select r.* from region r where not exists (select null from nation n where n.n_regionkey = r.r_regionkey) order by 1, 2, 3
-> ;
------------
| r_regionkey |
r_name |
r_comment |
------------
| -2 |
ASIA |
ges. thinly even pinto beans ca |
| -1 |
AMERICA |
hs use ironic, even requests. s |
------------
2 rows in set (0.032 sec)
InnoDB tables returned 4 rows:
MariaDB [ojref]> select r.* from region r where not exists (select null from nation n where n.n_regionkey = r.r_regionkey) order by 1, 2, 3
-> ;
------------
| r_regionkey |
r_name |
r_comment |
------------
| NULL |
AMERICA |
hs use ironic, even requests. s |
| NULL |
ASIA |
ges. thinly even pinto beans ca |
| -2 |
ASIA |
ges. thinly even pinto beans ca |
| -1 |
AMERICA |
hs use ironic, even requests. s |
------------
4 rows in set (0.001 sec)
|