Skip to content

optbuilder: do not add invalid casts when building COALESCE and IF expressions #76807

@cockroach-teamcity

Description

@cockroach-teamcity

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;
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-13281

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions