cockroachdb / cockroachdb/cockroach
basalt-26.3.2-rc-20260908: sql/tests: TestRandomSyntaxGeneration failed
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
sql/tests.TestRandomSyntaxGeneration [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21514466?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21514466?buildTab=artifacts#/) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):
```
rsg_test.go:125: Last executed (4): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (5): COPY ident ( ident , ident ) TO STDOUT ( ESCAPE 'string' , FORMAT 'string' , DELIMITER PLACEHOLDER , QUOTE 'string' , FORMAT 'string' )
rsg_test.go:125: Last executed (6): COPY FAMILY . FROM . EXCEPT TO error
rsg_test.go:125: Last executed (7): COPY FAMILY . NEW . RETURNING FROM STDIN WITH ( DESTINATION PLACEHOLDER )
rsg_test.go:125: Last executed (8): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (9): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (10): COMMENT ON CONSTRAINT GEOMETRY ON INDEX_BEFORE_NAME_THEN_PAREN . FAMILY . OUTER IS NULL
rsg_test.go:125: Last executed (11): REASSIGN OWNED BY SHOW , ident , ident TO SCHEMA
rsg_test.go:125: Last executed (12): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (13): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (14): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (15): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (16): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (17): LOCK TABLE INDEX_AFTER_ORDER_BY_BEFORE_AT . MAXVALUE IN SHARE MODE
rsg_test.go:125: Last executed (18): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (19): COPY INDEX_BEFORE_NAME_THEN_PAREN . NONE . LOCKED FROM STDIN WITH ( DELIMITER PLACEHOLDER )
rsg_test.go:125: Last executed (20): COMMENT ON PROCEDURE ident ( INOUT RETURN . ident . PRIMARY ARRAY , IN FAMILY INTERVAL [ 413 ] [ error , CHARACTER ARRAY [ 239 ] [ error ) IS NULL
rsg_test.go:125: Last executed (21): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (22): REASSIGN OWNED BY SESSION_USER , RELOCATE , CURRENT_USER , STATUS , CURRENT_USER TO ident
rsg_test.go:125: Last executed (23): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (24): CALL DECIMAL . FETCH ( error
rsg_test.go:125: Last executed (25): PREPARE NEW_KMS ( BIT ( -163 ) ARRAY [ -425 ] [ error , ident . ROWS . WHEN ARRAY [ -182 ] [ error ) AS RESET_ALL ALL
rsg_test.go:125: Last executed (26): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (27): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (28): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (29): COPY FAMILY ( TRUNCATE , COALESCE , ident , VARCHAR ) FROM error
rsg_test.go:125: Last executed (30): SET CLUSTER SETTING BACKWARD . COLLATION . POINT . WINDOW TO NONE
rsg_test.go:125: Last executed (31): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (32): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (33): PREPARE EXTENSION ( POLYGON error ARRAY ) AS CANCEL SESSION error
rsg_test.go:125: Last executed (34): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (35): COPY WORK ( ident , PHYSICAL ) FROM error
rsg_test.go:125: Last executed (36): COPY FAMILY ( LATEST ) FROM error
rsg_test.go:125: Last executed (37): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (38): LOCK INDEX_BEFORE_PAREN . ROW , ONLY IF IN SHARE MODE
rsg_test.go:125: Last executed (39): PREPARE ident ( @ 469 ARRAY [ 11 ] , INTERVAL YEAR TO MONTH [ -344 ] [ error ) AS OPT PLAN 'string'
rsg_test.go:125: Last executed (40): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (41): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (42): CREATE DATABASE IF NOT EXISTS ident
rsg_test.go:125: Last executed (43): ANALYZE ident . DEPENDS
rsg_test.go:125: Last executed (44): COPY ident . ELSE . UNIQUE ( START ) TO STDOUT WITH DESTINATION = 'string' ESCAPE 'string'
rsg_test.go:125: Last executed (45): DROP OWNED BY CURRENT_USER , OPTION CASCADE
rsg_test.go:125: Last executed (46): PREPARE TRIM ( CHAR VARYING ( -274 ) ARRAY [ -356 ] , ident [ 59 ] ) AS CREATE error
rsg_test.go:125: Last executed (47): PREPARE ANNOTATE_TYPE AS TRUNCATE ONLY ( FAMILY . FAMILY . ident )
rsg_test.go:125: Last executed (48): REASSIGN OWNED BY CURRENT_USER , CURRENT_USER , SESSION_USER , SECONDARY , CURRENT_USER TO CURRENT_USER
rsg_test.go:125: Last executed (49): LOCK ONLY ( FAMILY . BIGINT . ident ) IN ACCESS SHARE MODE
rsg_test.go:128: Currently active statements: map[]
rsg_test.go:377: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxGeneration3841934018
--- FAIL: TestRandomSyntaxGeneration (302.36s)
```
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
/cc @cockroachlabs/sql-foundations
[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestRandomSyntaxGeneration.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)
Contributor guide
Research direction
Start with the TeamCity build log and artifacts for TestRandomSyntaxGeneration, then inspect rsg_test.go around the reported failures and the commit 807558e5e81666af257c811e925e4cae570abc28. Reproduce the failure and trace the generated SQL statements; done means the test completes successfully without leaving test logs behind.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, testing
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100