Skip to content

Binder Error: Failed to detach database with name "temp": database not found #4176

@fuzzerofducks

Description

@fuzzerofducks

Issue found by DuckFuzz on git commit hash ed126 using seed 771615853.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
DETACH DATABASE "temp";
SELECT c13 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 t52.* ASC NULLS FIRST;
SELECT DISTINCT ((* AND 9065) BETWEEN 9941 AND 5117), '2262-04-11 23:47:16.854775806'::TIMESTAMP_NS FROM (VALUES (1604, {key1=🦆🦆🦆🦆🦆🦆, key2=goose}, '0f540a57-8f74-4c73-9333-0b914b6e9f2b', 7489, 99999.9999), (2349, 6564, 'd4f261f0-7eaf-49c2-b7c1-a69076e80de7', 2604, {'a': [4, 5, 6], 'b': ['d', 'e', 'f']}), (6147, 2708, 99999.9999, 1233, 6824)) WHERE ('6dbcb818-9d2e-4d6f-a02b-00a8a55106ac' IS NOT NULL) ORDER BY * NULLS FIRST;
((WITH t1868 (c1862, c1863, c1864, c1865, c1866, c1867) AS (WITH t1266 (c1262, c1263, c1264, c1265) AS (((WITH t57 (c53, c54, c55, c56) AS (SELECT (c35 BETWEEN 6535 AND c31), c48, c41, regr_slope(c19, NULL), 4034 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 ALL HAVING * ORDER BY * ASC NULLS FIRST), t563 (c559, c560, c561, c562) AS ((WITH t118 (c116, c117) AS (SELECT rank() OVER (PARTITION BY c98 ROWS BETWEEN 5603 FOLLOWING AND to_hours(c90) FOLLOWING), json_array_length((c38 < c45)), (c14 BETWEEN 5504 AND (c62 OR NOT EXISTS(SELECT c111 FROM test_vector_types('290309-12-22 (BC) 00:00:00'::TIMESTAMP_MS, all_flat := 5276) AS t115(c110, c111, c112, c113, c114) , (VALUES ('440ec8cd-ee44-4c51-a06f-b96a48524a0c', 2150, -9223372036854775808, NULL, 1965, 7492, 2881, 5848), (NULL, 4559, 5651, 3106, -2147483648, 4881, 1975, 7522), ('7aa9d93f-4ba5-43a6-8675-2512e20bdc15', 2186, 7481, NULL, 'GOOSE', [], 'ef7d2dc2-7425-4fa6-8fc2-95e7f4b2eafa', NULL), (3185, 6392, 2147483647, 3210, 1665, 5041, 5285, 5130), (424, [4, 5, 6], 3164, 2625, 9681, 4878, 'enum_0', 4513), (1.7976931348623157e+308, 5326, -999999999999.999999, [], {'a': [NULL, 2, 3], 'b': ['a', NULL, 'c']}, NULL, 5834, 556)) WHERE c114 HAVING c110 ORDER BY *))), 4775 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) WHERE c50 HAVING (c45 OR c67 OR c22) ORDER BY * ASC)SELECT 3530, c169, octet_length(c92), (SELECT 2149, (c104 OR c139), c89, c122, c22, c119 FROM (VALUES (3686), (4290), ('290309-12-22 (BC) 00:00:00'::TIMESTAMP_S), (NULL), ({'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}), (0), (1136)) WHERE c149 ORDER BY * NULLS LAST), c143 FROM all_types AS t170(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, c169) WHERE c104 ORDER BY * NULLS LAST) UNION ((SELECT (NOT *), c96, c221, c12, c48 FROM all_types AS t222(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, c221) WHERE getvariable(5514) GROUP BY TRY_CAST(c43 AS TINYINT), c85, c49 HAVING c167 QUALIFY c69 ORDER BY * DESC NULLS FIRST) EXCEPT ((SELECT DISTINCT c162 FROM all_types AS t274(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, c273) WHERE c48 ORDER BY * DESC NULLS FIRST) UNION BY NAME (WITH t445 (c439, c440, c441, c442, c443, c444) AS (WITH t333 (c327, c328, c329, c330, c331, c332) AS (SELECT c180, (c236 BETWEEN c193 AND c183), [] FROM all_types AS t326(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, c325) ORDER BY * DESC)SELECT DISTINCT c67, c320, (c78 IS NOT DISTINCT FROM #9), c4, 1861, c106, NULL, c31, c344 FROM (SELECT DISTINCT c247, 197, c358, c248, NOT EXISTS(SELECT DISTINCT c372, (c3 IS NOT NULL), c304, c280, cume_dist() OVER (PARTITION BY #8 ORDER BY ('950dfe0b-5cdd-46da-92e7-76f2cb6f0e4c' <= c347) DESC NULLS FIRST, * DESC NULLS FIRST, c336 NULLS LAST ROWS BETWEEN c381 PRECEDING AND '🦆🦆🦆🦆🦆🦆' PRECEDING), c374 WHERE (c342 >= c339) GROUP BY c362, (SELECT DISTINCT c433, c354, c430, 'ef926f99-c2f2-4e9a-9c61-39d0e6ecd26e', c422, c338, c369, [] FROM all_types AS t437(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, c421, c422, c423, c424, c425, c426, c427, c428, c429, c430, c431, c432, c433, c434, c435, c436) WHERE c83 ORDER BY * ASC), c346 HAVING (c356 OR CAST((c84 IS DISTINCT FROM c86) AS DOUBLE[])) ORDER BY *), c301, c374 FROM all_types AS t385(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, c378, c379, c380, c381, c382, c383, c384) WHERE c378 ORDER BY t326.*) AS t438 GROUP BY c18 ORDER BY * DESC), t454 (c449, c450, c451, c452, c453) AS (SELECT DISTINCT (5917 != c32), "+"(CAST(CAST(2208 AS INTEGER[3][]) AS ENUM('DUCK_DUCK_ENUM', 'GOOSE')), c46), c42, c164, ltrim(c175), 520 FROM dbgen("catalog" := [NULL, 2, 3], suffix := NULL, overwrite := 1860) AS t448(c446, c447) WHERE ((c32 BETWEEN c122 AND c346) AND first_value(c275) OVER (PARTITION BY c187, c194, c88, c135, c441 RANGE BETWEEN c200 PRECEDING AND UNBOUNDED FOLLOWING)) ORDER BY * DESC NULLS FIRST)SELECT DISTINCT (c225 OR 5888), (SELECT DISTINCT c525, c543, 8261, '5881580-07-10'::DATE, c525[c525[(c521 OR 1032)]], first_value((c526 <= 336)) OVER (PARTITION BY c528, contains(c521, c546) RANGE BETWEEN map_from_entries(c519, icu_collate_fo((c178 AND c511)), c544, c535) PRECEDING AND UNBOUNDED FOLLOWING) FROM all_types AS t558(c507, c508, c509, c510, c511, c512, c513, c514, c515, c516, c517, c518, c519, c520, c521, c522, c523, c524, c525, c526, 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) WHERE c528 HAVING #8 ORDER BY * ASC), c240 FROM all_types AS t506(c455, c456, c457, c458, c459, c460, c461, c462, c463, c464, c465, c466, c467, c468, c469, c470, c471, c472, c473, c474, 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) QUALIFY (c462 BETWEEN last_value(c263) OVER (ROWS BETWEEN c78 FOLLOWING AND c376 FOLLOWING) AND c141) USING SAMPLE 94% (System) ORDER BY t274.* ASC NULLS LAST) ORDER BY * DESC NULLS LAST) ORDER BY * NULLS LAST) ORDER BY * ASC NULLS FIRST), t1157 (c1155, c1156) AS ((SELECT #9, c571, c594 FROM all_types AS t615(c564, c565, c566, c567, c568, c569, c570, c571, c572, c573, c574, c575, c576, c577, c578, c579, c580, c581, c582, c583, c584, c585, c586, 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) WHERE c21 GROUP BY c272, TRY_CAST(array_concat(c377, c290) 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')), c192, c288 HAVING c382 ORDER BY * ASC NULLS FIRST) EXCEPT (WITH t1102 (c1098, c1099, c1100, c1101) AS (((SELECT ((c476 OR *[c623:c627]) > c284), '6dc5c02c-67fc-4ed1-92f1-2435753f08d8', (c319 OR c36), c368, to_decades(c284), c453, (c135 AND (c628 < TRY_CAST(c618 AS UINTEGER))), c87 FROM all_types AS t667(c616, c617, c618, c619, c620, c621, c622, c623, c624, c625, c626, c627, c628, c629, c630, c631, c632, c633, c634, c635, c636, c637, c638, 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) ORDER BY * NULLS LAST) EXCEPT (WITH t829 (c824, c825, c826, c827, c828) AS (SELECT c81, ((rank_dense() OVER (RANGE BETWEEN c64 FOLLOWING AND CURRENT ROW) >= c710) AND c465), 8992, c293, c353, c502, c165 FROM all_types AS t719(c668, c669, c670, c671, c672, c673, c674, c675, c676, c677, c678, c679, c680, c681, c682, c683, c684, c685, c686, c687, c688, c689, c690, 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) WHERE 9302 GROUP BY c467, c499, c350, c369 HAVING (c149 != ANY((SELECT c763, c753, c723, c715, -3.4028235e+38 FROM all_types AS t771(c720, c721, c722, c723, c724, c725, c726, c727, c728, c729, c730, c731, c732, c733, c734, c735, c736, c737, c738, c739, c740, c741, c742, 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) GROUP BY c692, 5480, #10 USING SAMPLE 27% (System) ORDER BY t771.* ASC NULLS LAST) UNION (SELECT DISTINCT CAST(c755 AS DECIMAL(18,6)), TRY_CAST((c674 AND lead(c479) OVER (ORDER BY c650 ASC RANGE BETWEEN CURRENT ROW AND CAST(2866 AS INTEGER[3]) PRECEDING)) AS TIMESTAMP WITH TIME ZONE[]), c819, c799, *, count_if(c351), c722 FROM all_types AS t823(c772, c773, c774, c775, c776, c777, c778, c779, c780, c781, c782, c783, c784, c785, c786, c787, c788, c789, c790, c791, c792, c793, c794, c795, c796, c797, c798, c799, c800, c801, c802, c803, c804, c805, c806, c807, c808, c809, c810, c811, c812, c813, c814, c815, c816, c817, c818, c819, c820, c821, c822) WHERE c765 USING SAMPLE 54729 (Bernoulli) ORDER BY * ASC NULLS LAST) ORDER BY * ASC NULLS FIRST)) USING SAMPLE 47% (Bernoulli) ORDER BY * NULLS FIRST)SELECT *, c658, first_value(c875) OVER (ORDER BY c145 RANGE BETWEEN c462 FOLLOWING AND [] PRECEDING), c582, 9841, c503 FROM all_types AS t881(c830, c831, c832, c833, c834, c835, c836, c837, c838, c839, c840, c841, c842, c843, c844, c845, c846, c847, c848, c849, c850, c851, c852, c853, c854, c855, c856, c857, c858, c859, c860, c861, c862, c863, c864, c865, c866, c867, c868, c869, c870, c871, c872, c873, c874, c875, c876, c877, c878, c879, c880) WHERE 2824 GROUP BY c872, c837, c136, TRY_CAST(c142 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')) ORDER BY * ASC NULLS LAST) ORDER BY * NULLS LAST) UNION BY NAME (WITH t1045 (c1041, c1042, c1043, c1044) AS ((SELECT c27, -2147483648, c338, c216, [[NULL, 2, 3], [4, 5, 6], [NULL, 2, 3]] FROM all_types AS t933(c882, c883, c884, c885, c886, c887, c888, c889, c890, c891, c892, c893, c894, c895, c896, c897, c898, c899, c900, c901, c902, c903, c904, c905, c906, c907, c908, c909, c910, c911, c912, c913, c914, c915, c916, c917, c918, c919, c920, c921, c922, c923, c924, c925, c926, c927, c928, c929, c930, c931, c932) HAVING ('DUCK_DUCK_ENUM' BETWEEN c367 AND c107) ORDER BY * DESC) UNION (WITH t988 (c986, c987) AS (SELECT DISTINCT '6ad80af5-7ac4-4a3a-a6b4-e8954cceb93b', (c896 BETWEEN (c200 AND (c637 IS DISTINCT FROM strlen(32767))) AND 4661), c280 FROM all_types AS t985(c934, c935, c936, c937, c938, c939, c940, c941, c942, c943, c944, c945, c946, c947, c948, c949, c950, c951, c952, c953, c954, c955, c956, c957, c958, c959, c960, c961, c962, c963, c964, c965, c966, c967, c968, c969, c970, c971, c972, c973, c974, c975, c976, c977, c978, c979, c980, c981, c982, c983, c984) WHERE c153 ORDER BY * DESC NULLS LAST)SELECT DISTINCT c328 FROM all_types AS t1040(c989, c990, c991, c992, c993, c994, c995, c996, c997, c998, c999, c1000, c1001, c1002, c1003, c1004, c1005, c1006, c1007, c1008, c1009, c1010, c1011, c1012, c1013, c1014, c1015, c1016, c1017, c1018, c1019, c1020, c1021, c1022, c1023, c1024, c1025, c1026, c1027, c1028, c1029, c1030, c1031, c1032, c1033, c1034, c1035, c1036, c1037, c1038, c1039) WHERE 255 GROUP BY c218, c243, * ORDER BY t438.* ASC NULLS LAST) ORDER BY * DESC NULLS FIRST)SELECT ('2d5ff095-a51c-42e9-841e-59200b2eb4b1' AND lead(NULL) OVER (ROWS BETWEEN 7509 FOLLOWING AND CURRENT ROW)), c48, #8, *, c362, c588, c717, c450, c967 FROM all_types AS t1097(c1046, c1047, c1048, c1049, c1050, c1051, c1052, c1053, c1054, c1055, c1056, c1057, c1058, c1059, c1060, c1061, c1062, c1063, c1064, c1065, c1066, c1067, c1068, c1069, c1070, c1071, c1072, c1073, c1074, c1075, c1076, c1077, c1078, c1079, c1080, c1081, c1082, c1083, c1084, c1085, c1086, c1087, c1088, c1089, c1090, c1091, c1092, c1093, c1094, c1095, c1096) WHERE c573 GROUP BY *, c1033, c849, 8421 HAVING * USING SAMPLE 86% (Bernoulli) ORDER BY * NULLS LAST) ORDER BY * NULLS FIRST)SELECT (NOT 9589), c286, c978, c1078 FROM all_types AS t1154(c1103, c1104, c1105, c1106, c1107, c1108, c1109, c1110, c1111, c1112, c1113, c1114, c1115, c1116, c1117, c1118, c1119, c1120, c1121, c1122, c1123, c1124, c1125, c1126, c1127, c1128, c1129, c1130, c1131, c1132, c1133, c1134, c1135, c1136, c1137, c1138, c1139, c1140, c1141, c1142, c1143, c1144, c1145, c1146, c1147, c1148, c1149, c1150, c1151, c1152, c1153) WHERE * HAVING c1084 ORDER BY * DESC NULLS FIRST) ORDER BY * DESC NULLS LAST)SELECT DISTINCT c1038, c618, c134, '456a8c7e-f9da-470d-b9bd-c4c7fc194a4c', c960, 2147483647, c565, c625 FROM all_types AS t1209(c1158, c1159, c1160, c1161, c1162, c1163, c1164, c1165, c1166, c1167, c1168, c1169, c1170, c1171, c1172, c1173, c1174, c1175, c1176, c1177, c1178, c1179, c1180, c1181, c1182, c1183, c1184, c1185, c1186, c1187, c1188, c1189, c1190, c1191, c1192, c1193, c1194, c1195, c1196, c1197, c1198, c1199, c1200, c1201, c1202, c1203, c1204, c1205, c1206, c1207, c1208) WHERE cume_dist() OVER (ORDER BY NULL ASC NULLS LAST, c352 ASC NULLS LAST, c689 DESC NULLS FIRST RANGE BETWEEN c1098 FOLLOWING AND * PRECEDING) HAVING c570 ORDER BY * ASC NULLS FIRST) UNION (SELECT -999999999999.999999, *, c1046, c16, c1245, 4803, *, c329 FROM all_types AS t1261(c1210, c1211, c1212, c1213, c1214, c1215, c1216, c1217, c1218, c1219, c1220, c1221, c1222, c1223, c1224, c1225, c1226, c1227, c1228, c1229, c1230, c1231, c1232, c1233, c1234, c1235, c1236, c1237, c1238, c1239, c1240, c1241, c1242, c1243, c1244, c1245, c1246, c1247, c1248, c1249, c1250, c1251, c1252, c1253, c1254, c1255, c1256, c1257, c1258, c1259, c1260) WHERE c62 ORDER BY *) ORDER BY * DESC NULLS LAST) INTERSECT (SELECT DISTINCT CAST(c867 AS TIMESTAMP WITH TIME ZONE[]), c931, 313, lag(*) OVER (ROWS BETWEEN NULL FOLLOWING AND CURRENT ROW), (c875 < c348), c1038, 8055, c1088, c688 WHERE c1210 GROUP BY c919, c1125 ORDER BY * ASC) ORDER BY * NULLS LAST), t1375 (c1371, c1372, c1373, c1374) AS (SELECT DISTINCT ('thisisalongblob\x00withnullbytes'::BLOB BETWEEN c483 AND c191), *, c1174, 3505, rank_dense() OVER (ROWS BETWEEN CAST(c1128 AS USMALLINT) FOLLOWING AND CAST(c482 AS TIMESTAMP[]) FOLLOWING), c585, (ARRAY[(c978 > #10)]), (SELECT DISTINCT c1341, 9223372036854775807 FROM all_types AS t1370(c1319, c1320, c1321, c1322, c1323, c1324, c1325, c1326, c1327, c1328, c1329, c1330, c1331, c1332, c1333, c1334, c1335, c1336, c1337, c1338, c1339, c1340, c1341, c1342, c1343, c1344, c1345, c1346, c1347, c1348, c1349, c1350, c1351, c1352, c1353, c1354, c1355, c1356, c1357, c1358, c1359, c1360, c1361, c1362, c1363, c1364, c1365, c1366, c1367, c1368, c1369) WHERE * GROUP BY c1320, 5799 ORDER BY * ASC NULLS FIRST), c975 FROM all_types AS t1318(c1267, c1268, c1269, c1270, c1271, c1272, c1273, c1274, c1275, c1276, c1277, c1278, c1279, c1280, c1281, c1282, c1283, c1284, c1285, c1286, c1287, c1288, c1289, c1290, c1291, c1292, c1293, c1294, c1295, c1296, c1297, c1298, c1299, c1300, c1301, c1302, c1303, c1304, c1305, c1306, c1307, c1308, c1309, c1310, c1311, c1312, c1313, c1314, c1315, c1316, c1317) WHERE 0 ORDER BY * DESC NULLS LAST), t1492 (c1485, c1486, c1487, c1488, c1489, c1490, c1491) AS (WITH t1432 (c1428, c1429, c1430, c1431) AS (SELECT c905, c712, (grade_up(c136, c60) = lead((c825 BETWEEN c73 AND c231)) OVER (PARTITION BY c1306 ORDER BY c1142 DESC RANGE BETWEEN (ARRAY[c834[c1050:c1061], (c47 BETWEEN (COALESCE(c301, 8412, 983) NOT IN (ceiling(c32), *, c1254, c887)) AND c568), c568[c185]]) FOLLOWING AND CURRENT ROW))[to_hours(c957):c1217], TRY_CAST(CAST(c1303 AS INTEGER[3][]) AS INTEGER[][3]) FROM all_types AS t1427(c1376, c1377, c1378, c1379, c1380, c1381, c1382, c1383, c1384, c1385, c1386, c1387, c1388, c1389, c1390, c1391, c1392, c1393, c1394, c1395, c1396, c1397, c1398, c1399, c1400, c1401, c1402, c1403, c1404, c1405, c1406, c1407, c1408, c1409, c1410, c1411, c1412, c1413, c1414, c1415, c1416, c1417, c1418, c1419, c1420, c1421, c1422, c1423, c1424, c1425, c1426) WHERE setseed(c484) ORDER BY * ASC NULLS FIRST)SELECT c663, c596, c871, *, c937 FROM all_types AS t1484(c1433, c1434, c1435, c1436, c1437, c1438, c1439, c1440, c1441, c1442, c1443, c1444, c1445, c1446, c1447, c1448, c1449, c1450, c1451, c1452, c1453, c1454, c1455, c1456, c1457, c1458, c1459, c1460, c1461, c1462, c1463, c1464, c1465, c1466, c1467, c1468, c1469, c1470, c1471, c1472, c1473, c1474, c1475, c1476, c1477, c1478, c1479, c1480, c1481, c1482, c1483) WHERE c569 ORDER BY * ASC NULLS LAST)(SELECT EXISTS(SELECT DISTINCT c1547, (c1547 OR #8), c29, c1589, (c1572 IS NULL), c1554 FROM all_types AS t1596(c1545, c1546, c1547, c1548, c1549, c1550, c1551, c1552, c1553, c1554, c1555, c1556, c1557, c1558, c1559, c1560, c1561, c1562, c1563, c1564, c1565, c1566, c1567, c1568, c1569, c1570, c1571, c1572, c1573, c1574, c1575, c1576, c1577, c1578, c1579, c1580, c1581, c1582, c1583, c1584, c1585, c1586, c1587, c1588, c1589, c1590, c1591, c1592, c1593, c1594, c1595) WHERE 'bea9e839-8a42-473d-85ab-2d41ee05eba5' ORDER BY * ASC NULLS LAST), c999, corr(c1539, '755e7746-7a01-4722-bff6-190b44881aed') OVER (ORDER BY c318 ASC ROWS BETWEEN c1450 FOLLOWING AND CURRENT ROW), pg_type_is_visible(c956), #2 FROM all_types AS t1544(c1493, c1494, c1495, c1496, c1497, c1498, c1499, c1500, c1501, c1502, c1503, c1504, c1505, c1506, c1507, c1508, c1509, c1510, c1511, c1512, c1513, c1514, c1515, c1516, c1517, c1518, c1519, c1520, c1521, c1522, c1523, c1524, c1525, c1526, c1527, c1528, c1529, c1530, c1531, c1532, c1533, c1534, c1535, c1536, c1537, c1538, c1539, c1540, c1541, c1542, c1543) WHERE c1476 GROUP BY GROUPING SETS (((c711 < c191), c486, c477),(c477, 8415),(c486)) HAVING -1.7976931348623157e+308 ORDER BY t438.* ASC) UNION BY NAME ((SELECT c1170 FROM all_types AS t1648(c1597, c1598, c1599, c1600, c1601, c1602, c1603, c1604, c1605, c1606, c1607, c1608, c1609, c1610, c1611, c1612, c1613, c1614, c1615, c1616, c1617, c1618, c1619, c1620, c1621, c1622, c1623, c1624, c1625, c1626, c1627, c1628, c1629, c1630, c1631, c1632, c1633, c1634, c1635, c1636, c1637, c1638, c1639, c1640, c1641, c1642, c1643, c1644, c1645, c1646, c1647) FULL JOIN all_types AS t1700(c1649, c1650, c1651, c1652, c1653, c1654, c1655, c1656, c1657, c1658, c1659, c1660, c1661, c1662, c1663, c1664, c1665, c1666, c1667, c1668, c1669, c1670, c1671, c1672, c1673, c1674, c1675, c1676, c1677, c1678, c1679, c1680, c1681, c1682, c1683, c1684, c1685, c1686, c1687, c1688, c1689, c1690, c1691, c1692, c1693, c1694, c1695, c1696, c1697, c1698, c1699) ON (c953) NATURAL RIGHT JOIN all_types AS t1752(c1701, c1702, c1703, c1704, c1705, c1706, c1707, c1708, c1709, c1710, c1711, c1712, c1713, c1714, c1715, c1716, c1717, c1718, c1719, c1720, c1721, c1722, c1723, c1724, c1725, c1726, c1727, c1728, c1729, c1730, c1731, c1732, c1733, c1734, c1735, c1736, c1737, c1738, c1739, c1740, c1741, c1742, c1743, c1744, c1745, c1746, c1747, c1748, c1749, c1750, c1751) INNER JOIN all_types AS t1804(c1753, c1754, c1755, c1756, c1757, c1758, c1759, c1760, c1761, c1762, c1763, c1764, c1765, c1766, c1767, c1768, c1769, c1770, c1771, c1772, c1773, c1774, c1775, c1776, c1777, c1778, c1779, c1780, c1781, c1782, c1783, c1784, c1785, c1786, c1787, c1788, c1789, c1790, c1791, c1792, c1793, c1794, c1795, c1796, c1797, c1798, c1799, c1800, c1801, c1802, c1803) USING (c169) ORDER BY * NULLS FIRST) UNION (SELECT DISTINCT c1151, 108, c1711, (c703 AND c1663), c1835, c73 FROM test_all_types(use_large_enum := {'a': [42, 999, NULL, NULL, -42], 'b': ['🦆🦆🦆🦆🦆🦆', 'goose', NULL, '']}) AS t1809(c1805, c1806, c1807, c1808) INNER JOIN all_types AS t1861(c1810, c1811, c1812, c1813, c1814, c1815, c1816, c1817, c1818, c1819, c1820, c1821, c1822, c1823, c1824, c1825, c1826, c1827, c1828, c1829, c1830, c1831, c1832, c1833, c1834, c1835, c1836, c1837, c1838, c1839, c1840, c1841, c1842, c1843, c1844, c1845, c1846, c1847, c1848, c1849, c1850, c1851, c1852, c1853, c1854, c1855, c1856, c1857, c1858, c1859, c1860) ON (c1094) PIVOT (floor((c591 > c1087)) FOR ([]) IN (2955, '290309-12-22 (BC) 00:00:00'::TIMESTAMP) GROUP BY c1414, c577, c909, c587) WHERE [] ORDER BY * DESC) ORDER BY * DESC NULLS FIRST) ORDER BY * NULLS FIRST)(WITH t1925 (c1921, c1922, c1923, c1924) AS (SELECT DISTINCT c355, *, c973, c232, cume_dist() OVER (PARTITION BY 5481 RANGE BETWEEN #8 FOLLOWING AND 'c1aca803-0659-4b62-9484-15e3f7be6925' PRECEDING), '05c4d26b-ed39-4b1c-8a45-a1e48b8290bf', (3641 IS NOT NULL) FROM all_types AS t1920(c1869, c1870, c1871, c1872, c1873, c1874, c1875, c1876, c1877, c1878, c1879, c1880, c1881, c1882, c1883, c1884, c1885, c1886, c1887, c1888, c1889, c1890, c1891, c1892, c1893, c1894, c1895, c1896, c1897, c1898, c1899, c1900, c1901, c1902, c1903, c1904, c1905, c1906, c1907, c1908, c1909, c1910, c1911, c1912, c1913, c1914, c1915, c1916, c1917, c1918, c1919) GROUP BY 7618 HAVING nth_value(c1274, #9) OVER (RANGE BETWEEN CURRENT ROW AND CURRENT ROW) ORDER BY * NULLS FIRST)(SELECT DISTINCT c211, c1604, c658, (c580 < (c923 BETWEEN c1515 AND nth_value(1948, c1991) OVER (PARTITION BY *, #7, '96a02096-698a-41ca-971a-a12f58fbbc79' ROWS BETWEEN CURRENT ROW AND CURRENT ROW))), c634, c1015, (c713 AND c337), #7, c1894 FROM (SELECT DISTINCT c1945, c832 FROM all_types AS t1977(c1926, c1927, c1928, c1929, c1930, c1931, c1932, c1933, c1934, c1935, c1936, c1937, c1938, c1939, c1940, c1941, c1942, c1943, c1944, c1945, c1946, c1947, c1948, c1949, c1950, c1951, c1952, c1953, c1954, c1955, c1956, c1957, c1958, c1959, c1960, c1961, c1962, c1963, c1964, c1965, c1966, c1967, c1968, c1969, c1970, c1971, c1972, c1973, c1974, c1975, c1976) RIGHT JOIN all_types AS t2029(c1978, c1979, c1980, c1981, c1982, c1983, c1984, c1985, c1986, c1987, c1988, c1989, c1990, c1991, c1992, c1993, c1994, c1995, c1996, c1997, c1998, c1999, c2000, c2001, c2002, c2003, c2004, c2005, c2006, c2007, c2008, c2009, c2010, c2011, c2012, c2013, c2014, c2015, c2016, c2017, c2018, c2019, c2020, c2021, c2022, c2023, c2024, c2025, c2026, c2027, c2028) ON (c1981[NULL:[[], [42, 999, NULL, NULL, -42], NULL, [], [42, 999, NULL, NULL, -42]]]) WHERE c1927 ORDER BY * ASC NULLS LAST) AS t2030 FULL JOIN all_types AS t2082(c2031, c2032, c2033, c2034, c2035, c2036, c2037, c2038, c2039, c2040, c2041, c2042, c2043, c2044, c2045, c2046, c2047, c2048, c2049, c2050, c2051, c2052, c2053, c2054, c2055, c2056, c2057, c2058, c2059, c2060, c2061, c2062, c2063, c2064, c2065, c2066, c2067, c2068, c2069, c2070, c2071, c2072, c2073, c2074, c2075, c2076, c2077, c2078, c2079, c2080, c2081) ON ('290309-12-22 (BC) 00:00:00'::TIMESTAMP) WHERE t274.* ORDER BY * ASC NULLS FIRST) INTERSECT (((WITH t2362 (c2360, c2361) AS ((SELECT c946, last_value(c1513) OVER (RANGE BETWEEN 216 FOLLOWING AND 5686 FOLLOWING), 5950, c1795, c634, c10 FROM (VALUES (1969, 4418, true, 0, 'DUCK_DUCK_ENUM', 3983, 0, '83df05d3-173b-4392-a56f-1e485a114d7b'), (3913, 2147483647, '🦆🦆🦆🦆🦆🦆', 9230, '294247-01-10 04:00:54.775806+00'::TIMESTAMP WITH TIME ZONE, 1476, NULL, []), (8027, 2260, 4341, 7951, 7465, 179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368, '59bfeb46-545a-4769-9e89-78e67217d83e', 9267), ('8cf5875c-25e3-4717-affe-6ec0c22cddb8', NULL, 10101, false, 8899, 2073, 7944, 4014), (1047, ['1970-01-01 00:00:00+00'::TIMESTAMP WITH TIME ZONE, 'infinity'::TIMESTAMP WITH TIME ZONE, '-infinity'::TIMESTAMP WITH TIME ZONE, NULL, '2022-05-12 23:23:45+00'::TIMESTAMP WITH TIME ZONE], 3758, 114, 'DUCK_DUCK_ENUM', 6183, NULL, '1677-09-22 00:00:00'::TIMESTAMP_NS)) WHERE c995 GROUP BY ALL USING SAMPLE 31% (Reservoir) ORDER BY t881.* NULLS LAST) EXCEPT (WITH t2255 (c2249, c2250, c2251, c2252, c2253, c2254) AS (WITH t2140 (c2137, c2138, c2139) AS (WITH t2084 (c2083) AS (SELECT c1974, c573, (c1436 AND c21), c267, * FROM (VALUES (NULL, 4862), ([], '83 years 3 months 999 days 00:16:39.999999'::INTERVAL)) WHERE 3630 GROUP BY (c2064 BETWEEN (CAST('c084a4e7-acfd-4ac7-a16c-e9848e0dfd9e' AS BIGINT) OR c1923) AND c672), c1381 ORDER BY * NULLS FIRST)SELECT c1291, 'bcc6ba75-7319-4d7c-8e93-f62ad3d61ffa', 1.7976931348623157e+308, c1506 FROM all_types AS t2136(c2085, c2086, c2087, c2088, c2089, c2090, c2091, c2092, c2093, c2094, c2095, c2096, c2097, c2098, c2099, c2100, c2101, c2102, c2103, c2104, c2105, c2106, c2107, c2108, c2109, c2110, c2111, c2112, c2113, c2114, c2115, c2116, c2117, c2118, c2119, c2120, c2121, c2122, c2123, c2124, c2125, c2126, c2127, c2128, c2129, c2130, c2131, c2132, c2133, c2134, c2135) WHERE c2102 GROUP BY GROUPING SETS ((c2110),(c2110, c919)) HAVING c2 ORDER BY * ASC NULLS LAST), t2196 (c2193, c2194, c2195) AS (SELECT *, TRY_CAST(c1472 AS VARCHAR), ['1970-01-01 00:00:00'::TIMESTAMP, 'infinity'::TIMESTAMP, '-infinity'::TIMESTAMP, NULL, '2022-05-12 16:23:45'::TIMESTAMP], c209 FROM all_types AS t2192(c2141, c2142, c2143, c2144, c2145, c2146, c2147, c2148, c2149, c2150, c2151, c2152, c2153, c2154, c2155, c2156, c2157, c2158, c2159, c2160, c2161, c2162, c2163, c2164, c2165, c2166, c2167, c2168, c2169, c2170, c2171, c2172, c2173, c2174, c2175, c2176, c2177, c2178, c2179, c2180, c2181, c2182, c2183, c2184, c2185, c2186, c2187, c2188, c2189, c2190, c2191) GROUP BY ALL HAVING c1253 USING SAMPLE 36870 (System) ORDER BY * DESC)SELECT DISTINCT ((c1683 BETWEEN c204 AND '3343234a-6154-4997-b8d2-db61738b2f80') IS DISTINCT FROM '2cb185a9-4b69-46ef-88ad-53749a309afe') FROM all_types AS t2248(c2197, c2198, c2199, c2200, c2201, c2202, c2203, c2204, c2205, c2206, c2207, c2208, c2209, c2210, c2211, c2212, c2213, c2214, c2215, c2216, c2217, c2218, c2219, c2220, c2221, c2222, c2223, c2224, c2225, c2226, c2227, c2228, c2229, c2230, c2231, c2232, c2233, c2234, c2235, c2236, c2237, c2238, c2239, c2240, c2241, c2242, c2243, c2244, c2245, c2246, c2247) WHERE c1998 GROUP BY c184, c929, t454.*, * ORDER BY * DESC NULLS FIRST)SELECT c336, c1277, NULL, c1207, CAST(c161 AS FLOAT), c1420, *, c1748, c325 FROM all_types AS t2307(c2256, c2257, c2258, c2259, c2260, c2261, c2262, c2263, c2264, c2265, c2266, c2267, c2268, c2269, c2270, c2271, c2272, c2273, c2274, c2275, c2276, c2277, c2278, c2279, c2280, c2281, c2282, c2283, c2284, c2285, c2286, c2287, c2288, c2289, c2290, c2291, c2292, c2293, c2294, c2295, c2296, c2297, c2298, c2299, c2300, c2301, c2302, c2303, c2304, c2305, c2306) ANTI JOIN all_types AS t2359(c2308, c2309, c2310, c2311, c2312, c2313, c2314, c2315, c2316, c2317, c2318, c2319, c2320, c2321, c2322, c2323, c2324, c2325, c2326, c2327, c2328, c2329, c2330, c2331, c2332, c2333, c2334, c2335, c2336, c2337, c2338, c2339, c2340, c2341, c2342, c2343, c2344, c2345, c2346, c2347, c2348, c2349, c2350, c2351, c2352, c2353, c2354, c2355, c2356, c2357, c2358) ON (c468) GROUP BY rank() OVER (PARTITION BY (TRY_CAST(c2062 AS DOUBLE) IS DISTINCT FROM c1411) RANGE BETWEEN c686 PRECEDING AND 6718 FOLLOWING), 5892 ORDER BY * DESC NULLS FIRST) ORDER BY * ASC NULLS FIRST), t2577 (c2572, c2573, c2574, c2575, c2576) AS (SELECT c243 FROM ((SELECT c2371, c2381, (NOT c2404), c2408, c1418, c2378, c2412, c2404, c2363 FROM all_types AS t2414(c2363, c2364, c2365, c2366, c2367, c2368, c2369, c2370, c2371, c2372, c2373, c2374, c2375, c2376, c2377, c2378, c2379, c2380, c2381, c2382, c2383, c2384, c2385, c2386, c2387, c2388, c2389, c2390, c2391, c2392, c2393, c2394, c2395, c2396, c2397, c2398, c2399, c2400, c2401, c2402, c2403, c2404, c2405, c2406, c2407, c2408, c2409, c2410, c2411, c2412, c2413) WHERE #9 GROUP BY lag(c2375) OVER (ORDER BY * DESC ROWS BETWEEN CURRENT ROW AND * FOLLOWING), c2408, (SELECT (c2461 BETWEEN "day"(c2430) AND c2456), ((c2456 AND #9) IS NOT NULL) FROM all_types AS t2466(c2415, c2416, c2417, c2418, c2419, c2420, c2421, c2422, c2423, c2424, c2425, c2426, c2427, c2428, c2429, c2430, c2431, c2432, c2433, c2434, c2435, c2436, c2437, c2438, c2439, c2440, c2441, c2442, c2443, c2444, c2445, c2446, c2447, c2448, c2449, c2450, c2451, c2452, c2453, c2454, c2455, c2456, c2457, c2458, c2459, c2460, c2461, c2462, c2463, c2464, c2465) WHERE c1052 USING SAMPLE 18565 (System) ORDER BY * NULLS LAST), c2370 ORDER BY * ASC) UNION BY NAME ((SELECT c2504, c2511, c2467, '2c69f27c-33e6-4a0d-9427-884488f45f7c', isfinite(1637), c2501, (c2476 IS NOT DISTINCT FROM json_quote(c2385, #9, (4554 BETWEEN 6838 AND c2363))), c2385 FROM all_types AS t2518(c2467, c2468, c2469, c2470, c2471, c2472, c2473, c2474, c2475, c2476, c2477, c2478, c2479, c2480, c2481, c2482, c2483, c2484, c2485, c2486, c2487, c2488, c2489, c2490, c2491, c2492, c2493, c2494, c2495, c2496, c2497, c2498, c2499, c2500, c2501, c2502, c2503, c2504, c2505, c2506, c2507, c2508, c2509, c2510, c2511, c2512, c2513, c2514, c2515, c2516, c2517) WHERE c2369 HAVING c1118 ORDER BY * DESC NULLS FIRST) UNION BY NAME (SELECT c2569, #5 FROM all_types AS t2570(c2519, c2520, c2521, c2522, c2523, c2524, c2525, c2526, c2527, c2528, c2529, c2530, c2531, c2532, c2533, c2534, c2535, c2536, c2537, c2538, c2539, c2540, c2541, c2542, c2543, c2544, c2545, c2546, c2547, c2548, c2549, c2550, c2551, c2552, c2553, c2554, c2555, c2556, c2557, c2558, c2559, c2560, c2561, c2562, c2563, c2564, c2565, c2566, c2567, c2568, c2569) GROUP BY c2397, c2517 HAVING c2366 ORDER BY * ASC NULLS LAST) ORDER BY * ASC NULLS FIRST) ORDER BY *) AS t2571 WHERE c832 ORDER BY * ASC NULLS LAST)SELECT c1001, c132 FROM all_types AS t2629(c2578, c2579, c2580, c2581, c2582, c2583, c2584, c2585, c2586, c2587, c2588, c2589, c2590, c2591, c2592, c2593, c2594, c2595, c2596, c2597, c2598, c2599, c2600, c2601, c2602, c2603, c2604, c2605, c2606, c2607, c2608, c2609, c2610, c2611, c2612, c2613, c2614, c2615, c2616, c2617, c2618, c2619, c2620, c2621, c2622, c2623, c2624, c2625, c2626, c2627, c2628) WHERE * ORDER BY * NULLS FIRST) UNION BY NAME (((SELECT c1300, c91, ['d', 'e', 'f'], (TRY_CAST(c2406 AS TIMESTAMP) AND c153), 4693, c872, 3492, c125 FROM all_types AS t2681(c2630, c2631, c2632, c2633, c2634, c2635, c2636, c2637, c2638, c2639, c2640, c2641, c2642, c2643, c2644, c2645, c2646, c2647, c2648, c2649, c2650, c2651, c2652, c2653, c2654, c2655, c2656, c2657, c2658, c2659, c2660, c2661, c2662, c2663, c2664, c2665, c2666, c2667, c2668, c2669, c2670, c2671, c2672, c2673, c2674, c2675, c2676, c2677, c2678, c2679, c2680) POSITIONAL JOIN all_types AS t2733(c2682, c2683, c2684, c2685, c2686, c2687, c2688, c2689, c2690, c2691, c2692, c2693, c2694, c2695, c2696, c2697, c2698, c2699, c2700, c2701, c2702, c2703, c2704, c2705, c2706, c2707, c2708, c2709, c2710, c2711, c2712, c2713, c2714, c2715, c2716, c2717, c2718, c2719, c2720, c2721, c2722, c2723, c2724, c2725, c2726, c2727, c2728, c2729, c2730, c2731, c2732) RIGHT JOIN all_types AS t2785(c2734, c2735, c2736, c2737, c2738, c2739, c2740, c2741, c2742, c2743, c2744, c2745, c2746, c2747, c2748, c2749, c2750, c2751, c2752, c2753, c2754, c2755, c2756, c2757, c2758, c2759, c2760, c2761, c2762, c2763, c2764, c2765, c2766, c2767, c2768, c2769, c2770, c2771, c2772, c2773, c2774, c2775, c2776, c2777, c2778, c2779, c2780, c2781, c2782, c2783, c2784) USING (c1289) ON (c107) WHERE c231 GROUP BY (SELECT DISTINCT (c2818 BETWEEN c2797 AND c1687), c2349 FROM all_types AS t2837(c2786, c2787, c2788, c2789, c2790, c2791, c2792, c2793, c2794, c2795, c2796, c2797, c2798, c2799, c2800, c2801, c2802, c2803, c2804, c2805, c2806, c2807, c2808, c2809, c2810, c2811, c2812, c2813, c2814, c2815, c2816, c2817, c2818, c2819, c2820, c2821, c2822, c2823, c2824, c2825, c2826, c2827, c2828, c2829, c2830, c2831, c2832, c2833, c2834, c2835, c2836) ORDER BY t2837.* ASC NULLS FIRST), (9223372036854775807 AND c2512), c2165 ORDER BY * DESC NULLS LAST) UNION (SELECT DISTINCT c2923, (#1 BETWEEN c367 AND octet_length(9644)) FROM all_types AS t2889(c2838, c2839, c2840, c2841, c2842, c2843, c2844, c2845, c2846, c2847, c2848, c2849, c2850, c2851, c2852, c2853, c2854, c2855, c2856, c2857, c2858, c2859, c2860, c2861, c2862, c2863, c2864, c2865, c2866, c2867, c2868, c2869, c2870, c2871, c2872, c2873, c2874, c2875, c2876, c2877, c2878, c2879, c2880, c2881, c2882, c2883, c2884, c2885, c2886, c2887, c2888) SEMI JOIN all_types AS t2941(c2890, c2891, c2892, c2893, c2894, c2895, c2896, c2897, c2898, c2899, c2900, c2901, c2902, c2903, c2904, c2905, c2906, c2907, c2908, c2909, c2910, c2911, c2912, c2913, c2914, c2915, c2916, c2917, c2918, c2919, c2920, c2921, c2922, c2923, c2924, c2925, c2926, c2927, c2928, c2929, c2930, c2931, c2932, c2933, c2934, c2935, c2936, c2937, c2938, c2939, c2940) ON (c2665) ORDER BY *) ORDER BY *) EXCEPT (SELECT c868, *, (((COALESCE(from_base64(c2774), c234, #1) BETWEEN 8765 AND ('016a8cdb-8dc0-46e2-968d-53e0b456166d' BETWEEN (c2685 AND NULL) AND '97b0bacc-9f83-473d-825e-e77dfc54b76a')) BETWEEN c1924 AND c2684) > first_value(c861) OVER (PARTITION BY c463 ORDER BY ('thisisalongblob\x00withnullbytes'::BLOB BETWEEN c2228 AND c2272[(c2968 > c1311[c1038:c32]):c2070]) ASC NULLS FIRST, c2687 ASC NULLS FIRST ROWS BETWEEN c2043 PRECEDING AND 8077 PRECEDING)), 5757, c134, t2140.* FROM all_types AS t2993(c2942, c2943, c2944, c2945, c2946, c2947, c2948, c2949, c2950, c2951, c2952, c2953, c2954, c2955, c2956, c2957, c2958, c2959, c2960, c2961, c2962, c2963, c2964, c2965, c2966, c2967, c2968, c2969, c2970, c2971, c2972, c2973, c2974, c2975, c2976, c2977, c2978, c2979, c2980, c2981, c2982, c2983, c2984, c2985, c2986, c2987, c2988, c2989, c2990, c2991, c2992) WHERE c1431 USING SAMPLE 55% (Bernoulli) ORDER BY * ASC NULLS FIRST) ORDER BY * NULLS LAST) ORDER BY * NULLS LAST) INTERSECT (SELECT 6958, #1, 10101, NULL FROM all_types AS t3045(c2994, c2995, c2996, c2997, c2998, c2999, c3000, c3001, c3002, c3003, c3004, c3005, c3006, c3007, c3008, c3009, c3010, c3011, c3012, c3013, c3014, c3015, c3016, c3017, c3018, c3019, c3020, c3021, c3022, c3023, c3024, c3025, c3026, c3027, c3028, c3029, c3030, c3031, c3032, c3033, c3034, c3035, c3036, c3037, c3038, c3039, c3040, c3041, c3042, c3043, c3044) WHERE c683 GROUP BY ALL ORDER BY * NULLS LAST) ORDER BY * DESC NULLS FIRST) ORDER BY t563.* DESC NULLS LAST) INTERSECT (WITH t3364 (c3363) AS (SELECT c589, c1421, c2647, c2516, 2219, c1622, '1d37acb1-3dac-4f13-ab60-71e2b01629dd', TRY_CAST(3785 AS INTEGER[]), (c74 >= row_number() OVER (RANGE BETWEEN * PRECEDING AND c1846 PRECEDING)) FROM all_types AS t3097(c3046, c3047, c3048, c3049, c3050, c3051, c3052, c3053, c3054, c3055, c3056, c3057, c3058, c3059, c3060, c3061, c3062, c3063, c3064, c3065, c3066, c3067, c3068, c3069, c3070, c3071, c3072, c3073, c3074, c3075, c3076, c3077, c3078, c3079, c3080, c3081, c3082, c3083, c3084, c3085, c3086, c3087, c3088, c3089, c3090, c3091, c3092, c3093, c3094, c3095, c3096) POSITIONAL JOIN (SELECT 821, (6113 <= ANY((SELECT c3174, (t3201.* NOT IN (4441, c3140, (4343 > c3150), c3154, c3162, c3181)), *, c3152, *, c3179 FROM all_types AS t3201(c3150, c3151, c3152, c3153, c3154, c3155, c3156, c3157, c3158, c3159, c3160, c3161, c3162, c3163, c3164, c3165, c3166, c3167, c3168, c3169, c3170, c3171, c3172, c3173, c3174, c3175, c3176, c3177, c3178, c3179, c3180, c3181, c3182, c3183, c3184, c3185, c3186, c3187, c3188, c3189, c3190, c3191, c3192, c3193, c3194, c3195, c3196, c3197, c3198, c3199, c3200) WHERE (c3170 = c3154) ORDER BY * NULLS FIRST) UNION BY NAME ((((SELECT #1 FROM all_types AS t3253(c3202, c3203, c3204, c3205, c3206, c3207, c3208, c3209, c3210, c3211, c3212, c3213, c3214, c3215, c3216, c3217, c3218, c3219, c3220, c3221, c3222, c3223, c3224, c3225, c3226, c3227, c3228, c3229, c3230, c3231, c3232, c3233, c3234, c3235, c3236, c3237, c3238, c3239, c3240, c3241, c3242, c3243, c3244, c3245, c3246, c3247, c3248, c3249, c3250, c3251, c3252) ORDER BY t3201.* DESC NULLS LAST) INTERSECT (SELECT 4007 FROM duckdb_indexes() AS t3257(c3254, c3255, c3256) GROUP BY c3152, 0, #4 ORDER BY * DESC) ORDER BY *) UNION BY NAME (SELECT DISTINCT 4500 FROM all_types AS t3309(c3258, c3259, c3260, c3261, c3262, c3263, c3264, c3265, c3266, c3267, c3268, c3269, c3270, c3271, c3272, c3273, c3274, c3275, c3276, c3277, c3278, c3279, c3280, c3281, c3282, c3283, c3284, c3285, c3286, c3287, c3288, c3289, c3290, c3291, c3292, c3293, c3294, c3295, c3296, c3297, c3298, c3299, c3300, c3301, c3302, c3303, c3304, c3305, c3306, c3307, c3308) PIVOT (favg(*) FOR (TRY_CAST((c3184 AND c3225) AS TINYINT), c3246) IN ((9847, 'bd0adeda-a181-4e79-b1ff-ea014c881f9f')) (c3117) IN (2720, -32768) GROUP BY c3306) WHERE c3213 GROUP BY c3200, (c3136 AND TRY_CAST(c3156 AS INTEGER[3][3])), c3120, c3298 ORDER BY t3309.* DESC NULLS LAST) ORDER BY * DESC NULLS FIRST) UNION (SELECT NULL, c3156, (c3133 AND (((c3339 BETWEEN c3177 AND c3178) BETWEEN c1050 AND c3181) BETWEEN * AND '7b1ffa8f-0ede-474a-b86a-f3e104bff18f')), NULL, c3295, c3109, ('a0606315-f962-455b-a3a5-b8ae1df252b6' < icu_collate_am(c3270)), 2229, c3155 FROM all_types AS t3361(c3310, c3311, c3312, c3313, c3314, c3315, c3316, c3317, c3318, c3319, c3320, c3321, c3322, c3323, c3324, c3325, c3326, c3327, c3328, c3329, c3330, c3331, c3332, c3333, c3334, c3335, c3336, c3337, c3338, c3339, c3340, c3341, c3342, c3343, c3344, c3345, c3346, c3347, c3348, c3349, c3350, c3351, c3352, c3353, c3354, c3355, c3356, c3357, c3358, c3359, c3360) WHERE (CAST(product((array_pop_back(c3318) BETWEEN pg_opfamily_is_visible(c3132) AND c3354)) OVER (PARTITION BY ((2937 BETWEEN c3289 AND c3207) AND c3131), c3166 ROWS BETWEEN CURRENT ROW AND '294247-01-10 04:00:54.775'::TIMESTAMP_MS PRECEDING) AS TIME) IS NOT NULL) ORDER BY * ASC) ORDER BY * ASC NULLS LAST) ORDER BY * ASC NULLS FIRST)), c3134 FROM all_types AS t3149(c3098, c3099, c3100, c3101, c3102, c3103, c3104, c3105, c3106, c3107, c3108, c3109, c3110, c3111, c3112, c3113, c3114, c3115, c3116, c3117, c3118, c3119, c3120, c3121, c3122, c3123, c3124, c3125, c3126, c3127, c3128, c3129, c3130, c3131, c3132, c3133, c3134, c3135, c3136, c3137, c3138, c3139, c3140, c3141, c3142, c3143, c3144, c3145, c3146, c3147, c3148) ORDER BY * ASC NULLS FIRST) AS t3362 USING (c1966, c1381) WHERE c954 HAVING (* BETWEEN (c949 IS NULL) AND c1724) ORDER BY * DESC NULLS FIRST)SELECT c673, c1983, c1194 FROM all_types AS t3416(c3365, c3366, c3367, c3368, c3369, c3370, c3371, c3372, c3373, c3374, c3375, c3376, c3377, c3378, c3379, c3380, c3381, c3382, c3383, c3384, c3385, c3386, c3387, c3388, c3389, c3390, c3391, c3392, c3393, c3394, c3395, c3396, c3397, c3398, c3399, c3400, c3401, c3402, c3403, c3404, c3405, c3406, c3407, c3408, c3409, c3410, c3411, c3412, c3413, c3414, c3415) WHERE "left"(9237, first_value(((NULL < (c176 BETWEEN NULL AND c331)) IN (c2841, (c107 >= (c1690 BETWEEN CAST(c1636 AS INTERVAL) AND c249)), (NOT c1865)))) OVER (PARTITION BY c128 ROWS BETWEEN CURRENT ROW AND c2521 FOLLOWING)) GROUP BY 0 ORDER BY * ASC NULLS LAST) ORDER BY * DESC NULLS LAST) UNION (SELECT DISTINCT lead(#4, c1010) OVER (PARTITION BY * ROWS BETWEEN 5951 PRECEDING AND CURRENT ROW), 'b691ec62-382c-4b91-a6b6-0217a24f514b', (c1805 IS NULL) FROM (VALUES (8399, 9205, 1.7976931348623157e+308, 7064, 6063, 5279, 8185, 2025, NULL, 3271), (NULL, 7492, 6155, 9857, 9311, 894, [{'a': NULL, 'b': NULL}, {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, {'a': NULL, 'b': NULL}], '030125ef-148e-4ef3-a788-334b39dffe46', 9567, 8434), (3076, '791010fc-aba8-4410-8029-19e01d6ec2fd', '5877642-06-25 (BC)'::DATE, 1890, [NULL, 2, 3], 750, NULL, 9205, [], NULL), (7924, 9789, 1272, 4107, 9397, 65535, NULL, 'e416cba6-2d76-43e3-8e29-db40b4364779', 2219, 7790), (6599, 5925, '00:00:00'::TIME, 9412, 4006, 4835, 18446744073709551615, 9869, NULL, 7100)) WHERE * HAVING c1720 USING SAMPLE 81090 (System) ORDER BY * ASC NULLS LAST) ORDER BY *) UNION BY NAME ((WITH t3630 (c3626, c3627, c3628, c3629) AS (SELECT DISTINCT c1884 FROM ((SELECT DISTINCT (#4 AND icu_collate_yi(c2615)), c2004, c3571, c1201, c3526, c2506, c3557, c3540, c3531 FROM all_types AS t3572(c3521, c3522, c3523, c3524, c3525, c3526, c3527, c3528, c3529, c3530, c3531, c3532, c3533, c3534, c3535, c3536, c3537, c3538, c3539, c3540, c3541, c3542, c3543, c3544, c3545, c3546, c3547, c3548, c3549, c3550, c3551, c3552, c3553, c3554, c3555, c3556, c3557, c3558, c3559, c3560, c3561, c3562, c3563, c3564, c3565, c3566, c3567, c3568, c3569, c3570, c3571) GROUP BY c2617, (c1844 BETWEEN c3531 AND c3521), c3553 HAVING c3565 QUALIFY c3571 ORDER BY * ASC NULLS FIRST) EXCEPT (SELECT 8962, icu_collate_ms(c3545), c3594, c3560, c3585, (NOT c3532), c3604 FROM all_types AS t3624(c3573, c3574, c3575, c3576, c3577, c3578, c3579, c3580, c3581, c3582, c3583, c3584, c3585, c3586, c3587, c3588, c3589, c3590, c3591, c3592, c3593, c3594, c3595, c3596, c3597, c3598, c3599, c3600, c3601, c3602, c3603, c3604, c3605, c3606, c3607, c3608, c3609, c3610, c3611, c3612, c3613, c3614, c3615, c3616, c3617, c3618, c3619, c3620, c3621, c3622, c3623) WHERE c2173 HAVING CAST(c3621 AS DECIMAL(9,4)) ORDER BY * DESC NULLS FIRST) ORDER BY * ASC NULLS FIRST) AS t3625 ORDER BY * DESC NULLS FIRST)(SELECT DISTINCT 6839, c2302, c3549, c2713, * FROM all_types AS t3682(c3631, c3632, c3633, c3634, c3635, c3636, c3637, c3638, c3639, c3640, c3641, c3642, c3643, c3644, c3645, c3646, c3647, c3648, c3649, c3650, c3651, c3652, c3653, c3654, c3655, c3656, c3657, c3658, c3659, c3660, c3661, c3662, c3663, c3664, c3665, c3666, c3667, c3668, c3669, c3670, c3671, c3672, c3673, c3674, c3675, c3676, c3677, c3678, c3679, c3680, c3681) WHERE 8459 ORDER BY * DESC) UNION BY NAME ((WITH t3737 (c3735, c3736) AS (SELECT c3061, (c3585 <= c1063), 0, (c3553 BETWEEN * AND *), ((ARRAY[c986, c33]) IS NOT DISTINCT FROM c1797), c2247, #7, c3726 FROM all_types AS t3734(c3683, c3684, c3685, c3686, c3687, c3688, c3689, c3690, c3691, c3692, c3693, c3694, c3695, c3696, c3697, c3698, c3699, c3700, c3701, c3702, c3703, c3704, c3705, c3706, c3707, c3708, c3709, c3710, c3711, c3712, c3713, c3714, c3715, c3716, c3717, c3718, c3719, c3720, c3721, c3722, c3723, c3724, c3725, c3726, c3727, c3728, c3729, c3730, c3731, c3732, c3733) WHERE c1697 GROUP BY c3105 ORDER BY * ASC)SELECT (6758 AND '9a64259e-2310-428f-9dd2-eec3ccc64481'), 2091, 6903[3956], (c349 IS NOT DISTINCT FROM (c3388 <= c2893)) FROM all_types AS t3789(c3738, c3739, c3740, c3741, c3742, c3743, c3744, c3745, c3746, c3747, c3748, c3749, c3750, c3751, c3752, c3753, c3754, c3755, c3756, c3757, c3758, c3759, c3760, c3761, c3762, c3763, c3764, c3765, c3766, c3767, c3768, c3769, c3770, c3771, c3772, c3773, c3774, c3775, c3776, c3777, c3778, c3779, c3780, c3781, c3782, c3783, c3784, c3785, c3786, c3787, c3788) ASOF FULL JOIN all_types AS t3841(c3790, c3791, c3792, c3793, c3794, c3795, c3796, c3797, c3798, c3799, c3800, c3801, c3802, c3803, c3804, c3805, c3806, c3807, c3808, c3809, c3810, c3811, c3812, c3813, c3814, c3815, c3816, c3817, c3818, c3819, c3820, c3821, c3822, c3823, c3824, c3825, c3826, c3827, c3828, c3829, c3830, c3831, c3832, c3833, c3834, c3835, c3836, c3837, c3838, c3839, c3840) , (SELECT c2586, c3854, c3065, TRY_CAST(c3849 AS UTINYINT), c3994, (c2160 BETWEEN c3858 AND '487fb94f-5397-4a3f-bab0-0452bd1c231f') FROM all_types AS t3893(c3842, c3843, c3844, c3845, c3846, c3847, c3848, c3849, c3850, c3851, c3852, c3853, c3854, c3855, c3856, c3857, c3858, c3859, c3860, c3861, c3862, c3863, c3864, c3865, c3866, c3867, c3868, c3869, c3870, c3871, c3872, c3873, c3874, c3875, c3876, c3877, c3878, c3879, c3880, c3881, c3882, c3883, c3884, c3885, c3886, c3887, c3888, c3889, c3890, c3891, c3892) INNER JOIN all_types AS t3945(c3894, c3895, c3896, c3897, c3898, c3899, c3900, c3901, c3902, c3903, c3904, c3905, c3906, c3907, c3908, c3909, c3910, c3911, c3912, c3913, c3914, c3915, c3916, c3917, c3918, c3919, c3920, c3921, c3922, c3923, c3924, c3925, c3926, c3927, c3928, c3929, c3930, c3931, c3932, c3933, c3934, c3935, c3936, c3937, c3938, c3939, c3940, c3941, c3942, c3943, c3944) LEFT JOIN all_types AS t3997(c3946, c3947, c3948, c3949, c3950, c3951, c3952, c3953, c3954, c3955, c3956, c3957, c3958, c3959, c3960, c3961, c3962, c3963, c3964, c3965, c3966, c3967, c3968, c3969, c3970, c3971, c3972, c3973, c3974, c3975, c3976, c3977, c3978, c3979, c3980, c3981, c3982, c3983, c3984, c3985, c3986, c3987, c3988, c3989, c3990, c3991, c3992, c3993, c3994, c3995, c3996) ON (c3949) ON (c3881) GROUP BY c3901, c3928, c3939 ORDER BY *) AS t3998 ON (c1638) WHERE c2916 ORDER BY * DESC NULLS LAST) INTERSECT (WITH t4637 (c4630, c4631, c4632, c4633, c4634, c4635, c4636) AS (((SELECT DISTINCT c712, c2504, (c2550 = '8c4d1caa-713f-4b55-ac61-0c41cfe7a592'), multiply(c652, c2120), {'a': 42, 'b': '🦆🦆🦆🦆🦆🦆'}, (CAST((CAST(c2150 AS HUGEINT) >= ANY(SELECT c441, c4121, CAST(c4126 AS INTEGER), c4145, combine((c4145 IS DISTINCT FROM ANY((SELECT 8980, c4178, c4173, 118, (c4138 BETWEEN c279 AND c4195), c4169, #7 FROM all_types AS t4206(c4155, c4156, c4157, c4158, c4159, c4160, c4161, c4162, c4163, c4164, c4165, c4166, c4167, c4168, c4169, c4170, c4171, c4172, c4173, c4174, c4175, c4176, c4177, c4178, c4179, c4180, c4181, c4182, c4183, c4184, c4185, c4186, c4187, c4188, c4189, c4190, c4191, c4192, c4193, c4194, c4195, c4196, c4197, c4198, c4199, c4200, c4201, c4202, c4203, c4204, c4205) WHERE (c4175 OR c4188) GROUP BY c4180 ORDER BY * NULLS FIRST) EXCEPT (SELECT DISTINCT (CAST(4072 AS STRUCT(a INTEGER, b VARCHAR)[3]) BETWEEN c4245 AND nth_value(c4225, c4197) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND NULL PRECEDING)), c4244, c4255, c4248, 1409, (c4141 BETWEEN c4235 AND c3679), 'c9138344-487b-4727-9fd1-a176e7a6e70f', c4207 FROM all_types AS t4258(c4207, c4208, c4209, c4210, c4211, c4212, c4213, c4214, c4215, c4216, c4217, c4218, c4219, c4220, c4221, c4222, c4223, c4224, c4225, c4226, c4227, c4228, c4229, c4230, c4231, c4232, c4233, c4234, c4235, c4236, c4237, c4238, c4239, c4240, c4241, c4242, c4243, c4244, c4245, c4246, c4247, c4248, c4249, c4250, c4251, c4252, c4253, c4254, c4255, c4256, c4257) UNPIVOT INCLUDE NULLS ((c4115, c4243) FOR c4211 IN (7558, [])) ORDER BY * ASC NULLS FIRST) ORDER BY * ASC NULLS LAST)), (c4110 IN (c4139, c4119))), '6557b050-fc0d-4a53-95a8-bba666491a38', c4110 FROM all_types AS t4154(c4103, c4104, c4105, c4106, c4107, c4108, c4109, c4110, c4111, c4112, c4113, c4114, c4115, c4116, c4117, c4118, c4119, c4120, c4121, c4122, c4123, c4124, c4125, c4126, c4127, c4128, c4129, c4130, c4131, c4132, c4133, c4134, c4135, c4136, c4137, c4138, c4139, c4140, c4141, c4142, c4143, c4144, c4145, c4146, c4147, c4148, c4149, c4150, c4151, c4152, c4153) GROUP BY c1848, *, 'DUCK_DUCK_ENUM', c4135 HAVING (c4139 IS NULL) ORDER BY * NULLS FIRST)) AS INTERVAL) OR c1845), #10, c3886 FROM all_types AS t4050(c3999, c4000, c4001, c4002, c4003, c4004, c4005, c4006, c4007, c4008, c4009, c4010, c4011, c4012, c4013, c4014, c4015, c4016, c4017, c4018, c4019, c4020, c4021, c4022, c4023, c4024, c4025, c4026, c4027, c4028, c4029, c4030, c4031, c4032, c4033, c4034, c4035, c4036, c4037, c4038, c4039, c4040, c4041, c4042, c4043, c4044, c4045, c4046, c4047, c4048, c4049) SEMI JOIN all_types AS t4102(c4051, c4052, c4053, c4054, c4055, c4056, c4057, c4058, c4059, c4060, c4061, c4062, c4063, c4064, c4065, c4066, c4067, c4068, c4069, c4070, c4071, c4072, c4073, c4074, c4075, c4076, c4077, c4078, c4079, c4080, c4081, c4082, c4083, c4084, c4085, c4086, c4087, c4088, c4089, c4090, c4091, c4092, c4093, c4094, c4095, c4096, c4097, c4098, c4099, c4100, c4101) UNPIVOT INCLUDE NULLS (c2646 FOR c3866 IN (3991) c2976 IN (NULL, 9580)) USING (c4001, c1168) WHERE (c1088 IS DISTINCT FROM c2996) ORDER BY * ASC NULLS FIRST) UNION (SELECT dayofweek(c1932), c3636, c443, c3860, (CAST(c3526 AS TIME) = 3432), 8880 FROM all_types AS t4310(c4259, c4260, c4261, c4262, c4263, c4264, c4265, c4266, c4267, c4268, c4269, c4270, c4271, c4272, c4273, c4274, c4275, c4276, c4277, c4278, c4279, c4280, c4281, c4282, c4283, c4284, c4285, c4286, c4287, c4288, c4289, c4290, c4291, c4292, c4293, c4294, c4295, c4296, c4297, c4298, c4299, c4300, c4301, c4302, c4303, c4304, c4305, c4306, c4307, c4308, c4309) WHERE NOT EXISTS(SELECT c2220, (c2153 BETWEEN c1636 AND [NULL, 2, 3]), c611, c1785, *, c1286 FROM (VALUES (5671), (1780), ('f2ae9416-1e98-4a4f-b7a9-81547ae7041e'), (125)) WHERE c2098 HAVING c3668 ORDER BY * ASC NULLS LAST) HAVING (NULL BETWEEN (2799 AND c2010) AND c3813) ORDER BY t1102.*) ORDER BY * DESC NULLS FIRST) INTERSECT ((SELECT (ARRAY[NULL, c217, c1755, #9, icu_collate_or(c2556), 344, c643, c3928, c638]), *, c1120, (ARRAY[((CAST(cume_dist() OVER (PARTITION BY c4285, c2332, ('7890f58a-00cc-424b-87a9-3a57d1c7e7f0' BETWEEN TRY_CAST(c2587 AS TIMESTAMP_S) AND c74)[(c2068 BETWEEN COALESCE(c1060, (c3067 AND [4, 5, 6]), c2281, c3919, (#2 OR c141), (c2901 >= c1806), c1892) AND c1197):(c2597 IS DISTINCT FROM (* AND (c1428 IS NOT NULL)))], 2577[c3856], c3523 ORDER BY TRY_CAST(c1693 AS UTINYINT) ASC, #8 NULLS FIRST RANGE BETWEEN c1080 FOLLOWING AND UNBOUNDED FOLLOWING) AS VARCHAR[3][3]) BETWEEN c676 AND c2990) BETWEEN row_number() OVER (ROWS BETWEEN c3548 PRECEDING AND __internal_decompress_integral_usmallint(c382, *) PRECEDING) AND c1991), c2621]) FROM all_types AS t4362(c4311, c4312, c4313, c4314, c4315, c4316, c4317, c4318, c4319, c4320, c4321, c4322, c4323, c4324, c4325, c4326, c4327, c4328, c4329, c4330, c4331, c4332, c4333, c4334, c4335, c4336, c4337, c4338, c4339, c4340, c4341, c4342, c4343, c4344, c4345, c4346, c4347, c4348, c4349, c4350, c4351, c4352, c4353, c4354, c4355, c4356, c4357, c4358, c4359, c4360, c4361) WHERE c172 HAVING ((c1044 OR c897) BETWEEN c295 AND c1077) USING SAMPLE 48% (System) ORDER BY * ASC NULLS FIRST) UNION BY NAME ((WITH t4473 (c4468, c4469, c4470, c4471, c4472) AS (SELECT *, c131 FROM (VALUES ([], '\x00\x00\x00a'::BLOB, '0589ae45-1a0c-4937-a0e0-5d55a02c0a5c', [[NULL, 2, 3], [4, 5, 6], [NULL, 2, 3]], 5283, 9127, 6831), (3228, '21240c26-9ffe-44e1-96a2-345a090f2232', 973, [[NULL, 2, 3], NULL, [NULL, 2, 3]], 2019, 3624, 4294967295)) INNER JOIN all_types AS t4414(c4363, c4364, c4365, c4366, c4367, c4368, c4369, c4370, c4371, c4372, c4373, c4374, c4375, c4376, c4377, c4378, c4379, c4380, c4381, c4382, c4383, c4384, c4385, c4386, c4387, c4388, c4389, c4390, c4391, c4392, c4393, c4394, c4395, c4396, c4397, c4398, c4399, c4400, c4401, c4402, c4403, c4404, c4405, c4406, c4407, c4408, c4409, c4410, c4411, c4412, c4413) , (SELECT c4459, *, c352 FROM all_types AS t4466(c4415, c4416, c4417, c4418, c4419, c4420, c4421, c4422, c4423, c4424, c4425, c4426, c4427, c4428, c4429, c4430, c4431, c4432, c4433, c4434, c4435, c4436, c4437, c4438, c4439, c4440, c4441, c4442, c4443, c4444, c4445, c4446, c4447, c4448, c4449, c4450, c4451, c4452, c4453, c4454, c4455, c4456, c4457, c4458, c4459, c4460, c4461, c4462, c4463, c4464, c4465) HAVING c4461 ORDER BY * ASC) AS t4467 ON (percent_rank() OVER (ROWS BETWEEN c1270 PRECEDING AND 5521 PRECEDING)) GROUP BY ALL USING SAMPLE 22% (Reservoir) ORDER BY *)(SELECT c3633, c3946, #1, c3555, c3819, c4045, c2982 FROM all_types AS t4525(c4474, c4475, c4476, c4477, c4478, c4479, c4480, c4481, c4482, c4483, c4484, c4485, c4486, c4487, c4488, c4489, c4490, c4491, c4492, c4493, c4494, c4495, c4496, c4497, c4498, c4499, c4500, c4501, c4502, c4503, c4504, c4505, c4506, c4507, c4508, c4509, c4510, c4511, c4512, c4513, c4514, c4515, c4516, c4517, c4518, c4519, c4520, c4521, c4522, c4523, c4524) WHERE (c473 AND 913[c2269:c1055]) GROUP BY c3987, c3113, #5 HAVING c4489 ORDER BY * DESC) UNION ((SELECT c3029, (TRY_CAST(c2496 AS INTEGER) AND c1490) FROM all_types AS t4577(c4526, c4527, c4528, c4529, c4530, c4531, c4532, c4533, c4534, c4535, c4536, c4537, c4538, c4539, c4540, c4541, c4542, c4543, c4544, c4545, c4546, c4547, c4548, c4549, c4550, c4551, c4552, c4553, c4554, c4555, c4556, c4557, c4558, c4559, c4560, c4561, c4562, c4563, c4564, c45... (body of github issue is truncated)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions