roachtest: sqlsmith failed: interface conversion: coldata.Column is coldata.Int32s, not coldata.Int64s

[cockroach-teamcity]

roachtest.sqlsmith/setup=seed-multi-region/setting=multi-region failed with artifacts on master @ 7bd8974eca566ca7625b6621decc5ae52d4fd38e:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=seed-multi-region/setting=multi-region/run_1
	sqlsmith.go:258,sqlsmith.go:297,test_runner.go:779: error: pq: internal error: unexpected error from the vectorized engine: interface conversion: coldata.Column is coldata.Int32s, not coldata.Int64s
		stmt:
		SELECT
			*
		FROM
			(
				SELECT
					tab_7367._timestamp AS col_13987,
					'00000000-0000-0000-0000-000000000004':::UUID::UUID AS col_13988,
					tab_7367._decimal AS col_13989,
					tab_7367._bool AS col_13990,
					lag(tab_7367._int2::INT4, tab_7367._int8::INT4, tab_7367._int4::INT4) OVER (PARTITION BY tab_7367._interval ORDER BY tab_7367._bytes, tab_7367._date RANGE UNBOUNDED PRECEDING)::INT8
						AS col_13991,
					tab_7367._int4 AS col_13992,
					nth_value(tab_7367._date::DATE, tab_7367._int2::INT4) OVER (PARTITION BY tab_7367._int8 ORDER BY tab_7367._bool DESC, tab_7367._bytes DESC)::DATE
						AS col_13993,
					tab_7367._string AS col_13994,
					2.0:::FLOAT8::FLOAT8 AS col_13995,
					tab_7367._int8 AS col_13996,
					2:::OID::OID AS col_13997,
					tab_7367._bytes AS col_13998,
					tab_7367._timestamptz AS col_13999,
					'00:00:06':::INTERVAL::INTERVAL AS col_14000
				FROM
					defaultdb.public.seed_mr_table@[0] AS tab_7367
			)
				AS tab_7368
		ORDER BY
			col_13987 NULLS FIRST,
			col_13988 NULLS FIRST,
			col_13989 NULLS FIRST,
			col_13990 NULLS FIRST,
			col_13991 NULLS FIRST,
			col_13992 NULLS FIRST,
			col_13993 NULLS FIRST,
			col_13994 NULLS FIRST,
			col_13995 NULLS FIRST,
			col_13996 NULLS FIRST,
			col_13997 NULLS FIRST,
			col_13998 NULLS FIRST,
			col_13999 NULLS FIRST,
			col_14000 NULLS FIRST;

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

[yuzefovich]

Reduced repro:

CREATE TABLE IF NOT EXISTS t AS
  SELECT
    g::INT2 AS _int2, g::INT4 AS _int4, g::INT8 AS _int8
  FROM
    ROWS FROM (generate_series(1, 5)) AS g;

SELECT
  lag(_int2::INT4, _int8, _int4) OVER (),
  nth_value(_int4, _int2) OVER ()
FROM
  t;

ERROR: internal error: unexpected error from the vectorized engine: interface conversion: coldata.Column is coldata.Int32s, not coldata.Int64s
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:88: func1()
runtime/panic.go:1038: gopanic()
runtime/iface.go:261: panicdottypeE()
runtime/iface.go:271: panicdottypeI()
github.com/cockroachdb/cockroach/pkg/col/coldata/vec.go:250: Int64()
github.com/cockroachdb/cockroach/pkg/col/coldata/vec.eg.go:694: Copy()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecwindow/buffered_window.go:262: func1()
github.com/cockroachdb/cockroach/pkg/sql/colmem/allocator.go:301: PerformOperation()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecwindow/buffered_window.go:256: Next()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/simple_project.go:125: Next()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/simple_project.go:125: Next()
...

[cockroach-teamcity]

roachtest.sqlsmith/setup=seed/setting=multi-region failed with artifacts on master @ 2bf850847554519dc139289615e1a061b6a251de:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=seed/setting=multi-region/run_1
	sqlsmith.go:150,sqlsmith.go:297,test_runner.go:779: pq: relation "seed_mr_table" does not exist

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!