-
Notifications
You must be signed in to change notification settings - Fork 4.1k
optbuilder: do not add invalid casts when building COALESCE and IF expressions #76807
Copy link
Copy link
Closed
Closed
Copy link
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.
Description
roachtest.sqlsmith/setup=empty/setting=no-mutations failed with artifacts on master @ 8d0a1773a6b55f06c04ea77e6a39426e32ba9a63:
The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/sqlsmith/setup=empty/setting=no-mutations/run_1
sqlsmith.go:258,sqlsmith.go:297,test_runner.go:779: error: pq: internal error: no volatility for cast tuple[]::tuple{time, geometry, string}[]
stmt:
SELECT
COALESCE(tab_122453.col_211191, ARRAY[]:::RECORD[]) AS col_211192
FROM
(
VALUES
(
ARRAY[('17:29:27.046424':::TIME, '01030000C0010000000B00000065074F19CA9500C20E0D976B0B86FDC1E8D8636A337CE641B0FB9A2C8646C5415C6515182169E7418AD13F8E6564FCC1886A5D7A9C4AED41FCF1181C2B8F0142A0F17E06C8E4E541B1823EE4D759F3C1007EFE8DAF29004280BB8A5E25A2BD41A22E19D05CF0F441E041A15F52C4FAC1985DA1A903C0DF4134597CE469B5FAC1303E3A98567B00428C1442110BBEE7C158B61C1EE441D3C100CD2316FFFF86410C31454101D4FF410AF22673FA3AE3C1382F38FB12FF0142F843C719AE03FD41C052C33BCE1CA741C6B98AF63609F141D07B6DC9ABC6FD41C0F0F1ED1CCFCD4100443D0544A372C1D2963E5323F8F041186013FCC490F6C1776DA7CEA637F0C18059A804E0DE9AC1B00FF66A9F0CC5C10AE98B7DBBA300C20AFE245A5E8302C24ADAE2475CE0ECC1F05E31A68B44DFC195C67B65FE2002C25C630C31926BEBC165074F19CA9500C20E0D976B0B86FDC1E8D8636A337CE641B0FB9A2C8646C541':::GEOMETRY, '':::STRING)]
),
(NULL)
)
AS tab_122453 (col_211191)
LIMIT
67:::INT8;
This test on roachdash | Improve this report!
Jira issue: CRDB-13281
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.
Type
Projects
Status
Done