ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [47.5] (bindings: {#[1.0], #[1.1], #[1.2], #[1.3], #[1.4], #[15.0], #[15.1], #[14.0], #[14.1], #[14.2], #[78.0], #[82.0], #[84.0], #[86.0]})

[fuzzerofducks]

Issue found by SQLSmith on git commit hash 50bb6 using seed 5964281.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT (SELECT NULL) AS c0, ref_1.int_array AS c1 FROM (SELECT ref_0.nested_int_array AS c0, ref_0.uuid AS c1, (SELECT "timestamp" FROM main.all_types LIMIT 1 OFFSET 1) AS c2, ref_0.fixed_nested_int_array AS c3, ref_0."time" AS c4 FROM main.all_types AS ref_0 WHERE (ref_0."varchar" ~~ CAST(NULL AS VARCHAR)) LIMIT 72) AS subq_0 INNER JOIN main.all_types AS ref_1 RIGHT JOIN main.all_types AS ref_2 ON ((ref_1.fixed_int_array IS NULL)) ON (((ref_2."varchar" ^@ ref_2."varchar") OR ((ref_2.ubigint IS NULL) AND 1))) INNER JOIN main.all_types AS ref_3 LEFT JOIN (SELECT 76 AS c0, ref_5."varchar" AS c1, ref_5.timestamp_tz AS c2, ref_4.blob AS c3, ref_5."double" AS c4, ref_4.blob AS c5, ref_4."double" AS c6, ref_5.double_array AS c7 FROM main.all_types AS ref_4 INNER JOIN main.all_types AS ref_5 ON (((ref_4."varchar" ~~* ref_5."varchar") OR 1)) WHERE ((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 5) !~~ ref_5."varchar") LIMIT 9) AS subq_1 INNER JOIN main.all_types AS ref_6 ON ((ref_6."varchar" ~~~ subq_1.c1)) ON ((ref_3."varchar" ~~ subq_1.c1)) ON ((ref_2."varchar" !~~* ref_1."varchar")) WHERE ((SELECT NULL) AND EXISTS(SELECT 27 AS c0, 32 AS c1, ref_6.dec38_10 AS c2, NULL, ref_1.fixed_int_array AS c4 WHERE 0) AND CASE  WHEN (1) THEN ((SELECT NULL FROM main.all_types LIMIT 1 OFFSET 3)) ELSE (SELECT NULL) END) LIMIT 113

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [47.5] (bindings: {#[1.0], #[1.1], #[1.2], #[1.3], #[1.4], #[15.0], #[15.1], #[14.0], #[14.1], #[14.2], #[78.0], #[82.0], #[84.0], #[86.0]})