ABORT THROWN BY INTERNAL EXCEPTION: Logical column index 8 out of range

[fuzzerofducks]

Issue found by SQLSmith on git commit hash 56366 using seed 303797190.

To Reproduce

call dbgen(sf=0.1);
SELECT (SELECT ps_partkey FROM main.partsupp LIMIT 1 OFFSET 1) AS c15, ref_15.s_name AS c16, (SELECT s_phone FROM main.supplier LIMIT 1 OFFSET 21) AS c17, ref_1.s_acctbal AS c18 FROM main.supplier AS ref_0 INNER JOIN main.supplier AS ref_1 INNER JOIN main.customer AS ref_2 ON ((ref_1.s_suppkey = ref_2.c_custkey)) ON (((ref_0.s_comment IS NULL) OR (ref_2.c_address ~~ ref_0.s_comment))) RIGHT JOIN main.orders AS ref_3 LEFT JOIN main.part AS ref_4 ON ((ref_3.o_shippriority = ref_4.p_partkey)) RIGHT JOIN main.part AS ref_5 ON ((ref_5.p_type ^@ ref_5.p_comment)) RIGHT JOIN main.orders AS ref_6 ON (((ref_5.p_comment !~~* ref_3.o_orderpriority) OR ((ref_4.p_container IS NOT NULL) AND (CAST(NULL AS VARCHAR) ~~ ref_5.p_mfgr)))) INNER JOIN (SELECT subq_1.c1 AS c0 FROM main.orders AS ref_7 , (SELECT subq_0.c6 AS c0, ref_7.o_clerk AS c1, ref_8.r_name AS c2, subq_0.c1 AS c3, subq_0.c2 AS c4 FROM main.region AS ref_8 , (SELECT ref_9.o_orderstatus AS c0, ref_8.r_name AS c1, ref_8.r_regionkey AS c2, ref_8.r_regionkey AS c3, ref_8.r_comment AS c4, ref_8.r_name AS c5, ref_8.r_comment AS c6, ref_8.r_name AS c7 FROM main.orders AS ref_9 WHERE (ref_9.o_orderpriority !~~* ref_9.o_comment)) AS subq_0 WHERE (0 AND ((SELECT o_orderstatus FROM main.orders LIMIT 1 OFFSET 2) !~~ ref_7.o_clerk)) LIMIT 100) AS subq_1 WHERE (ref_7.o_orderpriority IS NULL) LIMIT 160) AS subq_2 ON ((ref_6.o_orderdate IS NOT NULL)) ON ((ref_4.p_container ~~ ref_4.p_mfgr)) RIGHT JOIN main.region AS ref_10 RIGHT JOIN main.customer AS ref_11 ON ((ref_11.c_address ~~~ ref_11.c_comment)) INNER JOIN main.nation AS ref_12 ON ((ref_11.c_address ^@ ref_10.r_comment)) RIGHT JOIN main.partsupp AS ref_13 ON (((SELECT s_name FROM main.supplier LIMIT 1 OFFSET 3) ~~* ref_11.c_phone)) RIGHT JOIN main.lineitem AS ref_14 INNER JOIN main.supplier AS ref_15 ON ((ref_15.s_nationkey IS NOT NULL)) LEFT JOIN main.nation AS ref_16 ON (1) INNER JOIN main.supplier AS ref_17 RIGHT JOIN main.lineitem AS ref_18 INNER JOIN main.nation AS ref_19 ON ((((SELECT o_orderkey FROM main.orders LIMIT 1 OFFSET 5) IS NOT NULL) AND (ref_18.l_returnflag !~~* (SELECT n_name FROM main.nation LIMIT 1 OFFSET 1)) AND (ref_18.l_partkey IS NULL))) ON ((ref_17.s_phone = ref_19.n_name)) ON ((ref_15.s_name = ref_18.l_returnflag)) ON ((ref_15.s_suppkey IS NOT NULL)) ON (1) RIGHT JOIN (SELECT subq_3.c1 AS c0, subq_3.c4 AS c1, subq_3.c2 AS c2, subq_3.c10 AS c3, (SELECT ps_suppkey FROM main.partsupp LIMIT 1 OFFSET 4) AS c4, subq_3.c1 AS c5 FROM (SELECT ref_20.s_acctbal AS c0, ref_20.s_name AS c1, ref_20.s_suppkey AS c2, ref_20.s_nationkey AS c3, ref_20.s_suppkey AS c4, ref_20.s_comment AS c5, ref_20.s_name AS c6, 82 AS c7, ref_20.s_suppkey AS c8, ref_20.s_acctbal AS c9, ref_20.s_phone AS c10 FROM main.supplier AS ref_20 WHERE (ref_20.s_comment !~~* ref_20.s_address)) AS subq_3 WHERE ((SELECT r_name FROM main.region LIMIT 1 OFFSET 2) ^@ subq_3.c10) LIMIT 40) AS subq_4 ON ((((ref_4.p_container ~~ ref_14.l_shipmode) AND (ref_5.p_name ^@ (SELECT p_name FROM main.part LIMIT 1 OFFSET 2)) AND (ref_10.r_name !~~ ref_6.o_comment)) OR ((CAST(NULL AS VARCHAR) !~~ ref_0.s_phone) AND (ref_1.s_address ~~ ref_4.p_comment)) OR (ref_18.l_shipinstruct ~~~ ref_5.p_brand))) WHERE (ref_1.s_phone ~~ CASE  WHEN ((subq_4.c4 IS NULL)) THEN (ref_17.s_address) ELSE ref_17.s_address END) LIMIT 108

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Logical column index 8 out of range