Skip to content

roachtest: sqlsmith failure could not find overload for st_dwithinexclusive #55675

@cockroach-teamcity

Description

@cockroach-teamcity

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@ab503e2fd708541e5e9ebb9a6f2651eda506f2ef:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:181,sqlsmith.go:211,test_runner.go:755: error: pq: internal error: could not find overload for st_dwithinexclusive
		stmt:
		SELECT
			'\x27':::BYTES AS col_36252,
			tab_14679._int2 AS col_36253,
			tab_14678.tableoid AS col_36254,
			tab_14678._inet AS col_36255,
			tab_14678._timestamp AS col_36256,
			tab_14679._string AS col_36257,
			tab_14679._bool AS col_36258,
			tab_14679._bool AS col_36259,
			7232820974290837299:::INT8 AS col_36260,
			tab_14678._enum AS col_36261,
			tab_14679.tableoid AS col_36262,
			0.8972772296191472:::FLOAT8 AS col_36263,
			tab_14678._interval AS col_36264,
			(-32768):::INT8 AS col_36265,
			tab_14679._jsonb AS col_36266
		FROM
			defaultdb.public.seed@[0] AS tab_14678, defaultdb.public.seed@[0] AS tab_14679
		WHERE
			((-0.7465414041412649):::FLOAT8 <= st_distance(st_geogfromwkb(tab_14678._bytes::BYTES, tab_14678._int2::INT8)::GEOGRAPHY::GEOGRAPHY, '0105000020E61000000100000001020000000600000034C5D88D6BE861404C4234EC259A55C0ACE2F00BFF78624044FFEB6C8C3030C038E263FE39934A40C43496FF73643340F0DABC4503CD3C40643A74D2576E48409421A4C9142842C0C04A7A832A340F40DD59E540C7AB63C0ACEA15A4216734C0':::GEOGRAPHY::GEOGRAPHY, tab_14678._bool::BOOL)::FLOAT8)
		LIMIT
			89:::INT8;

More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.branch-masterFailures and bugs on the master branch.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions