Skip to content

Data Scrambling with FULL OUTER JOIN and CROSS JOIN #9805

@momoway

Description

@momoway
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

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions