DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
key UInt32,
a UInt32,
attr String
) ENGINE = MergeTree ORDER BY key;
INSERT INTO t1 (key, a, attr) VALUES (1, 10, 'alpha'), (2, 15, 'beta'), (3, 20, 'gamma');
SET enable_analyzer=1;
set parallel_replicas_local_plan=0;
set enable_parallel_replicas=1;
SELECT * FROM t1 RIGHT JOIN (SELECT * FROM VALUES('key UInt64, a UInt64', (0, 10), (1, 100), (2, 1000))) t3 ON t1.key=t3.key ORDER BY ALL;
0 0 0 10
0 0 0 10
0 0 0 10
0 0 1 100
0 0 1 100
0 0 2 1000
0 0 2 1000
1 10 alpha 1 100
2 15 beta 2 1000
0 0 0 10
1 10 alpha 1 100
2 15 beta 2 1000
03006_join_on_inequal_expression_3.sql.j2
Reproduced only with RIGHT JOIN and parallel_replicas_local_plan=0;
Result:
Expected:
Affected tests:
Version: 25.1.1.1921