Sentry: optimizer.go:277: top-level relational expression cannot have outer columns: (252) (1) plan gist: AgICAgYC Wraps: (2) while executing: SELECT _._($1) Wraps: (3) Wraps: (4) assertion failure Wr...

This issue was auto filed by Sentry. It represents a crash or reported error on a live cluster with telemetry enabled. Sentry Link: [https://cockroach-labs.sentry.io/issues/7684526178/?referrer=webhooks_plugin](https://cockroach-labs.sentry.io/issues/7684526178/?referrer=webhooks_plugin) Panic Message: ``` optimizer.go:277: top-level relational expression cannot have outer columns: (252) (1) plan gist: AgICAgYC Wraps: (2) while executing: SELECT _._($1) Wraps: (3) Wraps: (4) assertion failure Wraps: (5) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).Optimize | pkg/sql/opt/xform/optimizer.go:277 | github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildRoutinePlanGenerator.func2 | pkg/sql/opt/exec/execbuilder/scalar.go:1288 | github.com/cockroachdb/cockroach/pkg/sql.(*routineGenerator).startInternal | pkg/sql/routine.go:332 | github.com/cockroachdb/cockroach/pkg/sql.(*routineGenerator).Start | pkg/sql/routine.go:282 | github.com/cockroachdb/cockroach/pkg/sql/rowexec.(*projectSetProcessor).nextInputRow | pkg/sql/rowexec/project_set.go:208 | github.com/cockroachdb/cockroach/pkg/sql/rowexec.(*projectSetProcessor).Next | pkg/sql/rowexec/project_set.go:302 | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Columnarizer).Next | pkg/sql/colexec/columnarizer.go:244 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*metadataHelper).next | pkg/sql/colexec/colexecjoin/joiner_util.go:376 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*metadataHelper).inputTwoNext | pkg/sql/colexec/colexecjoin/joiner_util.go:390 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoiner).consumeRightInput | pkg/sql/colexec/colexecjoin/crossjoiner.go:194 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoiner).Next | pkg/sql/colexec/colexecjoin/crossjoiner.go:102 | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*limitOp).Next | pkg/sql/colexec/limit.go:43 | github.com/cockroachdb/cockroach/pkg/sql/colexecop.(*noopOperator).Next | pkg/sql/colexecop/operator.go:476 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:153 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.constDecimalOp.Next | bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go:253 | github.com/cockroachdb/cockroach/pkg/sql/colexecop.(*noopOperator).Next | pkg/sql/colexecop/operator.go:476 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*BatchSchemaSubsetEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:223 | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*bufferOp).advance | pkg/sql/colexec/buffer.go:45 | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*caseOp).Next | pkg/sql/colexec/case.go:193 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:153 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecprojconst.projMultDecimalDecimalConstOp.Next | bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go:9368 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:153 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecprojconst.projDivDecimalDecimalConstOp.Next | bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go:12191 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:153 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.constInt64Op.Next | bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go:379 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:153 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbuiltins.(*defaultBuiltinFuncOperator).Next | pkg/sql/colexec/colexecbuiltins/builtin_funcs.go:45 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*simpleProjectOp).Next | pkg/sql/colexec/colexecbase/simple_project.go:114 | github.com/cockroachdb/cockroach/pkg/sql/colexecop.(*noopOperator).Next | pkg/sql/colexecop/operator.go:476 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:153 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.constDecimalOp.Next | bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go:253 | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*BatchSchemaSubsetEnforcer).Next | pkg/sql/colexec/colexecutils/operator.go:223 Wraps: (6) top-level relational expression cannot have outer columns: (252) Error types: (1) *safedetails.withSafeDetails (2) *safedetails.withSafeDetails (3) *colexecerror.notInternalError (4) *assert.withAssertionFailure (5) *withstack.withStack (6) *errutil.leafError -- report composition: *errutil.leafError: top-level relational expression cannot have outer columns: (252) optimizer.go:277: *withstack.withStack (top exception) *assert.withAssertionFailure *colexecerror.notInternalError *safedetails.withSafeDetails: while executing: SELECT _._($1) *safedetails.withSafeDetails: plan gist: AgICAgYC ``` <details> <summary>Stacktrace (expand for inline code snippets):</summary> [pkg/sql/colexec/colexecutils/operator.go#L222-L224](pkg/sql/colexec/colexecutils/operator.go#L222-L224) [bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go#L252-L254](bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go#L252-L254) [pkg/sql/colexec/colexecutils/operator.go#L152-L154](pkg/sql/colexec/colexecutils/operator.go#L152-L154) [pkg/sql/colexecop/operator.go#L475-L477](pkg/sql/colexecop/operator.go#L475-L477) [pkg/sql/colexec/colexecbase/simple_project.go#L113-L115](pkg/sql/colexec/colexecbase/simple_project.go#L113-L115) [pkg/sql/colexec/colexecbuiltins/builtin_funcs.go#L44-L46](pkg/sql/colexec/colexecbuiltins/builtin_funcs.go#L44-L46) [pkg/sql/colexec/colexecutils/operator.go#L152-L154](pkg/sql/colexec/colexecutils/operator.go#L152-L154) [bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go#L378-L380](bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go#L378-L380) [pkg/sql/colexec/colexecutils/operator.go#L152-L154](pkg/sql/colexec/colexecutils/operator.go#L152-L154) [bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go#L12190-L12192](bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go#L12190-L12192) [pkg/sql/colexec/colexecutils/operator.go#L152-L154](pkg/sql/colexec/colexecutils/operator.go#L152-L154) [bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go#L9367-L9369](bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go#L9367-L9369) [pkg/sql/colexec/colexecutils/operator.go#L152-L154](pkg/sql/colexec/colexecutils/operator.go#L152-L154) [pkg/sql/colexec/case.go#L192-L194](pkg/sql/colexec/case.go#L192-L194) [pkg/sql/colexec/buffer.go#L44-L46](pkg/sql/colexec/buffer.go#L44-L46) [pkg/sql/colexec/colexecutils/operator.go#L222-L224](pkg/sql/colexec/colexecutils/operator.go#L222-L224) [pkg/sql/colexecop/operator.go#L475-L477](pkg/sql/colexecop/operator.go#L475-L477) [bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go#L252-L254](bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go#L252-L254) [pkg/sql/colexec/colexecutils/operator.go#L152-L154](pkg/sql/colexec/colexecutils/operator.go#L152-L154) [pkg/sql/colexecop/operator.go#L475-L477](pkg/sql/colexecop/operator.go#L475-L477) [pkg/sql/colexec/limit.go#L42-L44](pkg/sql/colexec/limit.go#L42-L44) [pkg/sql/colexec/colexecjoin/crossjoiner.go#L101-L103](pkg/sql/colexec/colexecjoin/crossjoiner.go#L101-L103) [pkg/sql/colexec/colexecjoin/crossjoiner.go#L193-L195](pkg/sql/colexec/colexecjoin/crossjoiner.go#L193-L195) [pkg/sql/colexec/colexecjoin/joiner_util.go#L389-L391](pkg/sql/colexec/colexecjoin/joiner_util.go#L389-L391) [pkg/sql/colexec/colexecjoin/joiner_util.go#L375-L377](pkg/sql/colexec/colexecjoin/joiner_util.go#L375-L377) [pkg/sql/colexec/columnarizer.go#L243-L245](pkg/sql/colexec/columnarizer.go#L243-L245) [pkg/sql/rowexec/project_set.go#L301-L303](pkg/sql/rowexec/project_set.go#L301-L303) [pkg/sql/rowexec/project_set.go#L207-L209](pkg/sql/rowexec/project_set.go#L207-L209) [pkg/sql/routine.go#L281-L283](pkg/sql/routine.go#L281-L283) [pkg/sql/routine.go#L331-L333](pkg/sql/routine.go#L331-L333) [pkg/sql/opt/exec/execbuilder/scalar.go#L1287-L1289](pkg/sql/opt/exec/execbuilder/scalar.go#L1287-L1289) [pkg/sql/opt/xform/optimizer.go#L276-L278](pkg/sql/opt/xform/optimizer.go#L276-L278) </details> ``` pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*BatchSchemaSubsetEnforcer).Next at line 223 bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go in pkg/sql/colexec/colexecbase.constDecimalOp.Next at line 253 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next at line 153 pkg/sql/colexecop/operator.go in pkg/sql/colexecop.(*noopOperator).Next at line 476 pkg/sql/colexec/colexecbase/simple_project.go in pkg/sql/colexec/colexecbase.(*simpleProjectOp).Next at line 114 pkg/sql/colexec/colexecbuiltins/builtin_funcs.go in pkg/sql/colexec/colexecbuiltins.(*defaultBuiltinFuncOperator).Next at line 45 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next at line 153 bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go in pkg/sql/colexec/colexecbase.constInt64Op.Next at line 379 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next at line 153 bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go in pkg/sql/colexec/colexecprojconst.projDivDecimalDecimalConstOp.Next at line 12191 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next at line 153 bazel-out/k8-opt/bin/pkg/sql/colexec/colexecprojconst/proj_const_right_ops.eg.go in pkg/sql/colexec/colexecprojconst.projMultDecimalDecimalConstOp.Next at line 9368 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next at line 153 pkg/sql/colexec/case.go in pkg/sql/colexec.(*caseOp).Next at line 193 pkg/sql/colexec/buffer.go in pkg/sql/colexec.(*bufferOp).advance at line 45 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*BatchSchemaSubsetEnforcer).Next at line 223 pkg/sql/colexecop/operator.go in pkg/sql/colexecop.(*noopOperator).Next at line 476 bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/const.eg.go in pkg/sql/colexec/colexecbase.constDecimalOp.Next at line 253 pkg/sql/colexec/colexecutils/operator.go in pkg/sql/colexec/colexecutils.(*vectorTypeEnforcer).Next at line 153 pkg/sql/colexecop/operator.go in pkg/sql/colexecop.(*noopOperator).Next at line 476 pkg/sql/colexec/limit.go in pkg/sql/colexec.(*limitOp).Next at line 43 pkg/sql/colexec/colexecjoin/crossjoiner.go in pkg/sql/colexec/colexecjoin.(*crossJoiner).Next at line 102 pkg/sql/colexec/colexecjoin/crossjoiner.go in pkg/sql/colexec/colexecjoin.(*crossJoiner).consumeRightInput at line 194 pkg/sql/colexec/colexecjoin/joiner_util.go in pkg/sql/colexec/colexecjoin.(*metadataHelper).inputTwoNext at line 390 pkg/sql/colexec/colexecjoin/joiner_util.go in pkg/sql/colexec/colexecjoin.(*metadataHelper).next at line 376 pkg/sql/colexec/columnarizer.go in pkg/sql/colexec.(*Columnarizer).Next at line 244 pkg/sql/rowexec/project_set.go in pkg/sql/rowexec.(*projectSetProcessor).Next at line 302 pkg/sql/rowexec/project_set.go in pkg/sql/rowexec.(*projectSetProcessor).nextInputRow at line 208 pkg/sql/routine.go in pkg/sql.(*routineGenerator).Start at line 282 pkg/sql/routine.go in pkg/sql.(*routineGenerator).startInternal at line 332 pkg/sql/opt/exec/execbuilder/scalar.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRoutinePlanGenerator.func2 at line 1288 pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).Optimize at line 277 ``` ### Tags | Tag | Value | | --- | --- | | Command | mt start-sql | | Environment | v26.2.5 | | Go Version | go1.25.5 | | Platform | linux amd64 | | Distribution | CCL | | Cockroach Release | v26.2.5 | | Cockroach SHA | c8455423826d0c4ba75a9ae78eb2dbd7e11648bb | | # of CPUs | 16 | | # of Goroutines | 267 | Jira issue: CRDB-66997