Skip to content

roachtest: sqlsmith/setup=empty/setting=no-ddl failed #70666

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.sqlsmith/setup=empty/setting=no-ddl failed with artifacts on master @ 85b1e92455eb2795043d71e5766b1b56dab308f2:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:223,sqlsmith.go:256,test_runner.go:777: error: pq: internal error: no volatility for cast tuple[]::tuple{bool, oid}[]
		stmt:
		WITH
			with_3812 (col_21047)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									CASE
									WHEN (NOT EXISTS (WITH with_3810 (col_21041, col_21042) AS (SELECT * FROM (VALUES (false, ARRAY[(false, 2877430437:::OID),(true, 4098811020:::OID),(false, 4085324570:::OID),(NULL, 2703524746:::OID),(true, 1836754810:::OID)]), (NULL, ARRAY[(true, 3574494101:::OID),(true, NULL)]), (true, ARRAY[(false, 0:::OID),(false, 1583278185:::OID),(true, 3335872398:::OID),(false, 2450990297:::OID),(NULL, 484929524:::OID),(false, NULL)]), (false, ARRAY[(true, NULL),(false, 1568156154:::OID),(false, 0:::OID),(false, 3923047891:::OID)])) AS tab_12183 (col_21041, col_21042) EXCEPT ALL SELECT * FROM (VALUES (true, ARRAY[]:::RECORD[])) AS tab_12184 (col_21043, col_21044)), with_3811 (col_21045) AS (SELECT * FROM (VALUES (NULL), ('<':::STRING)) AS tab_12185 (col_21045)) SELECT () AS col_21046 LIMIT 20:::INT8))
									THEN '-Infinity':::DECIMAL
									ELSE 653163848397567.3901:::DECIMAL
									END
								),
								(2.610413118241426851E+20:::DECIMAL),
								((-2214979573024621380):::DECIMAL),
								(231522579491.0706537:::DECIMAL),
								(NULL)
						)
							AS tab_12186 (col_21047)
					UNION
						SELECT
							*
						FROM
							(
								VALUES
									(4.082881729782187691E+21:::DECIMAL),
									(2.380684802253673780E+32:::DECIMAL),
									('-Infinity':::DECIMAL),
									((7.727257793041500160:::DECIMAL::DECIMAL * 1811330438472895214:::INT8::INT8)::DECIMAL),
									(NULL),
									('-Infinity':::DECIMAL)
							)
								AS tab_12187 (col_21048)
				)
		SELECT
			NULL AS col_21049;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

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