Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ABORT THROWN BY INTERNAL EXCEPTION: Calling StringValue::Get on a NULL value #2303

Closed
fuzzerofducks opened this issue Mar 11, 2024 · 0 comments
Labels

Comments

@fuzzerofducks
Copy link
Collaborator

Issue found by DuckFuzz on git commit hash 48a82 using seed 692205788.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT COLUMNS(* REPLACE ((((SELECT c139, ((NOT c163) IS NOT DISTINCT FROM (main.list_value('a', NULL, 'c') > c175)), c195, c16, c100, c143, c18, c119 FROM all_types AS t102(c52, 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) FULL JOIN all_types AS t153(c103, c104, c105, 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) ANTI JOIN pragma_metadata_info(NULL) AS t159(c154, c155, c156, c157, c158) ON (main.list_value()) NATURAL LEFT JOIN all_types AS t210(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) ON (COLUMNS(* EXCLUDE (c14))) GROUP BY ALL ORDER BY c121 NULLS FIRST) UNION (((SELECT c219, c46, (lead((NOT c117), c227) OVER (ORDER BY c76 DESC NULLS FIRST, (c61 BETWEEN c239 AND c156) DESC NULLS LAST, (c34 BETWEEN c204 AND c88) DESC NULLS LAST, c215 ASC NULLS FIRST RANGE BETWEEN c137 PRECEDING AND UNBOUNDED FOLLOWING) BETWEEN c73 AND NULL), c156, c64, TRY_CAST(c142 AS BIT), 1979, c157, c9 FROM all_types AS t261(c211, c212, 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) GROUP BY 'd75329f5-12e4-473a-bd41-5cc0a35f91bb' ORDER BY c192 ASC, (c97 OR (c76 IS NULL)) NULLS LAST) UNION (SELECT DISTINCT (4720 BETWEEN c131 AND TRY_CAST((c114 = 3953) AS DATE[])), c169, c70, c70, c180, #3 FROM (SELECT * FROM (SELECT * FROM (SELECT * FROM (SELECT * FROM (VALUES (3519, NULL, -9999999999999999999999999999.9999999999, NULL, 6475, '4de90c03-0931-4c1a-a96b-9242fc99d591'), ('f5292938-37a1-44f7-8b3a-96d6f0f12147', 4858, 470, CAST('5881580-07-10' AS DATE), 99999.9999, 2113), (901, 6259, 5928, 8427, 6908, NULL), ('a595f232-beff-4638-97f5-3b514794e3b1', main.list_value(), 1117, 2522, 748, '005d89af-7ed5-49f9-8f44-efb4e1d5f204'), (3544, NULL, 1.7976931348623157e+308, CAST('290309-12-22 (BC) 00:00:00+00' AS TIMESTAMP WITH TIME ZONE), 9499, 'b1ec96ec-6638-4201-b962-09229a04782d')) AS valueslist) AS valueslist) AS valueslist) AS valueslist) WHERE c115)) UNION BY NAME (SELECT c252, c160, c185 FROM all_types AS t312(c262, c263, c264, 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) GROUP BY c282, ((c142 AND 'e2b833b7-a098-49fb-b32d-bab8f14f6293') BETWEEN lead(c11, c45) OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND c212 PRECEDING) AND 5449), #3, 9657 HAVING c311))) INTERSECT (SELECT array_to_string((c348 != CAST(c36 AS INTEGER[3][])), 2315), c175, c380, (SELECT DISTINCT c446, c433 FROM all_types AS t465(c415, c416, c417, c418, c419, c420, 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) WHERE ((5352 OR c437) <= c68)), c205, last_value((c8 != #7)) OVER (RANGE BETWEEN CURRENT ROW AND c368 FOLLOWING), c410, 2238, add(c344, 'fde0247f-de7e-4e05-86de-a38e04203ee4') FROM all_types AS t363(c313, c314, c315, c316, 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) ASOF INNER JOIN all_types AS t414(c364, c365, c366, c367, c368, 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) ON (c175) WHERE COLUMNS(* REPLACE (c10[(percent_rank() OVER (ORDER BY ((c39 BETWEEN (c113 OR c118) AND c18) <= c203) NULLS LAST ROWS BETWEEN c115 PRECEDING AND UNBOUNDED FOLLOWING) BETWEEN c219 AND (c40 BETWEEN c92 AND regr_avgx(main.list_value(), #5)))] AS c385)))) AS c38)) FROM all_types AS t51(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)

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Calling StringValue::Get on a NULL value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants