Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql: internal error: unexpected type for COLLATE: log.SafeType #38865

Closed
maddyblue opened this issue Jul 14, 2019 · 0 comments · Fixed by #39681
Closed

sql: internal error: unexpected type for COLLATE: log.SafeType #38865

maddyblue opened this issue Jul 14, 2019 · 0 comments · Fixed by #39681
Assignees
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Comments

@maddyblue
Copy link
Contributor

SELECT ISERROR ( NAME 'string' COLLATE AS )

   assertion failure
  - error with attached stack trace:
    github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*CustomFuncs).CastToCollatedString
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/custom_funcs.go:1601
    github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructCollate
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:13920
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildScalar
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:106
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildScalar
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:159
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildProjectionList
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/project.go:164
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:695
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:620
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:205
    github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:161
    github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:412
    github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:144
    github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:764
    github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:645
    github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:417
    github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:99
    github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1204
    github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1140
    github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:442
    github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:580
    runtime.goexit
        /usr/local/go/src/runtime/asm_amd64.s:1337
  - error with embedded safe details: unexpected type for COLLATE: %T
    -- arg 1: 'string'
  - unexpected type for COLLATE: log.SafeType
pq: internal error: unexpected type for COLLATE: log.SafeType
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/opt/norm/custom_funcs.go:1601: CastToCollatedString()
github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:13920: ConstructCollate()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:106: buildScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:159: buildScalar()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/project.go:164: buildProjectionList()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:695: buildSelectClause()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:620: buildSelect()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:205: buildStmt()
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:161: Build()
github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:412: buildExecMemo()
github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:144: makeOptimizerPlan()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:764: makeExecPlan()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:645: dispatchToExecutionEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:417: execStmtInOpenState()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:99: execStmt()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1204: execCmd()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1140: run()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:442: ServeConn()
github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:580: func1()
runtime/asm_amd64.s:1337: goexit()
@maddyblue maddyblue added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Jul 14, 2019
craig bot pushed a commit that referenced this issue Aug 21, 2019
39681: sql: unwrap in CastToCollatedString r=justinj a=vazrupe

Unwarp once in CastToCollatedString.
In the assert message, type the output as is.

Fixes #38865

Release note: None

Co-authored-by: HyeonGyu Lee (Vazrupe) <vazrupe@naver.com>
@craig craig bot closed this as completed in 1bf3f99 Aug 21, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants