Crashing by EXPLAIN Statement

[bajinsheng]

Describe the problem

An EXPLAIN statement triggers a crash.

To Reproduce

CREATE TABLE t0 (c0 INT);
CREATE TABLE t1 (c0 INT);
CREATE TABLE t2 (c0 INT);
CREATE TABLE t3 (c0 INT);
CREATE TABLE t4 (c0 VARBIT(1)[]);
CREATE TABLE t5 (c0 INT);

EXPLAIN SELECT bool_and(t4.c0 < t4.c0) FROM t5, t0, t2, t1, t3, t4; -- runtime error: index out of range [1] with length 1

Expected behavior
No error.

Additional data / screenshots

ERROR: a SQL panic has occurred while executing the following statement:
EXPLAIN SELECT bool_and(t4.c0 < t4.c0) FROM t5, t0, t2, t1, t3, t4
ERROR: a panic has occurred!
runtime error: index out of range [1] with length 1
(1) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:755
| [...repeated from below...]
Wraps: (2) while executing: EXPLAIN SELECT bool_and(. < .) FROM _, _, _, _, _, _
Wraps: (3) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:755
| runtime.gopanic
| GOROOT/src/runtime/panic.go:1038
| runtime.goPanicIndex
| GOROOT/src/runtime/panic.go:90
| github.com/cockroachdb/cockroach/pkg/sql/opt/indexrec.(*HypotheticalTable).Column
| github.com/cockroachdb/cockroach/pkg/sql/opt/indexrec/hypothetical_table.go:110
| github.com/cockroachdb/cockroach/pkg/sql/opt.(*Metadata).UpdateTableMeta
| github.com/cockroachdb/cockroach/pkg/sql/opt/metadata.go:618
| github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).makeQueryIndexRecommendation
| github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:737
| github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo
| github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:560
| github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan
| github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:225
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1363
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1045
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:690
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:145
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1892
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1896
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1818
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:757
| github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1
| github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:724
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1581
Wraps: (4) runtime error: index out of range [1] with length 1
Error types: (1) *withstack.withStack (2) *safedetails.withSafeDetails (3) *withstack.withStack (4) runtime.boundsError

Environment:

• CockroachDB version [02dcb38]
• Server OS: [Ubuntu 20.04]
• Client app [cockroach sql]

Additional context

Jira issue: CRDB-17374

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-queries (found keywords: Optimizer,Plan)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[mgartner]

Thank you for the report! We have identified the bug and the fix in #84169 should merge soon.

[bajinsheng]

Thanks for your prompt reply!