roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 8c1528fff5c132b971428bc7f18bf0ea5eb16799:

		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/disk_spiller.go:197
		  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:91
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*diskSpillerBase).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/disk_spiller.go:195
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*simpleProjectOp).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/simple_project.go:125
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*limitOp).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/limit.go:47
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*panicInjector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/panic_injector.go:70
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:99
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).nextAdapter
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:240
		  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:91
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:244
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:283
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:259
		  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:553
		  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1368
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1391
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1068
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:706
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:129
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1748
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1750
		Wraps: (2) non-nullable column "table2:col2_2" with no value! Index scanned was "table2_pkey" with the index key columns (col2_1) and the values (?)
		Error types: (1) *withstack.withStack (2) *errutil.leafError
		stmt:
		SELECT
			tab_8878.col4_1 AS col_16793, tab_8878.crdb_internal_mvcc_timestamp AS col_16794
		FROM
			defaultdb.public.table4@[0] AS tab_8878
			JOIN defaultdb.public.table2@table2_expr_col2_2_idx AS tab_8879 ON
					(tab_8878.tableoid) = (tab_8879.col2_2) AND (tab_8878.tableoid) = (tab_8879.col2_0)
		LIMIT
			20:::INT8;

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

[mgartner]

Duplicate of #70628. I've confirmed that #74180 will fix this reproduction.