sql: recent regression on planning comparisons #95633
Description
Some time in the past 5 days, the planning / execution engine started to fail on the following query:
SELECT d.datname,
pg_catalog.pg_get_userbyid(d.datdba)
FROM pg_catalog.pg_database d;ERROR: internal error: lookup for ComparisonExpr ((@18)[oid] = (('defaultdb')[string])[name])[bool]'s CmpOp failed
stack trace:
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:491: MemoizeComparisonExprOp()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:400: NewTypedComparisonExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/scalar.go:257: buildComparison()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/scalar.go:107: buildScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/builder.go:325: BuildScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/format.go:54: fmtInterceptor()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:1060: formatScalarWithLabel()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:920: formatScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:230: formatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:1082: formatScalarWithLabel()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:920: formatScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:230: formatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:915: formatRelational()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:232: formatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:915: formatRelational()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:232: formatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:915: formatRelational()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:232: formatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:915: formatRelational()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:232: formatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:218: FormatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr_format.go:156: FormatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:1156: FormatExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/scalar.go:889: func2()
github.com/cockroachdb/cockroach/pkg/sql/routine.go:66: func2()
github.com/cockroachdb/cockroach/pkg/sql/routine.go:95: EvalRoutineExpr()
github.com/cockroachdb/cockroach/pkg/sql/sem/eval/expr.go:635: EvalRoutineExpr()
github.com/cockroachdb/cockroach/bazel-out/freebsd-fastbuild/bin/pkg/sql/sem/tree/eval_expr_generated.go:346: Eval()
github.com/cockroachdb/cockroach/pkg/sql/sem/eval/expr.go:174: EvalCaseExpr()
github.com/cockroachdb/cockroach/bazel-out/freebsd-fastbuild/bin/pkg/sql/sem/tree/eval_expr_generated.go:91: Eval()
github.com/cockroachdb/cockroach/pkg/sql/sem/eval/expr.go:26: Expr()
github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/pkg/sql/execinfrapb/expr.go:248: Eval()
cc @yuzefovich for triage
Jira issue: CRDB-23642
Epic: CRDB-23454
Metadata
Metadata
Assignees
Labels
Type
Projects
Status