cockroachdb / cockroachdb/cockroach

basalt-26.3.2-rc-20260908: sql/tests: TestRandomSyntaxGeneration failed

Open
#175,385 0 comments 0 reactions 0 assignees View on GitHub
branch-basalt-26.3.2-rc-20260908 C-test-failure O-robot release-blocker T-sql-foundations
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.