cockroachdb / cockroachdb/cockroach

sql: "internal error: interface conversion: *sql.optView is not cat.Table: missing method Check" when decoding gist

Open
#118,874 1 comment 0 reactions 0 assignees View on GitHub
C-bug T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

@glennfawcett found this nice one:

```
demo@127.0.0.1:26257/demoapp/defaultdb> select crdb_internal.decode_plan_gist('AgHk/v//nxkAAOAXAAAAAwcKBQobBQQMMAHK////nxkEAJDBAQIAADEFAjEFAjEFAjEFAgcCBgI=');
ERROR: internal error: interface conversion: *sql.optView is not cat.Table: missing method Check
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/util/errorutil/catch.go:29: ShouldCatch()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/explain/plan_gist_factory.go:172: func1()
GOROOT/src/runtime/panic.go:914: gopanic()
GOROOT/src/runtime/iface.go:92: getitab()
GOROOT/src/runtime/iface.go:430: assertI2I()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/explain/plan_gist_factory.go:309: decodeTable()
github.com/cockroachdb/cockroach/bazel-out/darwin-fastbuild/bin/pkg/sql/opt/exec/explain/plan_gist_factory.og.go:1145: decodeOperatorBody()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/explain/plan_gist_factory.go:243: decodeOp()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/explain/plan_gist_factory.go:216: DecodePlanGistToPlan()
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/explain/plan_gist_factory.go:184: DecodePlanGistToRows()
github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:735: DecodeGist()
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/generator_builtins.go:739: Start()
github.com/cockroachdb/cockroach/pkg/sql/rowexec/project_set.go:208: nextInputRow()
github.com/cockroachdb/cockroach/pkg/sql/rowexec/project_set.go:290: Next()
github.com/cockroachdb/cockroach/pkg/sql/colexec/columnarizer.go:239: Next()
github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:118: next()
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92: CatchVectorizedRuntimeError()
github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:126: Next()
github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:250: nextAdapter()
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92: CatchVectorizedRuntimeError()
github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:254: next()
github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:286: Run()
github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:320: Run()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:909: Run()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1970: PlanAndRun()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1685: func3()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1688: PlanAndRunAll()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2420: execWithDistSQLEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1949: dispatchToExecutionEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1125: execStmtInOpenState()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:146: func1()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:3427: execWithProfiling()
```

The statement is:

```
root@localhost:26257/defaultdb> select query from stmt_stats_copy where gist =
-> 'AgHk/v//nxkAAOAXAAAAAwcKBQobBQQMMAHK////nxkEAJDBAQIAADEFAjEFAjEFAjEFAgcCBgI=';
query
-----------------------------------------------------------------------
SELECT create_statement FROM [SHOW CREATE defaultdb.public.measure]
```

Jira issue: CRDB-35938

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.