Skip to content

sqlsmith: missing PrivilegedAccessor on queries #45408

@rohany

Description

@rohany

The SQLSmith user should have priviledged access to avoid spurious failures like

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:170,sqlsmith.go:200,test_runner.go:741: error: pq: internal error: crdb_internal.get_zone_config(): PrivilegedAccessor not set
		stmt:
		SELECT
			tab_703._float8 AS col_1677,
			right(crdb_internal.get_zone_config(tab_703._int8::INT8)::BYTES::BYTES, 4433258680766353893:::INT8::INT8)::BYTES
				AS col_1678,
			'1979-09-26':::DATE AS col_1679,
			tab_700._bool AS col_1680,
			0.09389279037714005:::FLOAT8 AS col_1681,
			tab_700._float4 AS col_1682,
			'00000000-0000-0000-0000-000000000000':::UUID AS col_1683,
			8850213693.858240636:::DECIMAL AS col_1684,
			(tab_701._int2::INT8 << tab_701._int4::INT8)::INT8 AS col_1685
		FROM
			defaultdb.public.seed@[0] AS tab_700,
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_701,
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_702
			JOIN defaultdb.public.seed@seed__int8__float8__date_idx AS tab_703 ON (tab_702._uuid) = (tab_703._uuid)
		ORDER BY
			tab_700._inet ASC, tab_702._uuid, tab_703._inet ASC
		LIMIT
			17:::INT8;

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions