cockroachdb / cockroachdb/cockroach

Join Crash with ERROR: internal error: invalid datum type given

Open
#147,585 1 comment 0 reactions 0 assignees View on GitHub
C-bug O-community T-sql-queries X-blathers-triaged
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

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.