-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: internal error: no volatility for cast tuple[]::tuple #75365
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Description
roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ e1068d77afbd39b162978281c9da7cbea49c1c3a:
WITH
with_82273 (col_489906)
AS (SELECT * FROM (VALUES (NULL), (NULL), (279212558236674.2928:::DECIMAL)) AS tab_201405 (col_489906)),
with_82274 (col_489907, col_489908)
AS (
SELECT
*
FROM
(
VALUES
(
ARRAY[('1e8dc6be-49ca-4c02-9894-7f7c9d3420c1':::UUID, e'{"_6Jo": [{"Z:WD@)#/HF0j": []}, {"b": {}}, []], "_Q(eyY": 1.7085243716925813, "b": [], "q36$)f4": {"!na.gGz": {}, "*q5xz0\\"5": [], "PUA^q|4O\\"": [[]]}}':::JSONB, '01010000803C85A5BA80ADE5C1FC82E157869EE2C1A6F2B8DF7A5CE7C1':::GEOMETRY, (-6.162422387425323067E+33):::DECIMAL),('d008846f-0c70-4789-8b6a-38b00505a2cb':::UUID, '[{"Qu6Y": {"baz": ["ZmzbB<c < "]}}, [[[], [[], 0.27899650667644316]], true]]':::JSONB, '010400000004000000010100000000000000000024400000000000004440010100000000000000000044400000000000003E4001010000000000000000003440000000000000344001010000000000000000003E400000000000002440':::GEOMETRY, (-6.368318416540243950E+19):::DECIMAL),('588eb9a9-c94d-4e5c-9969-d9f656fd2711':::UUID, '{"foobar": [true, {"b": {"9Ivp^B": 0.3738083990918428, "foo": []}}, ["a"], []], "}B{4w8^B_!": [null]}':::JSONB, NULL, (-629587.1498344789839):::DECIMAL)],
'true':::JSONB
),
(
ARRAY[('26111aff-b627-4c84-86c4-8f3f128cd59e':::UUID, '{}':::JSONB, '01020000400400000024FF56464766EEC1C0D8EB76278FA1C11999C866589C01C2711F5A82C21102C284AEFF99D29CD6C1BC96D3F27565EBC1A7A4F7F8BC61F1C191D462E8C68CFFC1BCC998B03893F3C1129E8A72CA80F941DA99D2182A45F8C178CACB6579E3D7C1':::GEOMETRY, (-7.979859399235577402E+33):::DECIMAL),('6fe19b41-aa8c-4be6-9756-172290a497af':::UUID, e'"{*r1uS\\\\ eQSI"':::JSONB, NULL, NULL),('ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, e'[[3.531343091438895], {"b": {}, "mF~BX4NPr": 0.8374191042460422}, {"#ef#\\\\;k<": 2.283332648528415}, [{}, []], {"foobar": []}]':::JSONB, '0102000040030000008081C6547857BC4192ADA8B595ECFCC1CF6999CFF9E101C208030EDDE688F84170C74665D584F6C1F01097FD8B3FC84178F8D5C1E21DF341CC8497D4420AEF41A465FCCFDF24E641':::GEOMETRY, 6.97258867027238686E+35:::DECIMAL),('a20d2dc7-d2f7-475e-9cbe-94a2adc16b1b':::UUID, e'{"<\\"1SS$iBYcM(": [[[], [], 0.16202838652349025], [[], [[]]]], "a": {}, "bar": [], "foo": {"c": [], "cT\\"bN\'8:": {}}}':::JSONB, '0102000080040000007C8E61048945DBC1F686DABEC680F6C174D225A0C3F3F7C1BC620995ABCAFC41B86B60F063F4FF41609F4F8A786DE041CC7A40B567E7E8C1B006A7C9A13802421BF6E2520DA8F8C1F9B4B3CC9292F7C1E6FCAF1327A8F241F0636DEC29DEEE41':::GEOMETRY, 0.08211124986298650384:::DECIMAL)],
'[[[{}, null], 1.327247159715561, [{"_#R1dD=": 0.16081188451579354}, [[], {"b": "{&j}6,/r<"}, {}]], [0.4907870578865293], true]]':::JSONB
),
(
CASE
WHEN false
THEN ARRAY[('83461811-1670-4d8c-8142-8a84fb31f8e7':::UUID, '{"K/Q8``5-T#": {"3]N0Leo": {"[s~RqhY.,mbx": {}}, "foo": null}, "^{[p(": [], "bar": [], "baz": {"baz": [null, "a"]}, "foo": [[{"foo": {}}]]}':::JSONB, '01030000C00100000006000000B59DEBF72758F0C13C2AE191E64DE5C1A80AC4148779DC41402C98E930ECFBC13EFECEE2A4EFF6C10CBC0085F31F01C210F0DA2E2692DE415C7180AC1D6FF441AE61C3B05ADAE1C197230C82166301C254CFA0334E0FF7C106576376FE90F3C1381158775E19E2414CB10A7E96B8EE4158730E8BD323D3C1EC24D53E73DCDAC13453E537E565EFC1E6791F27B462004238F938F52827E2415E41F9CB25ECF5C1B59DEBF72758F0C13C2AE191E64DE5C1A80AC4148779DC41402C98E930ECFBC1':::GEOMETRY, (-58084135056.50295895):::DECIMAL),('615fc5d0-7477-4120-a4ad-deb17bda330e':::UUID, '[null, {"g{bD{K_3(A": {"foobar": "a"}}, {"MR,": {"3ps": {}}, "baz": [], "c": 0.09576233010142915}, [{}], {}]':::JSONB, '01010000407855830D6A06FE41C47C32E523E7F8C1C6E3F3778801F0C1':::GEOMETRY, 5.897230484081073249E+20:::DECIMAL)]
ELSE ARRAY[]:::RECORD[]
END,
NULL
),
(
ARRAY[('2b2b0b4b-bc7a-4fc3-b1c9-93bf85a8c499':::UUID, '[{"nZo": {"bar": [], "c": {"baz": {}}, "fDEc": {"a": [{}], "baz": [], "foo": [{}]}, "nyW!": {}}}, "^jNV", {"foo": {"b": {}}}, 0.5403298272955117]':::JSONB, '01060000C00900000001030000C001000000090000008563CA34B46502C268105F5058C3DA417BA9C7D5B84BFFC150AF5AD0410AEFC16D581FD3C89CF0C1940901F22E05DDC1A030A9050D85CDC1047867428CEAFB41C011ED52BE57D8C154490B55FA45EDC15076B681E727D641E8B88C95352DE2417E71555A1A4200420C0CCFC67C02ECC1D4E30FD4ADE501C2BEDF2888866BF241DC00F8990B7EEA417CDD9858C112004269DDA5A74CF201C270E30EEDF161E1C128116A072A23D6410A1B929FF8ADF941A49644F51BAAE641E00813456665FB412041C3AB1B84B8C162434EEB45C6F14168F163A00470ED41DC992D22C34FFC41E0C481E55542D5C178D490C27ADCF941CCACF2A8DFC5FF417BDA48DE89A4F0C18563CA34B46502C268105F5058C3DA417BA9C7D5B84BFFC150AF5AD0410AEFC101030000C0010000000C000000787756EBB320F8C148FD8D1C6939DAC15857893FC295EC41D72599ACBA4AF3C14007053FEFF8E541CEEC3BFC3A54ECC1E4726AC9B1F9D7C1EC238CCFDC3AE9C154331736DE3EE541000868303F6D68C1941AC49A4DEE014244037CCFE7F2F5C154512FB23DE5FC414CE623EEB98CD9C1C4E328A99C62F241485BBC3117AED2C1F4530A34BB72E641D873A581D932DB4174C7C5907B45F4C1DC71BC4562BDE5C1A820C1BBDCA9F34140C1EE462C7BD641103A7C09A5F0F1C1B828EE23053CF941DC5F52731A46E5419E9C790F35E2F741602D789D4E01EC41C091361FED380142D8F050CEDD4ADB4162FF54ACC31F0142AC9D180ADFE5EF41B602D550C33E00428DFE6FD3E298F8C134728879D889FF41CB17FBB9D2C3F0C16055969955C1C4C1A031B3033DB101C2B6AC2F8D3381004257C607455C3CF6C1A082FFFAA0FEB7C1217CC44A234200C218D65FAD4E2DEA4176A61348045400423808E9119A95FAC1787756EBB320F8C148FD8D1C6939DAC15857893FC295EC41D72599ACBA4AF3C101030000C0010000000A00000038F643E0A6ADEBC112E475D6C725EAC1406638864BE4E2C1A0B996DA17B8CCC18EC4EA609E55E8C1F1E12A067E97FDC17ABDEA5DA9A7F9C135D8A34004D0F4C1609033F9686CCEC11ECDDFA1255BF2C10222E3C79903FBC100B66E96207B7541504959A9D89AC0C15F359130B07E00C2FAF6A06A7ACEE6C1203063354A6ACE4140D99E8E1334B941EE2C37697AD8EBC1422271A26FADEEC13BC8F62D426D01C2C8981647B113E34132BBBC22C646F6C158385EF3624BFBC13844298281940142005A68CC6A64B7410021D6B9F1F4D0C1B0790F7CC9ADC24128D9FCEC73B3F6416024DFC0AD2CD841AA94673AD07B02428AD34E37C67CF1C1BEC42672CF9CF7C114D543E0BC82D6C14852690D450AE241FEA6B23B91DDEDC16BE183D474B201C238F643E0A6ADEBC112E475D6C725EAC1406638864BE4E2C1A0B996DA17B8CCC101030000C001000000050000009A306C8045A7E6C176DB6FBEA10EF7C1D063EFE5937ED64176B683336D2201C23AF68C7AB0820142B8F167ED181CDAC14558B12CC374FCC100A892820EFB63C150DFDC6FF85CC1C140CDCB9655E9ABC1081BBA570C1AD9C18913D2B3CE4900C2D554E02A176FF8C1344A21F631CEE2415028B1C950D9DC4170C4F5A3FC1BD3C19A306C8045A7E6C176DB6FBEA10EF7C1D063EFE5937ED64176B683336D2201C201030000C001000000040000002670C9EABC9FFDC138541F826A54EAC1BA3D6177A3A8F74104B27EF4A6B2ED41F8B90B6CA489ED419F3D3FAD3205F3C140D9B9E84ABCF1C1BC07F72585390242AA6394440198E4C1ACC88D4DD932EB41E0C044108417B4C180F559F60F4895C12670C9EABC9FFDC138541F826A54EAC1BA3D6177A3A8F74104B27EF4A6B2ED4101030000C0010000000A00000068793B8FF09AF4C160E4ED915793C6C1E42E5AA4C824FD41308BDA5E1A21E741683B8FE757BEE24109880B9F1BCE00C200A18B55FD6A8EC1D6DBCB38E9BDF741305D6FA1192AD341D9153C51555BF1C145820CA8C3E4F1C1824E45E14101F741E44F3169E287E5417C4B86AE67DEF94100307C0967B2FE415ECF464718EBF5C1E0058FE93922D641C8E242B808D0FF413823B1AF6128EA41C8814114A465FE4134A880616DCEE7C17C8D6D08E895EB4142E47973391A004202997F930895E6C1DA681D9D84E0F5C18CCA79AC5414FC41307381411C67F341CE84313ED38F0242FCD0DA210447F7C1CC84D97921B5F241C07DBE4540FDFF4154D8D92EFB1AFB415395D6F3D6B4FFC18CCA3B11CD28E14180B60A2E4736B54177E14F56F9D5F8C168793B8FF09AF4C160E4ED915793C6C1E42E5AA4C824FD41308BDA5E1A21E74101030000C00100000005000000C5FE5FBF9A3BF6C1A3C744218476F6C161F25DD1E959FAC1A8DC96C23C87D741B0E961033F20E041425C61D5BFE1FAC11851CD595B21E2C157E88BC3D3DC01C2CE4215CE48860242E862EFB3BF35F9C1C089B2041259B8C120865FA87A75EAC1686D33187CA1E341BA3C3FD379C3F741E0A0FAA0BDB90042F48AA5E4DAA5E2C1C5FE5FBF9A3BF6C1A3C744218476F6C161F25DD1E959FAC1A8DC96C23C87D74101030000C001000000040000007E3AE29126F7F9416EA29FD2614300C25292033F312D01428242DDBF8595F9C14C8EA61CA28EED412000452F0A0CB1C120743C9F9321F041DDA4FEC5F37CF1C160B158D6877CC3410610113835CFE0C1AC1389E3739E00C2A04E04D8CE6ECC417E3AE29126F7F9416EA29FD2614300C25292033F312D01428242DDBF8595F9C101030000C0010000000C0000000BC8FC56F12201C21B615B7F07E7F0C1204415BAB599C841E44BFA9DE1FCE0C1CC07A21D4E37E8C16F1909D61FBAF0C1A30A1B449646F6C11826D28E4E1AF6C14210C9962E4402C2922073C6C95301C2D8384387DEA6ECC15CC86C56AD33D7C140106A191E64A5415432E208F57700C2D0FCB9AC54BFDC4140882C3726A2D64126DBF762947CF241F10EF557B3A001C2EE81EF4FD6D001C21071A6598D87D141AC37514A1952F241DF5620635E6C01C2F0F5DB220B2EE74152400EC319780142CCDFF855F0F8F541897360C1BD9B02C200A2120BF52EE141081C511CCE9CF241AC66CC5579F2E6419027AC4416C9D4C170E996CB4F55F5C13C2A4A22AE9EF141043D711BF9B6E14120C127BCC58FCEC19B82A4445323FCC1E3D2430411AAF3C14072FCB9DCD2FA41AE4DFF8C96C0F641F0F3534D5D8EFE41C4FDB3B3364BEB418A0B6DCF94B0F4C1C4CDF1FBCB9EF341F845BC84C40DE8419E3500A8763EF5410BC8FC56F12201C21B615B7F07E7F0C1204415BAB599C841E44BFA9DE1FCE0C1':::GEOMETRY, 68680790046.46325024:::DECIMAL),(NULL, e'{"\\" >#(txu": 2.4982958950087797, "\\\\t6Nr\\\\": "LfiSk.1as&b", "bar": [{"b": [[[0.10736194183875679]]], "bar": [], "foobar": [{"foo": {}}]}, {"b": {}}, null, 3.0101136349794455]}':::JSONB, '010400008000000000':::GEOMETRY, 1607.685895948769594:::DECIMAL)],
NULL
)
)
AS tab_201406 (col_489907, col_489908)
)
SELECT
'fece5a56-74d3-4735-bdb3-457571c9ef58':::UUID AS col_489915
FROM
defaultdb.public.table1@table1_col1_10_expr_expr1_idx AS tab_201407,
(
SELECT
tab_201408.col1_14 AS col_489909, tab_201408.col1_11 AS col_489910, tab_201408.tableoid AS col_489911
FROM
defaultdb.public.table1@[0] AS tab_201408
LIMIT
63:::INT8
)
AS tab_201409 (col_489912, col_489913, col_489914)
ORDER BY
tab_201407.col1_3, tab_201407.col1_10 ASC
LIMIT
32:::INT8;
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Type
Projects
Status
Done