Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

roachtest: sqlsmith/setup=empty/setting=no-mutations failed #81277

Closed
cockroach-teamcity opened this issue May 15, 2022 · 3 comments · Fixed by #81406
Closed

roachtest: sqlsmith/setup=empty/setting=no-mutations failed #81277

cockroach-teamcity opened this issue May 15, 2022 · 3 comments · Fixed by #81406
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented May 15, 2022

roachtest.sqlsmith/setup=empty/setting=no-mutations failed with artifacts on master @ bc5f5b7159ed2b7dbffa94bb2a590fdddb642b9b:

								('\x7702':::BYTES),
								('\x3fd9d8a9c9b9f5c8ed':::BYTES),
								('\xc349e9069b':::BYTES)
						)
							AS tab_136025 (col_227743)
				),
			with_38383 (col_227744, col_227745)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									'010500000000000000':::GEOMETRY,
									'{"a": {"B*sk|vlq": true, "f6buVm": [[], {"(LS8b": {}, "j[]iSpi": true}], "foo": [{"b": false}, []]}, "bar": null, "c": true}':::JSONB
								),
								(
									st_minimumboundingcircle(st_makepoint((-0.23349138300862382):::FLOAT8::FLOAT8, ((-1.0):::FLOAT8::FLOAT8 ^ (0.7478831141483115:::FLOAT8::FLOAT8 - (-0.062142024476064206):::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::GEOMETRY,
									'[true, {"a": {"ZV2T_KN": []}, "foobar": []}, {"c": false}, [1.4407608468202096], {"X7_2SmuO=q": [[]]}]':::JSONB
								),
								(
									'0101000080F896EDA7FF6EE4C1FC7BF405D183E441902EAAAEB748D0C1':::GEOMETRY,
									e'{"Qxj$": {"a": {}}, "b": {"V5_\\"C@jc~[.$": {}, "foobar": false}, "foo": [2.193271513563844]}':::JSONB
								),
								(
									'01020000C000000000':::GEOMETRY,
									crdb_internal.merge_transaction_stats((ARRAY['null':::JSONB,'[false]':::JSONB,e'{"foobar": [{"M^$Z09PImhIF": 1.7192104641194141, "Yc{\\\\WEf?\'@<": "iT4dRY|c%y^e", "uQ1H\\"": null}]}':::JSONB]::JSONB[] || ARRAY[e'{"L/d/": true, "bar": [], "j_wh\\\\2GX": 0.4229204572322349}':::JSONB,e'[[], {"b": false, "gzUL": {"\\"HHs-hF}W*I": [], "baz": []}}, [["r<RVshZ6Ih$"], [{"]1SjgK": null}]], {"}Sn": []}, {}, {}]':::JSONB,e'{"JFpykfsN": {}, "foo": {"\\"=^H": {}, "a": [true]}, "w%-&.5P_5Jr": {}, "yuDh*[.TXEE9": []}':::JSONB,'{"test": "json"}':::JSONB]::JSONB[])::JSONB[]::JSONB[])::JSONB
								)
						)
							AS tab_136026 (col_227744, col_227745)
				)
		SELECT
			cte_ref_11166.col_227744 AS col_227747,
			tab_136027.col_227746 AS col_227748,
			e'{"1K8|U8bj": false, "HF)$oh\\"!tF": [], "bar": [], "baz": 0.3188577699455518, "c": "b", "foobar": [[{}]], "yyn8Jf6yq{": []}':::JSONB
				AS col_227749
		FROM
			with_38383 AS cte_ref_11166,
			(
				VALUES
					('-71 years -7 mons -248 days -02:45:28.091542':::INTERVAL),
					(
						('31 years 5 mons 373 days 08:01:15.497272':::INTERVAL::INTERVAL / 1420301010249512559:::INT8::INT8)::INTERVAL
					),
					(NULL)
			)
				AS tab_136027 (col_227746)
		ORDER BY
			cte_ref_11166.col_227744 DESC, tab_136027.col_227746 DESC;
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-15258

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels May 15, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label May 15, 2022
@michae2
Copy link
Collaborator

michae2 commented May 17, 2022

The horrible beast and the stacktrace it produced:

> WITH
	with_38382 (col_227743)
		AS (
			SELECT
				*
			FROM
				(
					VALUES
						('\x2f334928':::BYTES),
						('\x7702':::BYTES),
						('\x3fd9d8a9c9b9f5c8ed':::BYTES),
						('\xc349e9069b':::BYTES)
				)
					AS tab_136025 (col_227743)
		),
	with_38383 (col_227744, col_227745)
		AS (
			SELECT
				*
			FROM
				(
					VALUES
						(
							'010500000000000000':::GEOMETRY,
							'{"a": {"B*sk|vlq": true, "f6buVm": [[], {"(LS8b": {}, "j[]iSpi": true}], "foo": [{"b": false}, []]}, "bar": null, "c": true}':::JSONB
						),
						(
							st_minimumboundingcircle(st_makepoint((-0.23349138300862382):::FLOAT8::FLOAT8, ((-1.0):::FLOAT8::FLOAT8 ^ (0.7478831141483115:::FLOAT8::FLOAT8 - (-0.062142024476064206):::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::GEOMETRY,
							'[true, {"a": {"ZV2T_KN": []}, "foobar": []}, {"c": false}, [1.4407608468202096], {"X7_2SmuO=q": [[]]}]':::JSONB
						),
						(
							'0101000080F896EDA7FF6EE4C1FC7BF405D183E441902EAAAEB748D0C1':::GEOMETRY,
							e'{"Qxj$": {"a": {}}, "b": {"V5_\\"C@jc~[.$": {}, "foobar": false}, "foo": [2.193271513563844]}':::JSONB
						),
						(
							'01020000C000000000':::GEOMETRY,
							crdb_internal.merge_transaction_stats((ARRAY['null':::JSONB,'[false]':::JSONB,e'{"foobar": [{"M^$Z09PImhIF": 1.7192104641194141, "Yc{\\\\WEf?\'@<": "iT4dRY|c%y^e", "uQ1H\\"": null}]}':::JSONB]::JSONB[] || ARRAY[e'{"L/d/": true, "bar": [], "j_wh\\\\2GX": 0.4229204572322349}':::JSONB,e'[[], {"b": false, "gzUL": {"\\"HHs-hF}W*I": [], "baz": []}}, [["r<RVshZ6Ih$"], [{"]1SjgK": null}]], {"}Sn": []}, {}, {}]':::JSONB,e'{"JFpykfsN": {}, "foo": {"\\"=^H": {}, "a": [true]}, "w%-&.5P_5Jr": {}, "yuDh*[.TXEE9": []}':::JSONB,'{"test": "json"}':::JSONB]::JSONB[])::JSONB[]::JSONB[])::JSONB
						)
				)
					AS tab_136026 (col_227744, col_227745)
		)
SELECT
	cte_ref_11166.col_227744 AS col_227747,
	tab_136027.col_227746 AS col_227748,
	e'{"1K8|U8bj": false, "HF)$oh\\"!tF": [], "bar": [], "baz": 0.3188577699455518, "c": "b", "foobar": [[{}]], "yyn8Jf6yq{": []}':::JSONB
		AS col_227749
FROM
	with_38383 AS cte_ref_11166,
	(
		VALUES
			('-71 years -7 mons -248 days -02:45:28.091542':::INTERVAL),
			(
				('31 years 5 mons 373 days 08:01:15.497272':::INTERVAL::INTERVAL / 1420301010249512559:::INT8::INT8)::INTERVAL
			),
			(NULL)
	)
		AS tab_136027 (col_227746)
ORDER BY
	cte_ref_11166.col_227744 DESC, tab_136027.col_227746 DESC;
fatal error: unexpected signal during runtime execution
[signal SIGSEGV: segmentation violation code=0x1 addr=0xce pc=0x7f5b249a6f22]

runtime stack:
runtime.throw({0x4ffdd27, 0x7f5b188257a0})
	GOROOT/src/runtime/panic.go:1198 +0x71
runtime.sigpanic()
	GOROOT/src/runtime/signal_unix.go:719 +0x396

goroutine 1203 [syscall]:
runtime.cgocall(0x4112b55, 0xc000d499e8)
	GOROOT/src/runtime/cgocall.go:156 +0x5c fp=0xc000d499b0 sp=0xc000d49978 pc=0x4484fc
github.com/cockroachdb/cockroach/pkg/geo/geos._Cfunc_CR_GEOS_MinimumBoundingCircle(0x7f5b19e33000, {0xc006794700, 0x15}, 0xc005c628e0, 0xc005a1a6c0, 0xc005a1a6d0)
	github.com/cockroachdb/cockroach/pkg/geo/geos/_cgo_gotypes.go:576 +0x4e fp=0xc000d499e8 sp=0xc000d499b0 pc=0x10727ee
github.com/cockroachdb/cockroach/pkg/geo/geos.MinimumBoundingCircle.func1(0x7f5b19e33000, {0xc006794700, 0xc000d49ab8, 0x0}, 0x2, 0x66567d8, 0xc002240800)
	/home/michae2/.cache/bazel/_bazel_michae2/88dadb79cb9eca13f5ad7e068969d8c1/sandbox/linux-sandbox/3588/execroot/com_github_cockroachdb_cockroach/pkg/geo/geos/geos.go:456 +0xdd fp=0xc000d49a60 sp=0xc000d499e8 pc=0x10778dd
github.com/cockroachdb/cockroach/pkg/geo/geos.MinimumBoundingCircle({0xc006794700, 0x15, 0x40})
	/home/michae2/.cache/bazel/_bazel_michae2/88dadb79cb9eca13f5ad7e068969d8c1/sandbox/linux-sandbox/3588/execroot/com_github_cockroachdb_cockroach/pkg/geo/geos/geos.go:456 +0xb9 fp=0xc000d49ae8 sp=0xc000d49a60 pc=0x10776b9
github.com/cockroachdb/cockroach/pkg/geo/geomfn.MinimumBoundingCircle({{0x2, {0xc006794700, 0x15, 0x40}, 0x0, 0x1, 0xc0070d2c20}})
	github.com/cockroachdb/cockroach/pkg/geo/geomfn/topology_operations.go:51 +0x105 fp=0xc000d49c40 sp=0xc000d49ae8 pc=0x10b3605
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.glob..func616(0x6639f78, 0xc001212c00)
	github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/geo_builtins.go:6651 +0x89 fp=0xc000d49d78 sp=0xc000d49c40 pc=0x1a7cee9
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.geometryOverload1.func1(0x1404c4f, {0xc005a1a6b0, 0x6639b88, 0xc004e01bf0})
	github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/geo_builtins.go:7038 +0x5c fp=0xc000d49db0 sp=0xc000d49d78 pc=0x1a1b0dc
github.com/cockroachdb/cockroach/pkg/sql/sem/eval.(*evaluator).EvalFuncExpr(0xc001b9cfc8, 0xc002240f80)
	github.com/cockroachdb/cockroach/pkg/sql/sem/eval/expr.go:421 +0xd6 fp=0xc000d49f68 sp=0xc000d49db0 pc=0x1714f36
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).Eval(0x921dc00, {0x672c248, 0xc001b9cfc8})
	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/sem/tree/eval_expr_generated.go:256 +0x2d fp=0xc000d49f88 sp=0xc000d49f68 pc=0x140c2ad
github.com/cockroachdb/cockroach/pkg/sql/sem/eval.Expr(...)
	github.com/cockroachdb/cockroach/pkg/sql/sem/eval/expr.go:23
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*CustomFuncs).FoldFunction(0xc001b9d5d8, {0xc005a1a680, 0x1, 0xc004e01c50}, 0xc000d4a178)
	github.com/cockroachdb/cockroach/pkg/sql/opt/norm/fold_constants_funcs.go:611 +0x1b2 fp=0xc000d4a010 sp=0xc000d49f88 pc=0x1dc4392
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructFunction(0xc001b9d5c8, {0xc005a1a680, 0x1, 0x1}, 0xc000d4a178)
	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:19888 +0x17a fp=0xc000d4a068 sp=0xc000d4a010 pc=0x1e4bc5a
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFunction(0xc0014af4a0, 0xc002240980, 0xc00a2b58f8, 0x6689090, 0x663a200, 0x1000500000000)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:544 +0x1a5 fp=0xc000d4a1f0 sp=0xc000d4a068 pc=0x22f8f05
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildScalar(0xc0014af4a0, {0x66567d8, 0xc002240980}, 0xc00a2b58f8, 0xc005c62720, 0x7, 0xc005c62720)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:323 +0x1065 fp=0xc000d4a608 sp=0xc000d4a1f0 pc=0x22f66a5
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildValuesClause(0xc0014af4a0, 0xc00a70b890, {0x0, 0x0, 0xc00a2b7688}, 0xc00a2b58f8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/values.go:93 +0xb12 fp=0xc000d4a800 sp=0xc000d4a608 pc=0x2317e32
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens(0x4c13940, {0x6656e50, 0xc00a70b890}, {0x0, 0x0, 0x0}, 0x0, {0x0, 0x0, 0x0}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:937 +0x1b9 fp=0xc000d4a8e8 sp=0xc000d4a800 pc=0x2309f59
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1(0xc0014af4a0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:902 +0x87 fp=0xc000d4a970 sp=0xc000d4a8e8 pc=0x2309d67
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths(0xc009e51960, 0xc000d4aa58, 0x80, 0xc000d4aae8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:115 +0x63 fp=0xc000d4a9e8 sp=0xc000d4a970 pc=0x231ce83
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect(0xc0014af4a0, 0x0, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, 0x0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:901 +0x5ab fp=0xc000d4ab58 sp=0xc000d4a9e8 pc=0x2309b8b
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmt(0x0, {0x6656b38, 0xc008f9c498}, {0x0, 0xc006349ac0, 0xc000d4ac90}, {0x0, 0xc006abc8d0, 0x65761e0}, 0xc00a2b58f8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:836 +0x11a fp=0xc000d4abd8 sp=0xc000d4ab58 pc=0x23094ba
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc0014af4a0, {0x65b3920, 0xc0012123f0}, 0xc00a70779b, {0x0, 0x1, 0xc00a2b59f0}, 0xc00a2b58f8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:149 +0x10bc fp=0xc000d4b1a0 sp=0xc000d4abd8 pc=0x23046fc
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc0014af4a0, {0x65b3200, 0xc0040c7040}, 0xc005a1a650, {0x0, 0x0, 0x1}, 0xc00a2b58f8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:61 +0x121d fp=0xc000d4b768 sp=0xc000d4b1a0 pc=0x230485d
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep(0xc0014af4a0, {0xc005a1a460, 0x1, 0x1}, {0x0, 0x0, 0x0}, 0x0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1156 +0x8d fp=0xc000d4b7f8 sp=0xc000d4b768 pc=0x230b22d
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTables(0x1, {0xc005a1a460, 0xc00a2b59f0, 0xc000d4b8c0}, {0x0, 0x66559c8, 0xc00a28dc30}, 0xc00a2b59f0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1133 +0xb8 fp=0xc000d4b848 sp=0xc000d4b7f8 pc=0x230b138
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFrom(0xc0014af4a0, {{0xc005a1a460, 0x1, 0x1}, {{0x0, 0x0}}}, {0x0, 0xc000d4b998, 0x0}, 0xc00a2b58f8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1060 +0x249 fp=0xc000d4b8d0 sp=0xc000d4b848 pc=0x230ac29
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause(0xc008170fe0, 0xc0073cfd60, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, {0x0, 0x0, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:981 +0xe5 fp=0xc000d4b9c0 sp=0xc000d4b8d0 pc=0x230a4e5
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens(0x13b5c1e, {0x6656c10, 0xc0073cfd60}, {0x0, 0x0, 0x0}, 0x0, {0x0, 0x0, 0x0}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:929 +0x23b fp=0xc000d4baa8 sp=0xc000d4b9c0 pc=0x2309fdb
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1(0x0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:902 +0x87 fp=0xc000d4bb30 sp=0xc000d4baa8 pc=0x2309d67
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths(0xc0012129f0, 0xc00a73ad20, 0xc000d4bbf0, 0xc000d4bca8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:115 +0x63 fp=0xc000d4bba8 sp=0xc000d4bb30 pc=0x231ce83
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect(0xc0014af4a0, 0x4, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, 0x0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:901 +0x5ab fp=0xc000d4bd18 sp=0xc000d4bba8 pc=0x2309b8b
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt(0xc0014af4a0, {0x664e978, 0xc0040c7090}, {0x0, 0x0, 0x0}, 0x1)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:282 +0x39b fp=0xc000d4bdf8 sp=0xc000d4bd18 pc=0x22c93fb
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildCTE(0xc0014af4a0, 0xc006536100, 0xc005c62740, 0xa)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:194 +0x645 fp=0xc000d4c080 sp=0xc000d4bdf8 pc=0x231de05
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildCTEs(0xc0014af4a0, 0xc008170e40, 0xc00a2b5800)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:139 +0x285 fp=0xc000d4c260 sp=0xc000d4c080 pc=0x231d1c5
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths(0x96fe140, 0xc000d4c310, 0x64fc89, 0xc000d4c3d8)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:112 +0x2a fp=0xc000d4c2d8 sp=0xc000d4c260 pc=0x231ce4a
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect(0xc0014af4a0, 0x0, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, 0x400)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:901 +0x5ab fp=0xc000d4c448 sp=0xc000d4c2d8 pc=0x2309b8b
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt(0xc0014af4a0, {0x664e978, 0xc0040c73b0}, {0x0, 0x0, 0x0}, 0x0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:282 +0x39b fp=0xc000d4c528 sp=0xc000d4c448 pc=0x22c93fb
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot(0xc0014af4a0, {0x664e978, 0xc0040c73b0}, {0x0, 0x0, 0x0})
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:242 +0x1a5 fp=0xc000d4c5a0 sp=0xc000d4c528 pc=0x22c8f65
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build(0xc0014af4a0)
	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:216 +0x225 fp=0xc000d4c648 sp=0xc000d4c5a0 pc=0x22c8c05
github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo(0xc001b9d568, {0x661e368, 0xc001212810})
	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:542 +0x50f fp=0xc000d4c758 sp=0xc000d4c648 pc=0x302522f
github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan(0xc001b9cd08, {0x661e368, 0xc001212810})
	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:215 +0xf7 fp=0xc000d4c808 sp=0xc000d4c758 pc=0x3023f57
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan(0xc001b9c600, {0x661e368, 0xc001212810}, 0xc001b9cd08)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1350 +0x4e fp=0xc000d4c8b0 sp=0xc000d4c808 pc=0x2f2b7ae
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc001b9c600, {0x661e368, 0xc001212810}, 0xc001b9cd08, {0x7f5b2495c208, 0xc0012cf140})
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1041 +0x24e fp=0xc000d4cc28 sp=0xc000d4c8b0 pc=0x2f2968e
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc001b9c600, {0x661e2c0, 0xc006536980}, {{0x664e978, 0xc0040c73b0}, {0xc00a707094, 0x977}, 0x0, 0x1}, 0x0, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:688 +0x20b1 fp=0xc000d4d508 sp=0xc000d4cc28 pc=0x2f25f11
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc001b9c600, {0x661e2c0, 0xc006536980}, {{0x664e978, 0xc0040c73b0}, {0xc00a707094, 0x977}, 0x0, 0x1}, 0x0, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:145 +0x59e fp=0xc000d4d778 sp=0xc000d4d508 pc=0x2f22fbe
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1({{{0x664e978, 0xc0040c73b0}, {0xc00a707094, 0x977}, 0x0, 0x1}, {0x3317bed7, 0xeda15227e, 0x0}, {0x3317c5f1, ...}, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1886 +0x2f6 fp=0xc000d4d830 sp=0xc000d4d778 pc=0x2f18cd6
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc001b9c600)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1890 +0xb08 fp=0xc000d4dcc8 sp=0xc000d4d830 pc=0x2f172a8
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc001b9c600, {0x661e2c0, 0xc001690600}, 0xc002370d80, {0x5400, 0x15000, 0xc002379440, 0x0, 0x0}, 0xc003c101d0)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1812 +0x26c fp=0xc000d4dd98 sp=0xc000d4dcc8 pc=0x2f163ac
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0x661e2c0, {0x661e2c0, 0xc001690600}, {0x3}, {0x5400, 0x15000, 0xc002379440, 0x0, 0x0}, 0xc003c101d0)
	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:752 +0xf7 fp=0xc000d4de38 sp=0xc000d4dd98 pc=0x2f11eb7
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()
	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:724 +0x3b8 fp=0xc000d4dfe0 sp=0xc000d4de38 pc=0x3539cf8
runtime.goexit()
	GOROOT/src/runtime/asm_amd64.s:1581 +0x1 fp=0xc000d4dfe8 sp=0xc000d4dfe0 pc=0x4b0501
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync
	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:643 +0x273

@michae2
Copy link
Collaborator

michae2 commented May 17, 2022

Reduced:

SELECT st_minimumboundingcircle(
        st_makepoint(
          (-0.23349138300862382)::FLOAT8,
          (-1.0):::FLOAT8::FLOAT8 ^ (0.7478831141483115:::FLOAT8 - (0))::FLOAT8
        )
       );

@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label May 17, 2022
@rytaft rytaft removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label May 17, 2022
@rytaft
Copy link
Collaborator

rytaft commented May 17, 2022

Not a release blocker, but another st_minimumboundingcircle issue cc @otan

craig bot pushed a commit that referenced this issue May 18, 2022
80894: build,gcp: enable nightly config to run GCP unit tests r=adityamaru a=adityamaru

Previously, the `pkg/cloud/gcp` tests package was skipped on CI
because most of the tests require credentials, and we risked exfiltration
of these secrets when running on public teamcity agents.

With the ability to run tests on agents that are not part of the public
pool we now have a `Cloud Unit Test` config that runs these tests nightly.
This change adds the script invoked by the config and cleans up the unit
tests to be more uniform in their authentication and environment variable
checks.

Informs: #80877

Release note: None

81200: ui: Improve time picker keyboard input r=jocrl a=jocrl

Fixes #80655, mostly.

Previously, users had to type `1:03 PM (UTC)` in order to enter text into the time picker.

This commit modifies the time picker so that users would instead type either
- `1:03`, or
- `01:03`

to enter text into the time picker. Copying and re-pasting the text from a time picker still works.

Alternate approaches not pursued (these are not needed with the removal of AM/PM).

1) Make our own time picker component, and style it to look like antd's. There's
a general issue of antd's components not being keyboard friendly:
ant-design/ant-design#5685

2) Upgrade to `antd` version 4, and use an undocumented prop type. `antd`'s time
picker uses the time picker from the `rc-picker` library under the hood. In
`rc-picker`, the `format` prop is of type `String | String[]`, where if it's an
array the first value will be used for display and the remaining ones will be
used for parsing, as documented [here](https://react-component.github.io/picker). In theory, `antd` passes `format`
(and also any remaining, additional props in addition to the specified ones) to
the `rc-picker` component. So even though the `antd` `TimePicker` component
`format` prop is not documented to take in a string array, one might think that
passing in a string array anyway would work. In practice, passing in a string
array works in `antd` version `4.20.4`, as tested in the [antd sandbox](https://ant.design/docs/react/getting-started) 
(render `<TimePicker format={
["h:mm A", "h:mma"]}/>`). However, this does not work in our codebase
(which installs `antd` `v3.25.2`), or in the `antd` version `3.x` [sandbox](https://3x.ant.design/docs/react/getting-started). The errors that appear in
these two situations are different, and in a way demonstrate the potential for
breakage from using an undocumented feature in future upgrades from a version
that we've to work. If we do this, we should add a test.

3) Dead end: The `antd` `TimePicker` component takes an `onChange` prop with a
second `timeString` paramater. However, `onChange` only fires if the input is
of the correct, parsable format. The specific code that ignores text input that
is not of a parsable format is in `rc-picker`, [here](https://github.com/react-component/picker/blob/5306c8938aded49c5d6f6b6d4761ddab25e3cce9/src/Picker.tsx#L237).
This prevents us from being the one to do the fuzzy matching and passing the
value back to the component.

Release note (ui): The time picker component has been improved such that users
can use keyboard input to select a time without having to type `" (UTC)"`

81330: authors: add annrpom to authors r=annrpom a=annrpom

Release note: None

81406: geomfn: check NaN coordinates for ST_MinimumBoundingCircle r=rafiss a=otan

Resolves #81277

Release note (bug fix): Fix a bug where ST_MinimumBoundingCircle with
NaN coordinates could panic.

Co-authored-by: Aditya Maru <[email protected]>
Co-authored-by: Josephine Lee <[email protected]>
Co-authored-by: Annie Pompa <[email protected]>
Co-authored-by: Oliver Tan <[email protected]>
@craig craig bot closed this as completed in #81406 May 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) T-sql-queries SQL Queries Team
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants