sql/tests: TestRandomSyntaxFuncCommon failed [invalid datum type given: STRING COLLATE kms, expected STRING COLLATE kms]

[cockroach-teamcity]

sql/tests.TestRandomSyntaxFuncCommon failed with artifacts on release-23.1.23-rc @ 53f8438a57e6c74dcb84edfd0948eae51f28b4df:

Random syntax error:

    rsg_test.go:913: Crash detected: server panic: pq: internal error: invalid datum type given: STRING COLLATE kms, expected STRING COLLATE kms

Query:

        SELECT LEAST ( b'bytes' COLLATE NEW_KMS );

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-39253

[rafiss]

This repros on a fresh cluster:

root@localhost:26257/defaultdb>         SELECT LEAST ( b'bytes' COLLATE NEW_KMS );;
ERROR: internal error: invalid datum type given: STRING COLLATE kms, expected STRING COLLATE kms
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/rowenc/encoded_datum.go:207: DatumToEncDatumEx()
github.com/cockroachdb/cockroach/pkg/sql/rowenc/encoded_datum.go:189: DatumToEncDatum()
github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:228: 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:152: 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:152: 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:928: Run()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1990: PlanAndRun()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1704: func3()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1707: PlanAndRunAll()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2440: execWithDistSQLEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1987: dispatchToExecutionEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1136: execStmtInOpenState()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:145: func1()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:3442: execWithProfiling()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:144: execStmt()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2296: func1()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2301: execCmd()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2218: run()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:965: ServeConn()
github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:253: processCommands()
github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:1033: func4()
src/runtime/asm_arm64.s:1222: goexit()

HINT: You have encountered an unexpected error.

Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.

If you would rather not post publicly, please contact us directly
using the support form.

We appreciate your feedback.

Asking SQL Queries to take a look as it seems related to rowenc.

[michae2]

Also reproduces on v23.1.21 and v22.2.19.

[cockroach-teamcity]

sql/tests.TestRandomSyntaxFuncCommon failed with artifacts on master @ 0e5781f3e2004ef6222e1ed4f5311b771936bd6a:

Random syntax error:

    rsg_test.go:952: Crash detected: server panic: pq: internal error: unexpected statement: *tree.CreateLogicalReplicationStream

Query:

        SELECT COLLATION FOR ( EXISTS ( WITH RECURSIVE ident AS NOT MATERIALIZED ( CREATE LOGICAL REPLICATION STREAM FROM FALSE ON TABLES ( VALIDATE . AUTHORIZATION . AUTHORIZATION , COALESCE . ADMIN . ident ) INTO TABLES ( INDEX_AFTER_ORDER_BY_BEFORE_AT . OVERLAY , ident ) ) , ident ( POLYGON ) AS NOT MATERIALIZED ( IMPORT INTO FAMILY ISERROR DATA ( POLYGONZM , FAMILY ) ) TABLE error ) );

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

This test on roachdash | Improve this report!