INTERNAL Error: Positional reference expression could not be bound #4303
Description
Issue found by DuckFuzz on git commit hash e93d3 using seed 115818634.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
PRAGMA enable_verification;
SELECT #5 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE c22 ORDER BY * DESC;
WITH t108 (c105, c106, c107) AS (SELECT c15, c47, 844, (c60 NOT IN (c35, c8, c46)), c65, c45, c29 FROM (VALUES (7810, 7122, 3959, [], '79a885dd-b68e-4a11-87be-21f0e9b7fb8a', 'bbd9c2aa-becb-4f89-ac07-fb7cd1a10fa3', '0fe92956-d2c6-4ed8-87a4-cf0dcfa61b09', '00400bdf-3d56-4d89-931d-a0ba09a34979', 170141183460469231731687303715884105727), (65535, '4c24ca78-6bf7-4b8c-b4e1-c9f9e248b925', [], '42c4e0e4-8b31-4dfc-98a3-b586c6156093', [{'a': NULL, 'b': NULL}, {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, NULL], 'c74e9e1e-94ff-4d2d-aeb2-97622a99936c', 'd7844d22-4418-4263-8870-c1620217f8ac', -2147483648, 1068), (1398, 65535, NULL, '5f4f5306-fcd7-4a46-ad73-2f2c141cd1cc', NULL, 8648, 6800, NULL, 2728), (5062, 6790, [], {'a': NULL, 'b': NULL}, '657b806c-4e1a-44a8-9567-cb200efbbd24', 3561, NULL, -128, '549d3966-5dd9-47d6-aab3-1fe270d18ea3'), ([42, 999, NULL, NULL, -42], 5260, 'da5bf3ad-78de-4b0d-9158-79f05dd1e1e1', NULL, 4353, 1015, 'ea6de08f-8917-472e-913e-9c668c22799e', [['d', 'e', 'f'], ['a', NULL, 'c'], ['d', 'e', 'f']], 'a14079bb-e59d-47c1-a222-a12d738f0f78')) SEMI JOIN all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) NATURAL FULL JOIN all_types AS t104(c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103) ON (c11) WHERE * ORDER BY * NULLS FIRST), t580 (c579) AS (SELECT DISTINCT c373, list_stddev_pop(8769), ('00:00:00+15:59:59'::TIME WITH TIME ZONE BETWEEN c241 AND ((SELECT c507, (c358 AND c497) FROM all_types AS t526(c475, c476, c477, c478, c479, c480, c481, c482, c483, c484, c485, c486, c487, c488, c489, c490, c491, c492, c493, c494, c495, c496, c497, c498, c499, c500, c501, c502, c503, c504, c505, c506, c507, c508, c509, c510, c511, c512, c513, c514, c515, c516, c517, c518, c519, c520, c521, c522, c523, c524, c525) WHERE rank_dense() OVER (RANGE BETWEEN c508 FOLLOWING AND c88 PRECEDING) GROUP BY TRY_CAST(c504 AS TIME WITH TIME ZONE), c477 ORDER BY t526.* DESC) UNION (SELECT (NOT c550) FROM all_types AS t578(c527, c528, c529, c530, c531, c532, c533, c534, c535, c536, c537, c538, c539, c540, c541, c542, c543, c544, c545, c546, c547, c548, c549, c550, c551, c552, c553, c554, c555, c556, c557, c558, c559, c560, c561, c562, c563, c564, c565, c566, c567, c568, c569, c570, c571, c572, c573, c574, c575, c576, c577) WHERE c551 ORDER BY *) ORDER BY * NULLS LAST)) FROM (((SELECT DISTINCT 9411, c115, c128 FROM all_types AS t160(c109, c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159) QUALIFY * ORDER BY * NULLS FIRST) EXCEPT (SELECT c153, c172, c106 FROM all_types AS t212(c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210, c211) WHERE NULL GROUP BY ALL ORDER BY * DESC) ORDER BY * NULLS FIRST) INTERSECT ((((SELECT c134, (c70 BETWEEN 0010001001011100010101011010111 AND c257), ((c222 != c261) OR cume_dist() OVER (PARTITION BY c191, enum_code((239 BETWEEN c105 AND c205)), c125 ORDER BY c245 NULLS FIRST ROWS BETWEEN CURRENT ROW AND c206 PRECEDING)), c113, *, (c16 OR 4121), to_hours(c183), (list_median(c218) IS NULL), c178 FROM all_types AS t264(c213, c214, c215, c216, c217, c218, c219, c220, c221, c222, c223, c224, c225, c226, c227, c228, c229, c230, c231, c232, c233, c234, c235, c236, c237, c238, c239, c240, c241, c242, c243, c244, c245, c246, c247, c248, c249, c250, c251, c252, c253, c254, c255, c256, c257, c258, c259, c260, c261, c262, c263) WHERE ('290309-12-22 (BC) 00:00:00'::TIMESTAMP_S BETWEEN c154 AND NULL) ORDER BY * DESC NULLS FIRST) EXCEPT (SELECT c62, 9021, c254, (inet_client_port() BETWEEN c304 AND NULL), c166 FROM (SELECT c292, c193, * FROM (VALUES (216), (9478), (8520)) INNER JOIN (VALUES (4434, 2873, 'ababf2f7-0800-4a0f-8f9a-89e6ddfcf455'), (NULL, 3251, 4800), (8831, 0, 18446744073709551615)) ON (*) SEMI JOIN all_types AS t316(c265, c266, c267, c268, c269, c270, c271, c272, c273, c274, c275, c276, c277, c278, c279, c280, c281, c282, c283, c284, c285, c286, c287, c288, c289, c290, c291, c292, c293, c294, c295, c296, c297, c298, c299, c300, c301, c302, c303, c304, c305, c306, c307, c308, c309, c310, c311, c312, c313, c314, c315) ON (c276) ORDER BY * NULLS LAST) AS t317 SEMI JOIN all_types AS t369(c318, c319, c320, c321, c322, c323, c324, c325, c326, c327, c328, c329, c330, c331, c332, c333, c334, c335, c336, c337, c338, c339, c340, c341, c342, c343, c344, c345, c346, c347, c348, c349, c350, c351, c352, c353, c354, c355, c356, c357, c358, c359, c360, c361, c362, c363, c364, c365, c366, c367, c368) PIVOT (list_contains(c56, c234) FOR (c274) IN ([4, 5, 6]) GROUP BY c279, c354, c226, c198) ON (c229) WHERE last_value(c221) OVER (ROWS BETWEEN c112 FOLLOWING AND CURRENT ROW) GROUP BY ALL USING SAMPLE 58% (System) ORDER BY t160.* DESC) ORDER BY * DESC) INTERSECT (SELECT [[42, 999, NULL, NULL, -42], [], [42, 999, NULL, NULL, -42]], c411, c398, c265 FROM all_types AS t421(c370, c371, c372, c373, c374, c375, c376, c377, c378, c379, c380, c381, c382, c383, c384, c385, c386, c387, c388, c389, c390, c391, c392, c393, c394, c395, c396, c397, c398, c399, c400, c401, c402, c403, c404, c405, c406, c407, c408, c409, c410, c411, c412, c413, c414, c415, c416, c417, c418, c419, c420) WHERE #6 GROUP BY c272 HAVING c412 ORDER BY * NULLS FIRST) ORDER BY * NULLS FIRST) UNION (SELECT c194, #6, c360, c126, *, #10 FROM all_types AS t473(c422, c423, c424, c425, c426, c427, c428, c429, c430, c431, c432, c433, c434, c435, c436, c437, c438, c439, c440, c441, c442, c443, c444, c445, c446, c447, c448, c449, c450, c451, c452, c453, c454, c455, c456, c457, c458, c459, c460, c461, c462, c463, c464, c465, c466, c467, c468, c469, c470, c471, c472) WHERE c1 GROUP BY GROUPING SETS ((c231),(c366)) QUALIFY percent_rank() OVER (PARTITION BY c37 RANGE BETWEEN c76 PRECEDING AND c186 FOLLOWING) ORDER BY * ASC) ORDER BY * ASC NULLS LAST) ORDER BY *) AS t474 WHERE c138 QUALIFY c291 ORDER BY * ASC NULLS LAST)(SELECT c129, pg_postmaster_start_time(), c229, c220, c309 FROM read_json_auto(232) AS t586(c581, c582, c583, c584, c585) WHERE c407 GROUP BY ALL QUALIFY c398 ORDER BY * DESC NULLS FIRST) UNION BY NAME (SELECT DISTINCT json_array(CAST(c340 AS STRUCT(a INTEGER[], b VARCHAR[])), c699) FROM all_types AS t638(c587, c588, c589, c590, c591, c592, c593, c594, c595, c596, c597, c598, c599, c600, c601, c602, c603, c604, c605, c606, c607, c608, c609, c610, c611, c612, c613, c614, c615, c616, c617, c618, c619, c620, c621, c622, c623, c624, c625, c626, c627, c628, c629, c630, c631, c632, c633, c634, c635, c636, c637) NATURAL ANTI JOIN all_types AS t690(c639, c640, c641, c642, c643, c644, c645, c646, c647, c648, c649, c650, c651, c652, c653, c654, c655, c656, c657, c658, c659, c660, c661, c662, c663, c664, c665, c666, c667, c668, c669, c670, c671, c672, c673, c674, c675, c676, c677, c678, c679, c680, c681, c682, c683, c684, c685, c686, c687, c688, c689) ASOF RIGHT JOIN all_types AS t742(c691, c692, c693, c694, c695, c696, c697, c698, c699, c700, c701, c702, c703, c704, c705, c706, c707, c708, c709, c710, c711, c712, c713, c714, c715, c716, c717, c718, c719, c720, c721, c722, c723, c724, c725, c726, c727, c728, c729, c730, c731, c732, c733, c734, c735, c736, c737, c738, c739, c740, c741) ON (#3) ASOF INNER JOIN all_types AS t794(c743, c744, c745, c746, c747, c748, c749, c750, c751, c752, c753, c754, c755, c756, c757, c758, c759, c760, c761, c762, c763, c764, c765, c766, c767, c768, c769, c770, c771, c772, c773, c774, c775, c776, c777, c778, c779, c780, c781, c782, c783, c784, c785, c786, c787, c788, c789, c790, c791, c792, c793) ON (c256) WHERE c35 ORDER BY *) ORDER BY t638.* NULLS LAST;
SELECT c46, (SELECT #2, c197, (4755 IS NOT DISTINCT FROM 'b3b1c626-03b0-4c39-975d-79bd42bbbe6f'), c164, c210, *, ((c183 IS DISTINCT FROM 5644) IS NOT DISTINCT FROM c136), TRY_CAST((COALESCE(c208, c162, 340282366920938463463374607431768211455, c196) IS NOT DISTINCT FROM c163) AS STRUCT(a INTEGER, b VARCHAR)[]), c107 FROM all_types AS t211(c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210) WHERE c209 GROUP BY GROUPING SETS ((c174, c194, c194),(c174, c180, c194)) HAVING (c196 != c177[c208:c164]) ORDER BY * DESC NULLS LAST), c70, c130, #5 FROM ((SELECT c16, c34, c11, c46, *, c20, TRY_CAST(c47 AS STRUCT(a INTEGER[3], b VARCHAR[3])) FROM (SELECT (((c31 BETWEEN c25 AND 9862) BETWEEN c47 AND (c49 BETWEEN c43 AND c38)) BETWEEN (6072 IS NOT NULL) AND (ARRAY[])), c20, (c4 NOT IN (((* BETWEEN c18 AND #9) >= c7), '294247-01-10 04:00:54.775806'::TIMESTAMP, c9, TRY_CAST('d447f671-85d6-4b22-88f8-f848f9772252' AS VARCHAR[3][3]), c46, 1789, 'f75051f4-d17f-4a90-9698-4b5dfe51a446')), 4771 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) ORDER BY * ASC) AS t53 ORDER BY * NULLS FIRST) UNION BY NAME (SELECT DISTINCT c112, c7, c29, 7476, (c40 BETWEEN TRY_CAST(c108 AS UINTEGER) AND c108), c38, c150 FROM all_types AS t105(c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104) ANTI JOIN (SELECT (c142 < c140), c147 FROM all_types AS t157(c106, c107, c108, c109, c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156) WHERE c134 GROUP BY ntile(c120) OVER (RANGE BETWEEN 187 FOLLOWING AND '8e7cff0d-e46c-4030-934c-73351e2c1fed' FOLLOWING) HAVING NULL ORDER BY *) AS t158 USING (c4, c69, c17, c123) WHERE TRY_CAST((c89 > -1.7976931348623157e+308) AS STRUCT(a INTEGER[], b VARCHAR[])) ORDER BY * ASC) ORDER BY * DESC NULLS FIRST) AS t159 ORDER BY * DESC NULLS LAST;
(WITH t475 (c473, c474) AS ((SELECT c5, (c43 <= c29), c1 FROM (SELECT NULL, c45, (6740 IS DISTINCT FROM c20), (c45 IN (c6, #9, c43, (c3 < ANY(SELECT c64, *, * FROM all_types AS t104(c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103) WHERE c100 HAVING c74 ORDER BY * NULLS LAST)), c35, c29)) FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE 6431 ORDER BY * ASC) AS t105 GROUP BY ALL ORDER BY *) EXCEPT ((WITH t212 (c211) AS (SELECT DISTINCT (CAST((EXISTS(SELECT c185, '6a8775ea-e041-49ca-b1a3-1eb2b283889d', c192, #4, c198, c170, c177, c207[:array_apply(c198, (lambda c210: c176))[c44]], c194 FROM all_types AS t209(c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208) HAVING c173 ORDER BY * DESC NULLS LAST) BETWEEN c45 AND *) AS BIGNUM) AND hamming(c36, (c9 OR c38))), c16, c125, (c148 > (([[42, 999, NULL, NULL, -42], [], [42, 999, NULL, NULL, -42]] IN (c125, 3870, 3664, c128, c15, c5, c108)) AND c107)), 266 FROM all_types AS t157(c106, c107, c108, c109, c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156) ORDER BY * ASC)(SELECT c149, 5847, c28, (32767 IN (#8, 1035, c220, 6884, c150)), c141, TRY_CAST(c131 AS INTEGER[][3]), c18, '49752f07-845e-4aee-85ad-e2ba1b9a4854' FROM all_types AS t264(c213, c214, c215, c216, c217, c218, c219, c220, c221, c222, c223, c224, c225, c226, c227, c228, c229, c230, c231, c232, c233, c234, c235, c236, c237, c238, c239, c240, c241, c242, c243, c244, c245, c246, c247, c248, c249, c250, c251, c252, c253, c254, c255, c256, c257, c258, c259, c260, c261, c262, c263) ORDER BY t264.* NULLS FIRST) UNION (((SELECT c255, c263, rank_dense() OVER (PARTITION BY c22, 3.4028235e+38, c45, #10, c5, c241, epoch_ms(c239) ROWS BETWEEN * FOLLOWING AND ((c19 IS NULL) = 8699) PRECEDING), c28, c15, 'a4801c86-ce59-4f81-9048-0dfca532ad4c', #6, 9022 ORDER BY * DESC NULLS LAST) EXCEPT (SELECT DISTINCT c245, c14, * FROM (VALUES ('89eda8d9-8b5d-4035-87a5-b3aa52d7e2b2', NULL, union_value(name := 'Frank'), 4805), ('c772dd76-3ee4-497a-94f4-bb95b728f695', {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, 7780, 742)) WHERE c262 GROUP BY CAST(c6 AS TIMESTAMP WITH TIME ZONE[]), *, c36 ORDER BY * DESC NULLS LAST) ORDER BY * ASC) INTERSECT (SELECT c39 FROM all_types AS t316(c265, c266, c267, c268, c269, c270, c271, c272, c273, c274, c275, c276, c277, c278, c279, c280, c281, c282, c283, c284, c285, c286, c287, c288, c289, c290, c291, c292, c293, c294, c295, c296, c297, c298, c299, c300, c301, c302, c303, c304, c305, c306, c307, c308, c309, c310, c311, c312, c313, c314, c315) WHERE inet_server_port() USING SAMPLE 99248 (Bernoulli) ORDER BY t105.* DESC NULLS FIRST) ORDER BY * DESC) ORDER BY * DESC NULLS LAST) UNION BY NAME (SELECT c244, c219, c291, (c267 != c416), c398, c150 FROM all_types AS t368(c317, c318, c319, c320, c321, c322, c323, c324, c325, c326, c327, c328, c329, c330, c331, c332, c333, c334, c335, c336, c337, c338, c339, c340, c341, c342, c343, c344, c345, c346, c347, c348, c349, c350, c351, c352, c353, c354, c355, c356, c357, c358, c359, c360, c361, c362, c363, c364, c365, c366, c367) CROSS JOIN (VALUES (513, NULL, 6788, 0, 572, union_value(name := 'Frank'), '9b127160-69fa-4027-819c-f3fc3be0cc59', 3575, NULL), ('09334216-75f8-475c-a7b0-488ea38fd243', '83 years 3 months 999 days 00:16:39.999999'::INTERVAL, false, 5690, NULL, 5240, {'a': NULL, 'b': NULL}, ['1970-01-01 00:00:00'::TIMESTAMP, 'infinity'::TIMESTAMP, '-infinity'::TIMESTAMP, NULL, '2022-05-12 16:23:45'::TIMESTAMP], '1677-09-22 00:00:00'::TIMESTAMP_NS)) FULL JOIN all_types AS t420(c369, c370, c371, c372, c373, c374, c375, c376, c377, c378, c379, c380, c381, c382, c383, c384, c385, c386, c387, c388, c389, c390, c391, c392, c393, c394, c395, c396, c397, c398, c399, c400, c401, c402, c403, c404, c405, c406, c407, c408, c409, c410, c411, c412, c413, c414, c415, c416, c417, c418, c419) LEFT JOIN all_types AS t472(c421, c422, c423, c424, c425, c426, c427, c428, c429, c430, c431, c432, c433, c434, c435, c436, c437, c438, c439, c440, c441, c442, c443, c444, c445, c446, c447, c448, c449, c450, c451, c452, c453, c454, c455, c456, c457, c458, c459, c460, c461, c462, c463, c464, c465, c466, c467, c468, c469, c470, c471) ON (c28) ON (c330) GROUP BY [], c307, (c345 AND TRY_CAST(c470 AS INTEGER[])), c394 HAVING c3 QUALIFY '865f911a-c10a-4fea-9ff9-5e0ffeb411ab' ORDER BY * NULLS FIRST) ORDER BY * ASC) ORDER BY * ASC)SELECT DISTINCT '6aa5f954-2a0a-43e4-857e-c0ead0cdeb4f', lead('f898c791-db2e-47df-83af-1e214416e2b1', TRY_CAST((c139 AND c399) AS TIME WITH TIME ZONE)) OVER (ORDER BY c128 DESC, c460 ASC NULLS LAST ROWS BETWEEN c300 PRECEDING AND CURRENT ROW), c150, c498, TRY_CAST(c154 AS STRUCT(a INTEGER[3], b VARCHAR[3])), c315, c366 FROM all_types AS t527(c476, c477, c478, c479, c480, c481, c482, c483, c484, c485, c486, c487, c488, c489, c490, c491, c492, c493, c494, c495, c496, c497, c498, c499, c500, c501, c502, c503, c504, c505, c506, c507, c508, c509, c510, c511, c512, c513, c514, c515, c516, c517, c518, c519, c520, c521, c522, c523, c524, c525, c526) WHERE * ORDER BY * NULLS LAST) INTERSECT (SELECT 1617, c50, 1724, '980686de-db48-46ef-9a79-f8615d1e4b8b', (c451 != 5448) FROM read_ndjson_objects(865) AS t530(c528, c529) ORDER BY * DESC NULLS LAST) ORDER BY t264.* NULLS LAST;
SELECT c16, c34, c29, *, c43 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE * GROUP BY c28, c40 ORDER BY * ASC;
CREATE TABLE t1 AS SELECT CAST(c25 AS UBIGINT), (c12 IS NOT DISTINCT FROM c19), c9, c24 FROM all_types AS t53(c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52) WHERE c8 GROUP BY ALL ORDER BY * DESC;
SELECT DISTINCT TRY_CAST(c19 AS BIGNUM), c22, (#8 BETWEEN 3549 AND c50), (c4 AND 0), CAST(c40 AS VARCHAR[3][3]), (c41 BETWEEN c44 AND c19), 3361, #4 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE c7 ORDER BY *;
(SELECT c2, NULL, c3, 7322, c1 FROM t1 AS t5(c1, c2, c3, c4) WHERE TRY_CAST(c2 AS UTINYINT) QUALIFY 5129 ORDER BY t5.* ASC NULLS FIRST) UNION (WITH t135 (c128, c129, c130, c131, c132, c133, c134) AS (WITH t126 (c123, c124, c125) AS (WITH t117 (c115, c116) AS (SELECT c9, c81, #9, c97, c92, (c4 BETWEEN [] AND #2), c3 FROM all_types AS t57(c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56) SEMI JOIN t1 AS t62(c58, c59, c60, c61) USING (c49, c6, c13) SEMI JOIN all_types AS t114(c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, c110, c111, c112, c113) ON (c10) WHERE 1.7976931348623157e+308 GROUP BY c49 HAVING #4 ORDER BY * DESC)SELECT c29, c70, #8, c51, c84, CAST(c70 AS TIME), c87, * FROM t1 AS t122(c118, c119, c120, c121) ORDER BY * NULLS FIRST)SELECT nth_value(c89, *) OVER (ORDER BY 493 ASC NULLS LAST, #1 NULLS LAST RANGE BETWEEN c101 PRECEDING AND 9796 PRECEDING), c95, '2b693a03-9b68-4e45-8d2d-1cbababc78d1', c87, c100, c29, c31 FROM (SELECT c29, '5881580-07-10'::DATE, '578afcdf-5525-4035-8eb1-e295324fa823', *, 4602, c98 FROM (VALUES (4114, '5881580-07-10'::DATE, 2236, 2800, 578, []), (2511, 2342, 8162, 8913, 2962, 2820), (6391, 6477, NULL, 844, 7925, 8251)) WHERE TRY_CAST(c55 AS UTINYINT) QUALIFY 2314 USING SAMPLE 68756 (Bernoulli) ORDER BY * DESC NULLS FIRST) AS t127 HAVING 3489 ORDER BY * DESC NULLS LAST)SELECT DISTINCT (c143 IS NOT NULL), c78, c111, 8218, c76 FROM all_types AS t187(c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186) GROUP BY c9, c160, c148 ORDER BY * NULLS FIRST) ORDER BY * NULLS FIRST;
((((WITH t11 (c6, c7, c8, c9, c10) AS (SELECT c3, c2 FROM t1 AS t5(c1, c2, c3, c4) WHERE '\x00\x00\x00a'::BLOB ORDER BY * DESC)SELECT epoch(struct_indexof((c2 AND (c3 > c1)), c10)), c8, c3, #2, (* AND ntile(c10) OVER (PARTITION BY 1090, [4, 5, 6] RANGE BETWEEN CURRENT ROW AND (c2 BETWEEN c15 AND c2) FOLLOWING)), c8 FROM t1 AS t16(c12, c13, c14, c15) WHERE cume_dist() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND 3884 FOLLOWING) GROUP BY c4, [{'a': NULL, 'b': NULL}, {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, NULL], c14, (c13 = TRY_CAST(c7 AS STRUCT(a INTEGER, b VARCHAR))) ORDER BY * ASC NULLS FIRST) INTERSECT (SELECT c67, '9d3596e6-616b-4b9a-ab67-20536bd0c697', c42, ntile(4375) OVER (PARTITION BY (c60 OR '5881580-07-10'::DATE) RANGE BETWEEN c51 FOLLOWING AND CURRENT ROW), c3, TRY_CAST(c24 AS STRUCT(a INTEGER[], b VARCHAR[])), c45 FROM all_types AS t68(c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67) WHERE COALESCE(c14, 1585) ORDER BY * ASC) ORDER BY * DESC) UNION (SELECT c70, 3675, (SELECT 7892, c74, 5697, rank_dense() OVER (PARTITION BY c76, c75, COALESCE(c74, COALESCE(c75, ((#9 IN (c73, COALESCE(c75, c74, c50[c76], jaro_similarity(c75, ['🦆🦆🦆🦆🦆🦆', 'goose', NULL, '']), c74, array_grade_up((quantile_cont((#2 <= c73), c74) FILTER (WHERE c73) <= #1), c73, c75)), 9217, c74, c75)) BETWEEN c75 AND c75), c76, 4576, c76, c58, TRY_CAST(c73 AS INTEGER[3][3]))) ROWS BETWEEN CURRENT ROW AND (ARRAY[CAST(c74 AS UINTEGER), c74, TRY_CAST(c73 AS BIT), (c75 >= c76), c74, {'a': NULL, 'b': NULL}, c74, '821def8e-5c9f-405c-8dd0-3d8ca4a99c83']) PRECEDING), c73 FROM t1 AS t77(c73, c74, c75, c76) UNPIVOT ((c74, c46, c61, c76) FOR (c73, c74) IN ((274, '2262-04-11 23:47:16.854775806'::TIMESTAMP_NS), (3571, '442d8221-e1ba-47a7-b296-ffafb844770f'), (NULL, 155), ('24:00:00'::TIME, 'cdf782e4-e853-47d8-a233-8bf45b9d5ca7'), (774, ['1970-01-01 00:00:00'::TIMESTAMP, 'infinity'::TIMESTAMP, '-infinity'::TIMESTAMP, NULL, '2022-05-12 16:23:45'::TIMESTAMP]), ([], 6691))) ORDER BY * DESC NULLS LAST), c36, c51 FROM duckdb_settings() AS t72(c69, c70, c71) WHERE (first_value((c70 BETWEEN c55 AND COALESCE((#3 >= (c50 BETWEEN ("*"(c67, 4226) AND 1131) AND c67)), c43, '24:00:00-15:59:59'::TIME WITH TIME ZONE, c66, c57, (c71 IS DISTINCT FROM c43)))) OVER (RANGE BETWEEN 4037 FOLLOWING AND c69 PRECEDING) BETWEEN (NOT c20) AND (gcd([{'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, {'a': NULL, 'b': NULL}, {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}], c30) < 3925)) ORDER BY *) ORDER BY * NULLS FIRST) INTERSECT (SELECT c35, *, NULL, ['1970-01-01 00:00:00'::TIMESTAMP, 'infinity'::TIMESTAMP, '-infinity'::TIMESTAMP, NULL, '2022-05-12 16:23:45'::TIMESTAMP], c51, c45, c39, ((5563 IS NOT DISTINCT FROM c34) AND c42), c67 FROM duckdb_views() AS t81(c78, c79, c80) WHERE cume_dist() OVER (PARTITION BY icu_collate_hsb(c13) RANGE BETWEEN CURRENT ROW AND * PRECEDING) ORDER BY * NULLS FIRST) ORDER BY * ASC NULLS FIRST) EXCEPT ((SELECT 7714, c71 FROM t1 AS t86(c82, c83, c84, c85) WHERE c36 GROUP BY (c38 != 6015), c45 ORDER BY t68.*) INTERSECT (SELECT c17, c51 FROM t1 AS t91(c87, c88, c89, c90) GROUP BY substr(((c82 IS NULL) <= c18), (c27 < c38), c47) ORDER BY * DESC NULLS LAST) ORDER BY * NULLS FIRST) ORDER BY *;
DETACH DATABASE "temp";
SELECT DISTINCT 8422, (2285 IS NULL), 6329, list_element(#8, 4753), 8557 FROM (VALUES ('00:00:00'::INTERVAL, NULL, 9314, 5578, 9233, 9616, 'd2280f70-67fd-4af1-afea-22ae56e37f79', 18446744073709551615), (1328, NULL, 994, -1.7976931348623157e+308, '0b634852-28c5-4493-8988-68d3d1733cf0', [42, 999, NULL, NULL, -42], 999.9, NULL)) QUALIFY row_number() OVER (ORDER BY '663afd90-0a43-4a7c-85f8-d44172a1f1c3' NULLS FIRST, 2967 DESC, '0d6485d8-707a-4014-89c6-28bb91e91dbc' ASC, -99999.9999 DESC NULLS FIRST, 5733 ASC, NULL, 2477 ASC NULLS LAST, NULL DESC, #9, '2d3f2ea5-439b-4685-a394-105d1540052f' DESC NULLS FIRST RANGE BETWEEN '876316aa-495e-4911-be28-d5f2743ef633' PRECEDING AND CURRENT ROW) ORDER BY * DESC NULLS LAST;
((SELECT ('99a299b6-6d08-4d56-a1d7-0afd06863461' BETWEEN c3 AND c4), c3, *, NULL, (NOT c2), c3 FROM t1 AS t5(c1, c2, c3, c4) GROUP BY (c1 = c2), list_prepend(c3, (c1 AND 179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368)), (EXISTS(SELECT DISTINCT '1e410799-02c6-4bc9-9227-716a3e9b2107', c6, * FROM t1 AS t10(c6, c7, c8, c9) GROUP BY ((7414 BETWEEN (ARRAY[8565, c7, ntile(8347) OVER (ROWS BETWEEN c6 PRECEDING AND c1 FOLLOWING), CAST(c7 AS STRUCT(a INTEGER, b VARCHAR))]) AND c6) BETWEEN c4 AND NULL), 865, rank() OVER (ORDER BY c8 DESC RANGE BETWEEN c9 PRECEDING AND CAST({key1=🦆🦆🦆🦆🦆🦆, key2=goose} AS UHUGEINT) PRECEDING), (c2 < c6) ORDER BY *) BETWEEN (SELECT c15, lag(c16, c2) OVER (ROWS BETWEEN c16 FOLLOWING AND (TRY_CAST(c14 AS VARCHAR[]) NOT IN (c12, c17, c16, c16, c16, c17)) FOLLOWING), c15, c12, c15, c14, c15 FROM (SELECT DISTINCT ((c3 AND c15) != c4), c16, c2, #10, c15, c11, c14 FROM json_each(0, -1.7976931348623157e+308) AS t13(c11, c12) POSITIONAL JOIN t1 AS t18(c14, c15, c16, c17) ON (c12) ORDER BY * ASC NULLS FIRST) AS t19 UNPIVOT ((c14, c11) FOR (c4, c3) IN ((1837, true), ('62557d56-94cb-4f52-aa90-ac5a83e8f591', 617), (6704, 9108), ('d4289234-45e2-4363-b683-39319e467e10', '3687cb8e-e638-470e-9d1a-0f3f61a787d8'))) ORDER BY * ASC) AND c1), c3 HAVING c1 ORDER BY * DESC) UNION BY NAME (WITH t31 (c25, c26, c27, c28, c29, c30) AS (SELECT DISTINCT [[42, 999, NULL, NULL, -42], [], [42, 999, NULL, NULL, -42]], c2, c1, (c23 BETWEEN c22 AND 7442) FROM t1 AS t24(c20, c21, c22, c23) UNPIVOT ((c22, c22, c2, c3, c23, c20) FOR c4 IN (NULL) c20 IN (5910)) ORDER BY * ASC NULLS FIRST), t43 (c38, c39, c40, c41, c42) AS (WITH t34 (c32, c33) AS (SELECT c22, c21, 2143, '0447163a-5b5b-4da5-8b92-365468332824', c1, map_contains(octet_length(c28), 8081), c4, c30 FROM (VALUES (1556, 1335), ('c281c808-389b-41eb-b05d-1dba4e148990', 9809)) WHERE 6586 HAVING c30 ORDER BY *)SELECT c4, 'e48c41c5-8518-445d-acfe-07d7152e8e40', #1 FROM read_blob(4333, hive_types := [[], [42, 999, NULL, NULL, -42], NULL, [], [42, 999, NULL, NULL, -42]]) AS t37(c35, c36) WHERE c1 QUALIFY (TRY_CAST([] AS STRUCT(a INTEGER[], b VARCHAR[])) AND c1) ORDER BY * DESC NULLS LAST)SELECT c35 FROM t1 AS t48(c44, c45, c46, c47) WHERE ntile(c38) OVER (ROWS BETWEEN c32 PRECEDING AND (* BETWEEN c40 AND c36) PRECEDING) ORDER BY * NULLS LAST) ORDER BY * ASC) INTERSECT (WITH t64 (c59, c60, c61, c62, c63) AS (SELECT c42, c35, c50 FROM t1 AS t53(c49, c50, c51, c52) NATURAL FULL JOIN t1 AS t58(c54, c55, c56, c57) ORDER BY * DESC NULLS FIRST), t77 (c71, c72, c73, c74, c75, c76) AS (SELECT json_group_array((* IS NOT DISTINCT FROM c57)), 1419, '5881580-07-10'::DATE, (__internal_compress_string_ubigint(c65) BETWEEN c38 AND c50), 9317, c22, #4, c68 FROM t1 AS t69(c65, c66, c67, c68) WHERE cume_dist() OVER (PARTITION BY c1, TRY_CAST(c55 AS STRUCT(a INTEGER[], b VARCHAR[])), c1, c42, c4 ORDER BY c52[array_reduce(['d', 'e', 'f'], (lambda c70: (c32 OR c25)), c35):c39] DESC, ((NOT c45) OR c30) ASC NULLS FIRST, 6123 DESC NULLS LAST ROWS BETWEEN CURRENT ROW AND 2564 PRECEDING) USING SAMPLE 63096 (System) ORDER BY *)SELECT c21, "replace"(c25, c51, c63), #8, c54[c20], c61, c26, 'b88432de-ed82-4a43-8438-4fe3c6882af7' FROM t1 AS t82(c78, c79, c80, c81) GROUP BY ALL HAVING icu_collate_da('72b0b71f-7f89-40db-8066-e0c00f5ef86d') USING SAMPLE 90% (System) ORDER BY *) ORDER BY * NULLS LAST;
ATTACH DATABASE 'duckdb_unittest_tempdir/fuzz_gen_db_SQ761Kius2.db' AS SQ761Kius2;
ATTACH DATABASE 'duckdb_unittest_tempdir/fuzz_gen_db_GIrh$GPwxr.db' AS "GIrh$GPwxr";
SELECT '0512d9d5-fc29-4a86-8cf1-64b965dc7a55' FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE 4462 ORDER BY * ASC NULLS FIRST;
SELECT c37, (((4016 = ANY(SELECT icu_collate_nb_no(c53), (c54 <= '0e88a835-eaf6-4b07-bae8-97350ceb6910'), c55 FROM t1 AS t57(c53, c54, c55, c56) WHERE '290309-12-22 (BC) 00:00:00'::TIMESTAMP_S GROUP BY c41 ORDER BY * DESC NULLS FIRST)) NOT IN (c17, c40, 4303)) OR (c25 BETWEEN c38 AND c17)), (rank_dense() OVER (RANGE BETWEEN c5 FOLLOWING AND CURRENT ROW) BETWEEN c39 AND ((c43 NOT IN (NOT EXISTS(SELECT c78, c60, [], TRY_CAST((c73 IS NULL) AS DECIMAL(4,1)), c39, (#4 OR 3723), TRY_CAST(c38 AS DATE) FROM all_types AS t109(c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108) POSITIONAL JOIN all_types AS t161(c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160) ON (c93) PIVOT (format_bytes(c28) FOR (c11, c15) IN ((6802, '43bba09b-dfb6-4976-a5f0-496a824d9bf5'))) WHERE c158 QUALIFY NOT EXISTS(SELECT DISTINCT 8543, c163, c96 FROM t1 AS t166(c162, c163, c164, c165) WHERE 7997 HAVING #4 ORDER BY * NULLS FIRST) ORDER BY * ASC NULLS FIRST), 799, (c2 AND TRY_CAST((c28 AND 1926) AS DECIMAL(38,10))), age(list_avg(c28)), c23, c34, *, c38)) AND (5829 <= (c42 BETWEEN ((c47 BETWEEN c28 AND c4) BETWEEN c15 AND c1) AND #3)))), c7 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE (c13 AND c44) USING SAMPLE 74677 (Bernoulli) ORDER BY * DESC NULLS LAST;
SELECT c48, (NULL IN (c11)), #8, variant_to_parquet_variant(((c55 OR c66) AND *)), TRY_CAST(c53 AS FLOAT), c53, c37, c30, c34 FROM t1 AS t5(c1, c2, c3, c4) INNER JOIN all_types AS t57(c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56) LEFT JOIN t1 AS t62(c58, c59, c60, c61) FULL JOIN t1 AS t67(c63, c64, c65, c66) ON ('a32a1228-b7b4-4fd6-abbb-30a53a2b25c5') ON (c9) FULL JOIN t1 AS t72(c68, c69, c70, c71) ON (c22) ON ('enum_0') PIVOT (icu_collate_sr(556) FOR (c26) IN (9270) GROUP BY c35) HAVING 5330 ORDER BY t72.* DESC NULLS FIRST;
SELECT c29 FROM t1 AS t5(c1, c2, c3, c4) FULL JOIN all_types AS t57(c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56) ON (#5[NULL]) ORDER BY *;
WITH t127 (c120, c121, c122, c123, c124, c125, c126) AS (SELECT c10, NULL, ((c32 IS NOT NULL) BETWEEN c17 AND array_negative_inner_product(c39, c48)), c40, c38, icu_collate_yi((ntile(c36) OVER (RANGE BETWEEN c10 PRECEDING AND CAST(7542 AS TIME WITH TIME ZONE) PRECEDING) OR ((SELECT (TRY_CAST(c45 AS TIMESTAMP WITH TIME ZONE[]) BETWEEN c42 AND (NOT c1)), c14, (c30 OR c7), c14, c24 FROM (VALUES (5993, '166d9444-7c7c-4957-81f6-9714808d2ea3', 'efeaabe9-8d80-434f-8498-a82dfaf22a28', 0, NULL, 9604), (4629, 5500, 'c0420644-4614-43a7-9a97-49f1653ce3f0', NULL, 8288, '17a56be8-9cbc-4b65-afd6-74ce832061e4'), (4588, 6528, 2846, [42, 999, NULL, NULL, -42], 341, '43cc7a41-40a3-41c1-92f1-97acce30a397')) WHERE c18 ORDER BY * ASC NULLS FIRST) EXCEPT (((SELECT DISTINCT c53, 5358, c56, c55, c53, 209 FROM t1 AS t57(c53, c54, c55, c56) ORDER BY *) UNION ((SELECT DISTINCT #7, c58, c83, c95, t109.* FROM all_types AS t109(c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108) ORDER BY * ASC) UNION BY NAME (SELECT TRY_CAST(c53 AS ENUM('enum_0', 'enum_69999')), c53, c60, 3688, (ARRAY[c80]) FROM icu_calendar_names() AS t114(c110, c111, c112, c113) ORDER BY * ASC) ORDER BY * DESC NULLS FIRST) ORDER BY t57.* ASC NULLS FIRST) UNION BY NAME (SELECT c13, #7, c78, cume_dist() OVER (ORDER BY 436 ASC NULLS FIRST ROWS BETWEEN c107 PRECEDING AND c70 PRECEDING), *, c118, log(c41), (c82 BETWEEN rank() OVER (PARTITION BY c64 ORDER BY c80, CAST(c53 AS UTINYINT) DESC, t57.* DESC NULLS LAST, c82 NULLS FIRST ROWS BETWEEN c103 FOLLOWING AND CURRENT ROW) AND c68), c87 FROM t1 AS t119(c115, c116, c117, c118) WHERE c44 GROUP BY c77, 1525 HAVING c99 ORDER BY * DESC NULLS LAST) ORDER BY t52.* DESC NULLS LAST) ORDER BY *))), c1, c14 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) GROUP BY '\x00\x00\x00a'::BLOB ORDER BY * NULLS LAST), t234 (c232, c233) AS (SELECT TRY_CAST(cume_dist() OVER (PARTITION BY c173, 4634 ROWS BETWEEN (* AND c16) FOLLOWING AND #10 FOLLOWING) AS VARCHAR[]), (c174 IS NOT NULL), EXISTS(SELECT *, (lead(#3, c202) OVER (PARTITION BY c211 RANGE BETWEEN CURRENT ROW AND c206 PRECEDING) IS NULL), CAST(#3 AS BIT), *, (#2 BETWEEN c219 AND (c129 OR c202)), c49, (c199 != c192), c183, c204 FROM all_types AS t231(c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210, c211, c212, c213, c214, c215, c216, c217, c218, c219, c220, c221, c222, c223, c224, c225, c226, c227, c228, c229, c230) ORDER BY * ASC), c48 FROM all_types AS t179(c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178) HAVING * QUALIFY c16 ORDER BY * ASC NULLS LAST)SELECT DISTINCT (c170 OR c134), c17, c169, ntile(c175) OVER (PARTITION BY NULL, c50, [[], [42, 999, NULL, NULL, -42], NULL, [], [42, 999, NULL, NULL, -42]] RANGE BETWEEN #8 FOLLOWING AND CURRENT ROW), 5099, CAST(c175 AS BIGINT)[c43], c145[c236], 7, c149 FROM t1 AS t239(c235, c236, c237, c238) GROUP BY c167, c8 HAVING c23 ORDER BY * DESC NULLS FIRST;
SELECT DISTINCT 614, 1810, row_number() OVER (PARTITION BY c41, t52.* RANGE BETWEEN c27 FOLLOWING AND CURRENT ROW) FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) ORDER BY * ASC NULLS LAST;
WITH t8 (c6, c7) AS (SELECT icu_collate_ug(c3), c3, (json_serialize_plan(c1, #8) < c4), (rpad(c1, (ntile(c1) OVER (ROWS BETWEEN (NULL OR least_common_multiple(c4, c1)) FOLLOWING AND CURRENT ROW) AND c1), #6) BETWEEN c2 AND 4696), (c2 IN (c1, c4, c3, c3, c2)), "->>"(#6, c4), c3 FROM t1 AS t5(c1, c2, c3, c4) WHERE 753 ORDER BY * DESC NULLS FIRST)SELECT DISTINCT c36, *, c69, c31, c69, c45, c35 FROM ((SELECT c7, (c10 AND 'c7cdf377-df16-4743-94df-5261d7212248'), 'b13b041a-7ec0-4abe-986e-8f4289e67a47', c25, (c1 AND c23 AND c50), icu_collate_eo(#9) FROM all_types AS t60(c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56, c57, c58, c59) WHERE c11 HAVING (c59 IS DISTINCT FROM c26) USING SAMPLE 19% (Bernoulli) ORDER BY * NULLS LAST) EXCEPT (SELECT DISTINCT ((c4 AND c50 AND c1) = c64), c7 FROM (SELECT c23 FROM arrow_scan('00:00:00+15:59:59'::TIME WITH TIME ZONE, 5805, 7660) AS t66(c61, c62, c63, c64, c65) WHERE (* BETWEEN * AND c32) USING SAMPLE 45% (Reservoir) ORDER BY * NULLS LAST) AS t67 WHERE c18 HAVING c13 ORDER BY * DESC) ORDER BY * NULLS LAST) AS t68 SEMI JOIN t1 AS t73(c69, c70, c71, c72) ON (3396) USING SAMPLE 35946 (Reservoir) ORDER BY t8.* NULLS LAST;
SELECT (nth_value(*, c24) OVER (PARTITION BY c44, (c19 IS NOT NULL) ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) BETWEEN '512bb00e-8df9-4ae7-b7ff-9cf001ab92d5' AND ((c46 BETWEEN TRY_CAST(c17 AS VARCHAR[]) AND c33) BETWEEN (* AND c4) AND [[42, 999, NULL, NULL, -42], [], [42, 999, NULL, NULL, -42]])), c11, {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, c13, c39 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE NULL HAVING c32 ORDER BY * DESC NULLS FIRST;
DETACH DATABASE "GIrh$GPwxr";
SELECT DISTINCT CAST(date_trunc(c53, c44) AS DOUBLE), 245, (ARRAY[]), TRY_CAST(* AS TIMESTAMP_MS) FROM t1 AS t57(c53, c54, c55, c56) GROUP BY t52.* ORDER BY * ASC NULLS LAST;
SELECT 2002, 170141183460469231731687303715884105727, CAST(c50 AS STRUCT(a INTEGER[3], b VARCHAR[3])), c45[#7:c50], *, (c27 > (lag(c7, c20) OVER (PARTITION BY CAST(c23 AS TIME) ROWS BETWEEN regr_avgx(*, c23) PRECEDING AND CURRENT ROW) IS DISTINCT FROM 2471)) FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) ORDER BY *;
((SELECT c26, c29, c25, first_value(c10) OVER (ROWS BETWEEN (c32 BETWEEN (c35 IS NULL) AND c40) FOLLOWING AND CURRENT ROW), c36, (c26 BETWEEN (c1 = (c42 NOT IN (c11, c49, c23))) AND (c49 IN (-99999.9999, c13, ntile('81df407f-72ae-4bad-b135-c97ecb655552') OVER (PARTITION BY c7, * ORDER BY c47, c24 DESC NULLS FIRST RANGE BETWEEN CURRENT ROW AND c18 FOLLOWING), c14, c18))), 3180 FROM all_types AS t52(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51) WHERE c45 ORDER BY * ASC NULLS FIRST) UNION (WITH t60 (c58, c59) AS (SELECT c5 FROM t1 AS t57(c53, c54, c55, c56) WHERE c12 ORDER BY t52.* ASC NULLS FIRST)SELECT c30, c32, ((current_schemas(c15) AND c26) BETWEEN c12 AND c33), (* <= c54), #10, (c36 = c14) GROUP BY ALL ORDER BY * ASC NULLS FIRST) ORDER BY t60.* ASC) EXCEPT ((SELECT c59, struct_position(c32, c59), c22, 3934, (c19 BETWEEN c44 AND c56), c76, c107, 1216, c67 FROM all_types AS t112(c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, c110, c111) GROUP BY ALL QUALIFY c107 ORDER BY * DESC NULLS LAST) EXCEPT (((SELECT (ARRAY[c74, (ARRAY[c27, c73, CAST(* AS TIMESTAMP[]), (c78 BETWEEN c80 AND c100)]), c43, c33]) FROM t1 AS t117(c113, c114, c115, c116) WHERE * GROUP BY ALL ORDER BY * ASC NULLS LAST) EXCEPT ((SELECT DISTINCT (c108 IS NOT NULL), c45, c88, c45, c45, * FROM all_types AS t169(c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168) WHERE 7757 QUALIFY c80 ORDER BY * NULLS FIRST) UNION BY NAME (SELECT DISTINCT #5, c93, c6, (era(c187) IS DISTINCT FROM ANY(SELECT c172, pg_table_is_visible(c219), c261, c248, '294247-01-10 04:00:54.775806+00'::TIMESTAMP WITH TIME ZONE[c246:c9], ((c244 OR c251) AND c251) FROM all_types AS t273(c222, c223, c224, c225, c226, c227, c228, c229, c230, c231, c232, c233, c234, c235, c236, c237, c238, c239, c240, c241, c242, c243, c244, c245, c246, c247, c248, c249, c250, c251, c252, c253, c254, c255, c256, c257, c258, c259, c260, c261, c262, c263, c264, c265, c266, c267, c268, c269, c270, c271, c272) WHERE c228 GROUP BY ALL QUALIFY 3226 ORDER BY * DESC NULLS LAST)), ntile(CAST('ef8060c2-bd98-46dc-8fc8-90c82bc072ca' AS UHUGEINT)) OVER (RANGE BETWEEN c214 PRECEDING AND UNBOUNDED FOLLOWING), c145, (CAST(c198 AS INTEGER[][3]) < c62) FROM all_types AS t221(c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210, c211, c212, c213, c214, c215, c216, c217, c218, c219, c220) ORDER BY *) ORDER BY * NULLS LAST) ORDER BY * ASC NULLS FIRST) UNION BY NAME ((SELECT c149, c126, icu_collate_fy(NULL), ('78079173-6f9b-4266-8fe7-5a82e9182ccb' OR c89), (c20 IS DISTINCT FROM c285), NULL, __internal_compress_integral_usmallint(c133, mod(*, #8)), 8341 FROM (SELECT DISTINCT ((c310 != c281) != c317), CAST(c320 AS ENUM('enum_0', 'enum_1', 'enum_2', 'enum_3', 'enum_4', 'enum_5', 'enum_6', 'enum_7', 'enum_8', 'enum_9', 'enum_10', 'enum_11', 'enum_12', 'enum_13', 'enum_14', 'enum_15', 'enum_16', 'enum_17', 'enum_18', 'enum_19', 'enum_20', 'enum_21', 'enum_22', 'enum_23', 'enum_24', 'enum_25', 'enum_26', 'enum_27', 'enum_28', 'enum_29', 'enum_30', 'enum_31', 'enum_32', 'enum_33', 'enum_34', 'enum_35', 'enum_36', 'enum_37', 'enum_38', 'enum_39', 'enum_40', 'enum_41', 'enum_42', 'enum_43', 'enum_44', 'enum_45', 'enum_46', 'enum_47', 'enum_48', 'enum_49', 'enum_50', 'enum_51', 'enum_52', 'enum_53', 'enum_54', 'enum_55', 'enum_56', 'enum_57', 'enum_58', 'enum_59', 'enum_60', 'enum_61', 'enum_62', 'enum_63', 'enum_64', 'enum_65', 'enum_66', 'enum_67', 'enum_68', 'enum_69', 'enum_70', 'enum_71', 'enum_72', 'enum_73', 'enum_74', 'enum_75', 'enum_76', 'enum_77', 'enum_78', 'enum_79', 'enum_80', 'enum_81', 'enum_82', 'enum_83', 'enum_84', 'enum_85', 'enum_86', 'enum_87', 'enum_88', 'enum_89', 'enum_90', 'enum_91', 'enum_92', 'enum_93', 'enum_94', 'enum_95', 'enum_96', 'enum_97', 'enum_98', 'enum_99', 'enum_100', 'enum_101', 'enum_102', 'enum_103', 'enum_104', 'enum_105', 'enum_106', 'enum_107', 'enum_108', 'enum_109', 'enum_110', 'enum_111', 'enum_112', 'enum_113', 'enum_114', 'enum_115', 'enum_116', 'enum_117', 'enum_118', 'enum_119', 'enum_120', 'enum_121', 'enum_122', 'enum_123', 'enum_124', 'enum_125', 'enum_126', 'enum_127', 'enum_128', 'enum_129', 'enum_130', 'enum_131', 'enum_132', 'enum_133', 'enum_134', 'enum_135', 'enum_136', 'enum_137', 'enum_138', 'enum_139', 'enum_140', 'enum_141', 'enum_142', 'enum_143', 'enum_144', 'enum_145', 'enum_146', 'enum_147', 'enum_148', 'enum_149', 'enum_150', 'enum_151', 'enum_152', 'enum_153', 'enum_154', 'enum_155', 'enum_156', 'enum_157', 'enum_158', 'enum_159', 'enum_160', 'enum_161', 'enum_162', 'enum_163', 'enum_164', 'enum_165', 'enum_166', 'enum_167', 'enum_168', 'enum_169', 'enum_170', 'enum_171', 'enum_172', 'enum_173', 'enum_174', 'enum_175', 'enum_176', 'enum_177', 'enum_178', 'enum_179', 'enum_180', 'enum_181', 'enum_182', 'enum_183', 'enum_184', 'enum_185', 'enum_186', 'enum_187', 'enum_188', 'enum_189', 'enum_190', 'enum_191', 'enum_192', 'enum_193', 'enum_194', 'enum_195', 'enum_196', 'enum_197', 'enum_198', 'enum_199', 'enum_200', 'enum_201', 'enum_202', 'enum_203', 'enum_204', 'enum_205', 'enum_206', 'enum_207', 'enum_208', 'enum_209', 'enum_210', 'enum_211', 'enum_212', 'enum_213', 'enum_214', 'enum_215', 'enum_216', 'enum_217', 'enum_218', 'enum_219', 'enum_220', 'enum_221', 'enum_222', 'enum_223', 'enum_224', 'enum_225', 'enum_226', 'enum_227', 'enum_228', 'enum_229', 'enum_230', 'enum_231', 'enum_232', 'enum_233', 'enum_234', 'enum_235', 'enum_236', 'enum_237', 'enum_238', 'enum_239', 'enum_240', 'enum_241', 'enum_242', 'enum_243', 'enum_244', 'enum_245', 'enum_246', 'enum_247', 'enum_248', 'enum_249', 'enum_250', 'enum_251', 'enum_252', 'enum_253', 'enum_254', 'enum_255', 'enum_256', 'enum_257', 'enum_258', 'enum_259', 'enum_260', 'enum_261', 'enum_262', 'enum_263', 'enum_264', 'enum_265', 'enum_266', 'enum_267', 'enum_268', 'enum_269', 'enum_270', 'enum_271', 'enum_272', 'enum_273', 'enum_274', 'enum_275', 'enum_276', 'enum_277', 'enum_278', 'enum_279', 'enum_280', 'enum_281', 'enum_282', 'enum_283', 'enum_284', 'enum_285', 'enum_286', 'enum_287', 'enum_288', 'enum_289', 'enum_290', 'enum_291', 'enum_292', 'enum_293', 'enum_294', 'enum_295', 'enum_296', 'enum_297', 'enum_298', 'enum_299')), c304, ((((c313 OR c40) IN (((c116 OR #5) IS NOT DISTINCT FROM c274), ((c284 > c298) BETWEEN 'def87ebc-2f2e-42ca-98d0-5ade57f2ce7e' AND 8550), c299)) OR c283) NOT IN (lag((c288 AND c274), (c292 NOT IN (c277, c317)), (icu_collate_it(c127) NOT IN (c311, 9416, c310, c306, c165, c280, c321, CAST(c309 AS DATE)))) OVER (ORDER BY c314 DESC ROWS BETWEEN 7670 PRECEDING AND c294 FOLLOWING), 7321)), #2, c98 FROM all_types AS t325(c274, c275, c276, c277, c278, c279, c280, c281, c282, c283, c284, c285, c286, c287, c288, c289, c290, c291, c292, c293, c294, c295, c296, c297, c298, c299, c300, c301, c302, c303, c304, c305, c306, c307, c308, c309, c310, c311, c312, c313, c314, c315, c316, c317, c318, c319, c320, c321, c322, c323, c324) WHERE -9223372036854775808 ORDER BY *) AS t326 WHERE (c202 AND c92) ORDER BY * NULLS LAST) UNION BY NAME (SELECT c290, 0 FROM all_types AS t378(c327, c328, c329, c330, c331, c332, c333, c334, c335, c336, c337, c338, c339, c340, c341, c342, c343, c344, c345, c346, c347, c348, c349, c350, c351, c352, c353, c354, c355, c356, c357, c358, c359, c360, c361, c362, c363, c364, c365, c366, c367, c368, c369, c370, c371, c372, c373, c374, c375, c376, c377) WHERE c346 ORDER BY * DESC NULLS FIRST) ORDER BY * ASC NULLS LAST) ORDER BY * ASC NULLS FIRST) ORDER BY t57.* ASC) ORDER BY * DESC NULLS LAST;
SELECT *, '00000000-0000-0000-0000-000000000000'::UUID, json_group_object(#9, TRY_CAST(NULL AS FLOAT)), c2, 5636, c1, c3 FROM t1 AS t5(c1, c2, c3, c4) GROUP BY TRY_CAST(c4 AS ENUM('enum_0', 'enum_69999')) ORDER BY * ASC NULLS LAST;
SELECT DISTINCT list_max(t10.*), COALESCE(c3, ('369d1ba2-e7c6-417a-aa4f-470d3ca636ae' AND '070365d5-189f-40f7-a772-2d552cc6590d')), (c8 != 1097), c6, (c6 AND c3), c7 FROM t1 AS t10(c6, c7, c8, c9) GROUP BY ALL ORDER BY * ASC NULLS LAST;Error Message
Parser Error: frame starting from following row cannot have preceding rows
Stack Trace
LINE 1: ..., c523, c524, c525) WHERE rank_dense() OVER (RANGE BETWEEN c508 FOLLOWING AND c88 PRECEDING) GROUP BY TRY_CAST(c504...
^
Binder Error: STAR expression is only allowed as the root element of an expression. Use COLUMNS(*) instead.
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ..., #10, c5, c241, epoch_ms(c239) ROWS BETWEEN * FOLLOWING AND ((c19 IS NULL) = 8699) PRECEDING), c28, c15, 'a4801c86-ce59...
^
Parser Error: STAR expression is not allowed in the WHERE clause. Use COLUMNS(*) instead.
Binder Error: Cannot mix values of type INTEGER and INTEGER[][3] in BETWEEN clause - an explicit cast is required
LINE 1: SELECT DISTINCT TRY_CAST(c19 AS BIGNUM), c22, (#8 BETWEEN 3549 AND c50), (c4 AND 0), CAST(c40 AS VARCHAR[3...
^
Binder Error: at least one window function must appear in the SELECT column or QUALIFY clause
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ... (PARTITION BY (c60 OR '5881580-07-10'::DATE) RANGE BETWEEN c51 FOLLOWING AND CURRENT ROW), c3, TRY_CAST(c24 AS STRUCT...
^
Binder Error: Failed to detach database with name "temp": database not found
Not implemented Error: Cannot combine types INTERVAL and INTEGER_LITERAL - an explicit cast is required
Parser Error: syntax error at or near "="
LINE 1: ... (ORDER BY c8 DESC RANGE BETWEEN c9 PRECEDING AND CAST({key1=🦆🦆🦆🦆🦆🦆, key2=goose} AS UHUGEINT) PRECEDING), (c2...
^
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ... AND c17)), (rank_dense() OVER (RANGE BETWEEN c5 FOLLOWING AND CURRENT ROW) BETWEEN c39 AND ((c43 NOT IN (NOT EXISTS(SELECT...
^
Binder Error: Pivot expression must contain exactly one aggregate, but no aggregates were found
LINE 1: ... t1 AS t72(c68, c69, c70, c71) ON (c22) ON ('enum_0') PIVOT (icu_collate_sr(556) FOR (c26) IN (9270) GROUP BY c35) HAVING...
^
Binder Error: No function matches the given name and argument types 'array_extract(BOOLEAN, "NULL")'. You might need to add explicit type casts.
Candidate functions:
array_extract(T[], BIGINT) -> T
array_extract(VARCHAR, BIGINT) -> VARCHAR
array_extract(STRUCT, VARCHAR) -> ANY
array_extract(STRUCT, BIGINT) -> ANY
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ... NULLS LAST, c82 NULLS FIRST ROWS BETWEEN c103 FOLLOWING AND CURRENT ROW) AND c68), c87 FROM t1 AS t119(c115, c116, c117...
^
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ... OVER (PARTITION BY c41, t52.* RANGE BETWEEN c27 FOLLOWING AND CURRENT ROW) FROM all_types AS t52(c1, c2, c3, c4, c5, c6...
^
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ... BETWEEN (NULL OR least_common_multiple(c4, c1)) FOLLOWING AND CURRENT ROW) AND c1), #6) BETWEEN c2 AND 4696), (c2 IN ...
^
Binder Error: STAR expression is only allowed as the root element of an expression. Use COLUMNS(*) instead.
Binder Error: STAR expression is only allowed as the root element of an expression. Use COLUMNS(*) instead.
Binder Error: STAR expression is only allowed as the root element of an expression. Use COLUMNS(*) instead.
Parser Error: frame starting from following row cannot have preceding rows
LINE 1: ... BETWEEN (c32 BETWEEN (c35 IS NULL) AND c40) FOLLOWING AND CURRENT ROW), c36, (c26 BETWEEN (c1 = (c42 NOT IN (c11,...
^
ABORT THROWN BY INTERNAL EXCEPTION: Positional reference expression could not be bound
duckdb::StackTrace::GetStackTrace[abi:cxx11](unsigned long)
duckdb::InternalException::InternalException(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)
duckdb::ExpressionBinder::BindPositionalReference(duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, unsigned long, bool)
duckdb::ExpressionBinder::BindExpression(duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, unsigned long, bool)
duckdb::MacroFunction::BindMacroFunction(duckdb::Binder&, duckdb::vector<duckdb::unique_ptr<duckdb::MacroFunction, std::default_delete<duckdb::MacroFunction>, true>, true, std::allocator<duckdb::unique_ptr<duckdb::MacroFunction, std::default_delete<duckdb::MacroFunction>, true> > > const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::FunctionExpression&, duckdb::vector<duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>, true, std::allocator<duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true> > >&, duckdb::InsertionOrderPreservingMap<duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true> >&, unsigned long)
duckdb::ExpressionBinder::UnfoldMacroExpression(duckdb::FunctionExpression&, duckdb::ScalarMacroCatalogEntry&, duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, unsigned long)
duckdb::ExpressionBinder::BindMacro(duckdb::FunctionExpression&, duckdb::ScalarMacroCatalogEntry&, unsigned long, duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&)
duckdb::ExpressionBinder::BindExpression(duckdb::FunctionExpression&, unsigned long, duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&)
duckdb::ExpressionBinder::BindExpression(duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, unsigned long, bool)
duckdb::BaseSelectBinder::BindExpression(duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, unsigned long, bool)
duckdb::ExpressionBinder::Bind(duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, unsigned long, bool)
duckdb::ExpressionBinder::Bind(duckdb::unique_ptr<duckdb::ParsedExpression, std::default_delete<duckdb::ParsedExpression>, true>&, duckdb::optional_ptr<duckdb::LogicalType, true>, bool)
duckdb::Binder::BindSelectNode(duckdb::SelectNode&, duckdb::BoundStatement)
duckdb::Binder::BindNode(duckdb::SelectNode&)
duckdb::Binder::BindNode(duckdb::QueryNode&)
duckdb::Binder::Bind(duckdb::QueryNode&)
duckdb::Binder::Bind(duckdb::SelectStatement&)
duckdb::Binder::Bind(duckdb::SQLStatement&)
duckdb::Planner::CreatePlan(duckdb::SQLStatement&)
duckdb::Planner::CreatePlan(duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>)
duckdb::ClientContext::CreatePreparedStatementInternal(duckdb::ClientContextLock&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::optional_ptr<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, duckdb::BoundParameterData, duckdb::CaseInsensitiveStringHashFunction, duckdb::CaseInsensitiveStringEquality, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const, duckdb::BoundParameterData> > >, true>)
duckdb::ClientContext::CreatePreparedStatement(duckdb::ClientContextLock&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::optional_ptr<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, duckdb::BoundParameterData, duckdb::CaseInsensitiveStringHashFunction, duckdb::CaseInsensitiveStringEquality, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const, duckdb::BoundParameterData> > >, true>, duckdb::PreparedStatementMode)
duckdb::ClientContext::PendingStatementInternal(duckdb::ClientContextLock&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::PendingQueryParameters const&)
duckdb::ClientContext::PendingStatementOrPreparedStatement(duckdb::ClientContextLock&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::shared_ptr<duckdb::PreparedStatementData, true>&, duckdb::PendingQueryParameters const&)
duckdb::ClientContext::PendingQueryInternal(duckdb::ClientContextLock&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::PendingQueryParameters const&, bool)
duckdb::ClientContext::RunStatementInternal(duckdb::ClientContextLock&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, bool, duckdb::optional_ptr<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, duckdb::BoundParameterData, duckdb::CaseInsensitiveStringHashFunction, duckdb::CaseInsensitiveStringEquality, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const, duckdb::BoundParameterData> > >, true>, bool)
std::function<duckdb::unique_ptr<duckdb::QueryResult, std::default_delete<duckdb::QueryResult>, true> (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::optional_ptr<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, duckdb::BoundParameterData, duckdb::CaseInsensitiveStringHashFunction, duckdb::CaseInsensitiveStringEquality, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const, duckdb::BoundParameterData> > >, true>)>::operator()(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::optional_ptr<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, duckdb::BoundParameterData, duckdb::CaseInsensitiveStringHashFunction, duckdb::CaseInsensitiveStringEquality, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const, duckdb::BoundParameterData> > >, true>) const
duckdb::StatementVerifier::Run(duckdb::ClientContext&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::function<duckdb::unique_ptr<duckdb::QueryResult, std::default_delete<duckdb::QueryResult>, true> (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, duckdb::unique_ptr<duckdb::SQLStatement, std::default_delete<duckdb::SQLStatement>, true>, duckdb::optional_ptr<std::unordered... (body of github issue is truncated)