cockroachdb / cockroachdb/cockroach
Join Crash with ERROR: internal error: invalid datum type given
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Describe the problem**
Dear CockroachDB Developers:
I meet a crash with ERROR: internal error: invalid datum type given
**To Reproduce**
```
docker run --name cockroachdb-test -p 10015:26257 -p 10012:8080 cockroachdb/cockroach:latest start-single-node --insecure
```
Then you can connect it and execute the following cases.
```
CREATE TABLE t1 (c0 TIMESTAMP);
CREATE TABLE t3 (c0 TIMESTAMPTZ);
UPSERT INTO t3 (c0) VALUES(TIMESTAMPTZ '1970-01-05T10:12:17');
SELECT ALL * FROM t1 NATURAL FULL JOIN t3;
ERROR: internal error: invalid datum type given: TIMESTAMPTZ, expected TIMESTAMP
--pkg/sql/rowenc/encoded_datum.go:202: DatumToEncDatumEx()
--pkg/sql/rowenc/encoded_datum.go:184: DatumToEncDatum()
--pkg/sql/execinfra/processorsbase.go:295: ProcessRow()
--pkg/sql/execinfra/processorsbase.go:705: ProcessRowHelper()
--pkg/sql/rowexec/noop.go:96: Next()
--pkg/sql/colexec/columnarizer.go:234: Next()
--pkg/sql/colexec/colexecjoin/crossjoiner.go:133: readNextLeftBatch()
--pkg/sql/colexec/colexecjoin/crossjoiner.go:266: willEmit()
--pkg/sql/colexec/colexecjoin/crossjoiner.go:97: Next()
--pkg/sql/colflow/flow_coordinator.go:241: nextAdapter()
--pkg/sql/colexecerror/error.go:162: CatchVectorizedRuntimeError()
--pkg/sql/colflow/flow_coordinator.go:245: next()
--pkg/sql/colflow/flow_coordinator.go:277: Run()
--pkg/sql/colflow/vectorized_flow.go:316: Run()
--pkg/sql/distsql_running.go:934: Run()
--pkg/sql/distsql_running.go:2037: PlanAndRun()
--pkg/sql/distsql_running.go:1741: func3()
--pkg/sql/distsql_running.go:1744: PlanAndRunAll()
--pkg/sql/conn_executor_exec.go:3330: execWithDistSQLEngine()
--pkg/sql/conn_executor_exec.go:2862: dispatchToExecutionEngine()
--pkg/sql/conn_executor_exec.go:1037: execStmtInOpenState()
--pkg/sql/conn_executor_exec.go:164: func2()
--pkg/sql/conn_executor_exec.go:4342: execWithProfiling()
--pkg/sql/conn_executor_exec.go:163: execStmt()
--pkg/sql/conn_executor_exec.go:281: execPortal()
--pkg/sql/conn_executor.go:2496: func2()
--pkg/sql/conn_executor.go:2498: execCmd()
--pkg/sql/conn_executor.go:2306: run()
--pkg/sql/conn_executor.go:1002: ServeConn()
--pkg/sql/pgwire/conn.go:252: processCommands()
--pkg/sql/pgwire/server.go:1197: func4()
--src/runtime/asm_arm64.s:1222: goexit()
```
**Expected behavior**
No Crash
**Environment:**
- CockroachDB version: CockroachDB CCL v25.2.0 (aarch64-unknown-linux-gnu, built 2025/05/15 21:07:42, go1.23.7 X:nocoverageredesign)
- Server OS: MacOS
- Client app [cockroach sql]
Jira issue: CRDB-51145
Contributor guide
Assessment
This issue has not been assessed yet.