8000 roachtest: sqlsmith: `could not evaluate 0E-2019 as Datum type DDecimal` in distributed plan · Issue #148255 · cockroachdb/cockroach · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
roachtest: sqlsmith: could not evaluate 0E-2019 as Datum type DDecimal in distributed plan #148255
Closed
@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on release-24.3 @ f0f32529810b4baa01ed6d4a76215e5470ba3634:

					(
						VALUES
							(ARRAY[2141828275:::OID,649481565:::OID]),
							(
								ARRAY[3502115663:::OID,3292553393:::OID,199829212:::OID,451655504:::OID,240928821:::OID,2728316278:::OID]
							)
					)
						AS tab_1775 (col_4204)
		),
	with_731 (col_4205)
		AS (
			SELECT
				*
			FROM
				(
					VALUES
						(COALESCE(1596297232:::OID, 1720711024:::OID)),
						(
							CASE
							WHEN ((NOT true) AND false) THEN oid(1912529613:::OID::OID)::OID
							ELSE 1033860293:::OID
							END
						),
						(604182279:::OID),
						(1752219455:::OID),
						(NULL),
						(3026273529:::OID)
				)
					AS tab_1776 (col_4205)
		)
SELECT
	tab_1779._int8 AS col_4206,
	true AS col_4207,
	tab_1779._date AS col_4208,
	tab_1778._inet AS col_4209,
	tab_1777._timestamp AS col_4210,
	cbrt(tab_1777.crdb_internal_mvcc_timestamp::DECIMAL)::DECIMAL AS col_4211,
	log('Infinity':::DECIMAL::DECIMAL, 4205552323006297.639:::DECIMAL::DECIMAL)::DECIMAL AS col_4212,
	'\xc0':::BYTES AS col_4213,
	NULL AS col_4214,
	tab_1778._float8 AS col_4215
FROM
	defaultdb.public.seed@seed__int8__float8__date_idx AS tab_1777
	JOIN defaultdb.public.seed@seed__int8__float8__date_idx AS tab_1778
		JOIN defaultdb.public.seed@seed__int8__float8__date_idx AS tab_1779 ON
				(tab_1778.crdb_internal_origin_id) = (tab_1779._int4) ON
			(tab_1777.crdb_internal_origin_id) = (tab_1779._int8)
LIMIT
	76:::INT8;
test artifacts and logs in: /artifacts/sqlsmith/setup=seed/setting=no-mutations/run_1

Parameters:

  • arch=amd64
  • cloud=gce
  • coverageBuild=false
  • cpu=4
  • encrypted=false
  • runtimeAssertionsBuild=false
  • ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-51495

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.O-rsgRandom Syntax GeneratorT-sql-queriesSQL Queries Teambranch-release-24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3target-release-25.3.0

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0