sql: Internal Error when creating type in SHOW JOBS

[SteveLeungYL]

Describe the problem

The latest alpha version of the CockroachDB (v23.1.0-alpha.2) encounters Internal Error when executing the following query.

SELECT 'any_random_text' FROM [SHOW CHANGEFEED JOBS WITH alias_0 AS MATERIALIZED (CREATE TYPE "int" AS ENUM ()) VALUES (DEFAULT)];

To Reproduce

1. In operating system Ubuntu 20.04 LTS, download the CockroachDB source code from the github source.
2. Download the pre-build CockroachDB binaries (v22.2.3 and v23.1.0 alpha) from link
3. Run ./cockroach demo, and then paste the PoC query to the cockroach cli environment.
4. Observe the Internal Error and log the stack information.

Additional data / screenshots

Here is the stack trace from v23.1.0-alpha.2:

ERROR: internal error: runtime error: index out of range [4] with length 1
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/util/errorutil/catch.go:29: ShouldCatch()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:193: func1()
GOROOT/src/runtime/panic.go:884: gopanic()
GOROOT/src/runtime/panic.go:113: goPanicIndex()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/annotation.go:48: Set()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/annotation.go:35: SetAnnotation()
github.com/cockroachdb/cockroach/pkg/sql/create_type.go:73: CreateType()
github.com/cockroachdb/cockroach/pkg/sql/opaque.go:168: planOpaque()
github.com/cockroachdb/cockroach/pkg/sql/opaque.go:63: buildOpaque()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/opaque.go:70: tryBuildOpaque()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:409: buildStmt()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:198: buildCTE()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:143: buildCTEs()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:113: processWiths()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:965: buildSelect()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:310: buildStmt()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/subquery.go:220: buildSubquery()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/subquery.go:99: TypeCheck()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:2242: typeCheckComparisonOp()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:866: TypeCheck()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:272: TypeCheck()
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:282: TypeCheckAndRequire()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:487: resolveAndRequireType()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/util.go:459: resolveAndBuildScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1170: buildWhere()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1052: buildSelectClause()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:997: buildSelectStmtWithoutParens()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:966: func1()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:116: processWiths()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:965: buildSelect()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:307: buildStmt()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:405: buildStmt()

HINT: You have encountered an unexpected error.

Environment:

• CockroachDB version: v23.1.0-alpha.2
• Server OS: Ubuntu 20.04 LTS
• Client app: CockroachDB demo command. (./cockroach demo)
• Detailed CockroachDB version output:

cockroach version details:
Build Tag:        v23.1.0-alpha.2
Build Time:       2023/02/13 18:32:33
Distribution:     CCL
Platform:         linux amd64 (x86_64-pc-linux-gnu)
Go Version:       go1.19.4
C Compiler:       gcc 6.5.0
Build Commit ID:  eb158026c50d8fa856e42f928d844831ea9e6b28
Build Type:       release

Additional context

The bug can also be reproduced in v23.1.0-alpha.2, v23.1.0-alpha.1, v22.1.13, v22.2.3 and v21.2.17. We haven't tested earlier versions before v21.2.17.

Jira issue: CRDB-24655

[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/cdc (found keywords: CHANGEFEED)
• @cockroachdb/sql-queries (found keywords: 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 dev-inf.}

[blathers-crl]

cc @cockroachdb/cdc