Incorrect output for LEFT JOINS with integer-valued filter.

[nicktobey]

In MySQL, booleans are actually tinyints, true and false are aliases for 1 and 0, respectively, and all non-zero integers are "truthy".

As a result, the three select queries below are all equivalent.

create table a (aa int);
insert into a values (1), (2);

create table b (bb int);
insert into b values (1), (2);

select * from a join b on true;
select * from a join b on 1;
select * from a join b on 2;

MySql output:

aa	bb
2	1
1	1
2	2
1	2
aa	bb
2	1
1	1
2	2
1	2
aa	bb
2	1
1	1
2	2
1	2

However, running the same query in Dolt produces:

+----+----+
| aa | bb |
+----+----+
| 2  | 2  |
| 1  | 2  |
| 2  | 1  |
| 1  | 1  |
+----+----+
+-------+----+
| aa    | bb |
+-------+----+
| NULL  | 2  |
| NULL  | 1  |
+-------+----+
+-------+----+
| aa    | bb |
+-------+----+
| NULL  | 2  |
| NULL  | 1  |
+-------+----+

Curiously, this only effects left/right joins. Inner joins in Dolt behave the same as MySQL.