sql/tests: TestRandomSyntaxGeneration failed

[cockroach-teamcity]

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-22.2 @ 7008173aa9f70fe00cb2067b998f4dcbbd503015:

    rsg_test.go:822: 1m15s of 5m0s: 278590 executions, 14736 successful
    rsg_test.go:822: 1m20s of 5m0s: 298392 executions, 15660 successful
    rsg_test.go:822: 1m25s of 5m0s: 317841 executions, 16532 successful
    rsg_test.go:822: 1m30s of 5m0s: 337264 executions, 17431 successful
    rsg_test.go:822: 1m35s of 5m0s: 356659 executions, 18331 successful
    rsg_test.go:822: 1m40s of 5m0s: 376168 executions, 19203 successful
    rsg_test.go:822: 1m45s of 5m0s: 395302 executions, 20096 successful
    rsg_test.go:822: 1m50s of 5m0s: 414790 executions, 20924 successful
    rsg_test.go:822: 1m55s of 5m0s: 432544 executions, 21744 successful
    rsg_test.go:822: 2m0s of 5m0s: 450863 executions, 22594 successful
    rsg_test.go:822: 2m5s of 5m0s: 469724 executions, 23381 successful
    rsg_test.go:822: 2m10s of 5m0s: 488816 executions, 24330 successful
    rsg_test.go:822: 2m15s of 5m0s: 508814 executions, 25241 successful
    rsg_test.go:822: 2m20s of 5m0s: 527813 executions, 26138 successful
    rsg_test.go:822: 2m25s of 5m0s: 546933 executions, 26984 successful
    rsg_test.go:822: 2m30s of 5m0s: 566065 executions, 27828 successful
    rsg_test.go:822: 2m35s of 5m0s: 585731 executions, 28699 successful
    rsg_test.go:822: 2m40s of 5m0s: 605886 executions, 29618 successful
    rsg_test.go:822: 2m45s of 5m0s: 625561 executions, 30546 successful
    rsg_test.go:822: 2m50s of 5m0s: 645165 executions, 31477 successful
    rsg_test.go:822: 2m55s of 5m0s: 664324 executions, 32378 successful
    rsg_test.go:822: 3m0s of 5m0s: 682984 executions, 33225 successful
    rsg_test.go:822: 3m5s of 5m0s: 701942 executions, 34012 successful
    rsg_test.go:822: 3m10s of 5m0s: 721675 executions, 34824 successful
    rsg_test.go:822: 3m15s of 5m0s: 741099 executions, 35666 successful
    rsg_test.go:822: 3m20s of 5m0s: 759676 executions, 36525 successful
    rsg_test.go:822: 3m25s of 5m0s: 777892 executions, 37323 successful
    rsg_test.go:822: 3m30s of 5m0s: 796290 executions, 38174 successful
    rsg_test.go:822: 3m35s of 5m0s: 815597 executions, 39048 successful
    rsg_test.go:822: 3m40s of 5m0s: 834446 executions, 39950 successful
    rsg_test.go:822: 3m45s of 5m0s: 853867 executions, 40912 successful
    rsg_test.go:822: 3m50s of 5m0s: 871563 executions, 41723 successful
    rsg_test.go:822: 3m55s of 5m0s: 890434 executions, 42532 successful
    rsg_test.go:822: 4m0s of 5m0s: 909861 executions, 43314 successful
    rsg_test.go:822: 4m5s of 5m0s: 928287 executions, 44107 successful
    rsg_test.go:822: 4m10s of 5m0s: 947742 executions, 44923 successful
    rsg_test.go:822: 4m15s of 5m0s: 966023 executions, 45758 successful
    rsg_test.go:822: 4m20s of 5m0s: 985482 executions, 46615 successful
    rsg_test.go:822: 4m25s of 5m0s: 1005078 executions, 47475 successful
    rsg_test.go:822: 4m30s of 5m0s: 1024912 executions, 48344 successful
    rsg_test.go:822: 4m35s of 5m0s: 1044485 executions, 49170 successful
    rsg_test.go:822: 4m40s of 5m0s: 1064265 executions, 50035 successful
    rsg_test.go:822: 4m45s of 5m0s: 1083265 executions, 50936 successful
    rsg_test.go:822: 4m50s of 5m0s: 1101967 executions, 51825 successful
    rsg_test.go:822: 4m55s of 5m0s: 1120607 executions, 52729 successful
    rsg_test.go:858: 1137557 executions, 53491 successful
    rsg_test.go:866: cannot parse output of Format: sql="EXPORT INTO TRUSTED 'string' WITH OPTIONS ( BUCKET_COUNT = PLACEHOLDER , 'string' = PLACEHOLDER , ANNOTATE_TYPE = CHARACTERISTICS , 'string' , 'string' = 'string' , FORCE = 'string' ) FROM ( ( ( SELECT error ) ) )", formattedSQL="EXPORT INTO TRUSTED 'string' WITH bucket_count = 'placeholder', \"string\" = 'placeholder', \"annotate_type\" = 'characteristics', \"string\", \"string\" = 'string', force = 'string' FROM (((SELECT error)))": at or near "with": syntax error
    rsg_test.go:305: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration23308422
--- FAIL: TestRandomSyntaxGeneration (301.32s)

Help

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

Same failure on other branches

• sql/tests: TestRandomSyntaxGeneration failed [index visibility precision] #108083 sql/tests: TestRandomSyntaxGeneration failed [index visibility precision] [C-test-failure O-robot T-sql-foundations X-noreuse branch-master]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-30372

[chengxiong-ruan]

heh, export options need to be wrapped with () in 22.2 and 23.1 as well. it was fixed on master.