-
-
Notifications
You must be signed in to change notification settings - Fork 579
Open
Labels
analyzerbugSomething isn't workingSomething isn't workingcorrectnessWe don't return the same result as MySQLWe don't return the same result as MySQLcustomer issuesqlIssue with SQLIssue with SQL
Description
CREATE TABLE t1(c0 VARCHAR(500) , c1 INT , c2 BOOLEAN);
CREATE TABLE t2(c0 INT , c1 VARCHAR(500) , c2 BOOLEAN);
CREATE TABLE t3(c0 VARCHAR(500) , c1 INT);
INSERT INTO t1 VALUES ('UjhU', 9, TRUE);
INSERT INTO t2 VALUES (5, 'ao', TRUE);
INSERT INTO t3 VALUES ('4GD', 6, TRUE);
SELECT
t2.c0, t2.c1, t2.c2
FROM
t2 FULL OUTER JOIN t3 ON LEFT(t2.c1, 2) = t2.c1
CROSS JOIN (SELECT t1.c0 AS c0 FROM t1) AS vtable0;
+------+------+------+
| c0 | c1 | c2 |
+------+------+------+
| ao | 1 | NULL |
+------+------+------+
1 row in set (0.00 sec)
Dolt version: 1.59.4
mysql> select dolt_version();
+----------------+
| dolt_version() |
+----------------+
| 1.59.4 |
+----------------+
1 row in set (0.00 sec)
OS: Linux (x86)
Metadata
Metadata
Assignees
Labels
analyzerbugSomething isn't workingSomething isn't workingcorrectnessWe don't return the same result as MySQLWe don't return the same result as MySQLcustomer issuesqlIssue with SQLIssue with SQL