sql/tests: TestRandomSyntaxFuncCommon failed

[cockroach-teamcity]

sql/tests.TestRandomSyntaxFuncCommon failed with artifacts on master @ 0a895777f13e48209c8cd23f1b304d33f7e1cea1:

    rsg_test.go:860: 1m55s of 5m0s: 75231 executions, 505 successful
    rsg_test.go:860: 2m0s of 5m0s: 78301 executions, 527 successful
    rsg_test.go:860: 2m5s of 5m0s: 81368 executions, 542 successful
    rsg_test.go:860: 2m10s of 5m0s: 84386 executions, 555 successful
    rsg_test.go:860: 2m15s of 5m0s: 87399 executions, 566 successful
    rsg_test.go:860: 2m20s of 5m0s: 90464 executions, 586 successful
    rsg_test.go:860: 2m25s of 5m0s: 93552 executions, 609 successful
    rsg_test.go:860: 2m30s of 5m0s: 96529 executions, 628 successful
    rsg_test.go:860: 2m35s of 5m0s: 99525 executions, 648 successful
    rsg_test.go:860: 2m40s of 5m0s: 102386 executions, 662 successful
    rsg_test.go:860: 2m45s of 5m0s: 105456 executions, 681 successful
    rsg_test.go:860: 2m50s of 5m0s: 108560 executions, 699 successful
    rsg_test.go:860: 2m55s of 5m0s: 111528 executions, 710 successful
    rsg_test.go:860: 3m0s of 5m0s: 114475 executions, 723 successful
    rsg_test.go:860: 3m5s of 5m0s: 117481 executions, 740 successful
    rsg_test.go:860: 3m10s of 5m0s: 120399 executions, 747 successful
    rsg_test.go:860: 3m15s of 5m0s: 123382 executions, 770 successful
    rsg_test.go:860: 3m20s of 5m0s: 126299 executions, 793 successful
    rsg_test.go:860: 3m25s of 5m0s: 129129 executions, 804 successful
    rsg_test.go:860: 3m30s of 5m0s: 132056 executions, 820 successful
    rsg_test.go:860: 3m35s of 5m0s: 134997 executions, 835 successful
    rsg_test.go:860: 3m40s of 5m0s: 137861 executions, 844 successful
    rsg_test.go:860: 3m45s of 5m0s: 140759 executions, 854 successful
    rsg_test.go:860: 3m50s of 5m0s: 143720 executions, 873 successful
    rsg_test.go:860: 3m55s of 5m0s: 146607 executions, 883 successful
    rsg_test.go:860: 4m0s of 5m0s: 149442 executions, 899 successful
    rsg_test.go:860: 4m5s of 5m0s: 152329 executions, 916 successful
    rsg_test.go:860: 4m10s of 5m0s: 155195 executions, 936 successful
    rsg_test.go:860: 4m15s of 5m0s: 158019 executions, 954 successful
    rsg_test.go:860: 4m20s of 5m0s: 160877 executions, 968 successful
    rsg_test.go:860: 4m25s of 5m0s: 163806 executions, 982 successful
    rsg_test.go:860: 4m30s of 5m0s: 166560 executions, 992 successful
    rsg_test.go:860: 4m35s of 5m0s: 169368 executions, 1009 successful
    rsg_test.go:860: 4m40s of 5m0s: 172231 executions, 1017 successful
    rsg_test.go:860: 4m45s of 5m0s: 175034 executions, 1036 successful
    rsg_test.go:860: 4m50s of 5m0s: 177981 executions, 1051 successful
    rsg_test.go:860: 4m55s of 5m0s: 180859 executions, 1062 successful
    rsg_test.go:209: Context cancelled while executing: "SELECT COLLATION FOR ( UNIQUE ( error IS NOT OF ( @ -147 ARRAY [ 188 ] [ error , POLYGON error ARRAY [ -497 ] , POINT error [ ] [ error ) IS NAN )"
    rsg_test.go:209: Context cancelled while executing: "SELECT CAST ( - SQRT UNIQUE ( error IS NOT UNKNOWN IS NAN AS @ 472 ARRAY [ 368 ] )"
    rsg_test.go:209: Context cancelled while executing: "SELECT CAST ( DEFAULT AS ILIKE . TIMESTAMP . INCLUDING ARRAY )"
    rsg_test.go:209: Context cancelled while executing: "SELECT ANNOTATE_TYPE ( - UNIQUE ( error , ident [ -166 ] )"
    rsg_test.go:209: Context cancelled while executing: "SELECT COALESCE ( EXISTS ( ( error ORDER BY PRIMARY KEY INDEX_BEFORE_PAREN ASC ) , ( ) OVERLAPS ( ) )"
    rsg_test.go:209: Context cancelled while executing: "SELECT TREAT ( VARBIT ( -199 ) 'string' AS @ -369 [ ] )"
    rsg_test.go:209: Context cancelled while executing: "SELECT CAST ( UNIQUE ( error AS @ 349 ARRAY [ 466 ] )"
    rsg_test.go:209: Context cancelled while executing: "SELECT CAST ( DEFAULT AS INTERVAL ARRAY [ 228 ] )"
    rsg_test.go:896: 183738 executions, 1082 successful
    rsg_test.go:904: cannot parse output of Format: sql="SELECT CAST ( EXISTS ( WITH RECURSIVE QUERIES ( VARBIT , ident , VIEWCLUSTERMETADATA ) AS ( TRUNCATE TABLE STATEMENTS . DEC RESTRICT ) , PLANS AS MATERIALIZED ( ALTER DEFAULT PRIVILEGES FOR ALL ROLES IN SCHEMA ident , ident . PRECISION GRANT ident ON TABLES TO CURRENT_USER WITH GRANT OPTION ) TABLE error ORDER BY PRIMARY KEY INDEX_BEFORE_PAREN ASC , PRIMARY KEY INDEX_BEFORE_NAME_THEN_PAREN . PRIOR . PARTIAL , INDEX_AFTER_ORDER_BY_BEFORE_AT FAMILY @ ident ASC FOR READ ONLY ) AS VARCHAR ARRAY )", formattedSQL="SELECT CAST(EXISTS (WITH RECURSIVE queries (\"varbit\", ident, viewclustermetadata) AS (TRUNCATE TABLE statements.\"dec\" RESTRICT), plans AS MATERIALIZED (ALTER DEFAULT PRIVILEGES FOR ALL ROLES IN SCHEMA ident, ident.\"precision\" GRANT Kind(0) ON TABLES TO CURRENT_USER WITH GRANT OPTION) TABLE error ORDER BY PRIMARY KEY \"index_before_paren\" ASC, PRIMARY KEY \"index_before_name_then_paren\".prior.partial, INDEX \"family\"@ident ASC) AS VARCHAR[])": at or near "(": syntax error
    rsg_test.go:460: -- test log scope end --
--- FAIL: TestRandomSyntaxFuncCommon (300.97s)
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxFuncCommon65457063

Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-30986