Wrong full join result
(1) By Zhaokun Xiang (silva9988) on 2025-05-31 12:16:16 [source]
Dear SQLite Developers,
I meet a wrong result. Please see the below cases. I can reproduce it on the version SQLite version SQLite version 3.50.0 and the latest Check-in [7d884386be].
CREATE TABLE t0(c0, c1, c2);
CREATE TABLE t1 (c0);
CREATE VIRTUAL TABLE t2 USING rtree(c0, c1, c2);
CREATE TABLE v0(c0);
INSERT INTO t2(c0) VALUES ('');
INSERT INTO t1 VALUES ('0.0');
SELECT t1.c0, v0.* FROM t2 NATURAL LEFT JOIN t0 NATURAL JOIN t1 FULL JOIN v0 ON 1;
-- empty result
-- expected result: 0.0, NULL
(2.1) By Zhaokun Xiang (silva9988) on 2025-06-04 04:59:11 edited from 2.0 in reply to 1 [link] [source]
I see you have fixed it on the check-in 8d393ca07f. Here I want to express my gratitude to your efforts in fixing! Thanks for your fixing!