sql/tests: TestRandomSyntaxFunctions failed [int64 varint decoding failed]

[cockroach-teamcity]

sql/tests.TestRandomSyntaxFunctions failed with artifacts on master @ b7136867fd3d483744ea2d3c507afb241410f7e2:

Random syntax error:

    rsg_test.go:887: Crash detected: server panic: pq: internal error: unexpected error from the vectorized engine: error decoding 20 bytes: int64 varint decoding failed: 0

Query:

        SELECT array_cat_agg(ARRAY[('1985-08-12':::DATE,),('1986-01-25 04:27:18.000562+00':::TIMESTAMPTZ,)]) ;

Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

• sql/tests: TestRandomSyntaxFunctions failed #95619 sql/tests: TestRandomSyntaxFunctions failed [C-test-failure O-robot T-sql-foundations branch-release-22.2]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-31100

[rharding6373]

This has been fixed on master as of at least the 8/20 nightly:

SELECT array_cat_agg(ARRAY[('1985-08-12':::DATE,),('1986-01-25 04:27:18.000562+00':::TIMESTAMPTZ,)]) ;                             
                              array_cat_agg
--------------------------------------------------------------------------
  {"(\"1985-08-12 00:00:00+00\")","(\"1986-01-25 04:27:18.000562+00\")"}

There have been similar internal errors lately, e.g.: #109629
But the fix for that issue merged more recently than the nightly we tested.

[rharding6373]

We also confirmed that this was a regression on master (it's not present on 23.1).