cockroachdb / cockroachdb/cockroach
sql/tests: TestRandomSyntaxSchemaChangeColumn failed
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
sql/tests.TestRandomSyntaxSchemaChangeColumn [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21499463?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/21499463?buildTab=artifacts#/) on release-25.2.24-rc @ [92c7311721160180bed1228023264f6df947fc1e](https://github.com/cockroachdb/cockroach/commits/92c7311721160180bed1228023264f6df947fc1e):
```
rsg_test.go:113: Last executed (4): ALTER TABLE ident.ident5 DROP COLUMN IF EXISTS VECTOR
rsg_test.go:113: Last executed (5): ALTER TABLE ident.ident6 RENAME CONSTRAINT ident TO ident
rsg_test.go:113: Last executed (6): ALTER TABLE ident.ident7 ALTER COLUMN EXTRACT DROP NOT NULL
rsg_test.go:113: Last executed (7): ALTER TABLE ident.ident0 ADD ident GEOMETRY [ 291 ] [ error
rsg_test.go:113: Last executed (8): ALTER TABLE ident.ident1 ALTER PRECISION ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( )
rsg_test.go:113: Last executed (9): ALTER TABLE ident.ident2 ALTER COLUMN ident DROP STORED
rsg_test.go:113: Last executed (10): ALTER TABLE ident.ident3 ALTER COLUMN STRING DROP IDENTITY IF EXISTS
rsg_test.go:113: Last executed (11): ALTER TABLE ident.ident4 ALTER FLOAT SET GENERATED_ALWAYS ALWAYS
rsg_test.go:113: Last executed (12): ALTER TABLE ident.ident5 ALTER COLUMN LANGUAGE DROP NOT NULL
rsg_test.go:113: Last executed (13): ALTER TABLE ident.ident6 ALTER BIGINT SET NOT NULL
rsg_test.go:113: Last executed (14): ALTER TABLE ident.ident7 ALTER NUMERIC SET NOT VISIBLE
rsg_test.go:113: Last executed (15): ALTER TABLE ident.ident0 ADD COLUMN ident POINT error ARRAY CREATE FAMILY
rsg_test.go:113: Last executed (16): ALTER TABLE ident.ident1 ADD CONSTRAINT IF NOT EXISTS VIEW PRIMARY KEY ( OUT ident DESC ) USING HASH NOT VALID
rsg_test.go:113: Last executed (17): ALTER TABLE ident.ident2 ALTER COLUMN UNSAFE_RESTORE_INCOMPATIBLE_VERSION ADD GENERATED_ALWAYS ALWAYS AS IDENTITY
rsg_test.go:113: Last executed (18): ALTER TABLE ident.ident3 ADD IF NOT EXISTS OPTION INTERVAL [ ]
rsg_test.go:113: Last executed (19): ALTER TABLE ident.ident4 ALTER LOOKUP SET GENERATED_BY_DEFAULT BY DEFAULT
rsg_test.go:113: Last executed (20): ALTER TABLE ident.ident5 DROP CONSTRAINT IF EXISTS INT RESTRICT
rsg_test.go:113: Last executed (21): ALTER TABLE ident.ident6 ALTER COLUMN ident SET NOT NULL
rsg_test.go:113: Last executed (22): ALTER TABLE ident.ident0 DROP CONSTRAINT RANGES CASCADE
rsg_test.go:113: Last executed (23): ALTER TABLE ident.ident7 INHERITS error
rsg_test.go:113: Last executed (24): ALTER TABLE ident.ident1 RENAME COLUMN ident TO MULTIPOINTM
rsg_test.go:113: Last executed (25): ALTER TABLE ident.ident2 RENAME COLUMN MULTIPOLYGONZM TO ident
rsg_test.go:113: Last executed (26): ALTER TABLE ident.ident3 DROP CONSTRAINT IF EXISTS ident RESTRICT
rsg_test.go:113: Last executed (27): ALTER TABLE ident.ident5 ALTER COLUMN OVERLAY DROP NOT NULL
rsg_test.go:113: Last executed (28): ALTER TABLE ident.ident4 ALTER INVISIBLE ADD error
rsg_test.go:113: Last executed (29): ALTER TABLE ident.ident6 ALTER IFERROR ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( PER NODE CACHE -200 NO MINVALUE )
rsg_test.go:113: Last executed (30): ALTER TABLE ident.ident7 ALTER ident ADD error
rsg_test.go:113: Last executed (31): ALTER TABLE ident.ident0 DROP CONSTRAINT IF EXISTS BOOLEAN
rsg_test.go:113: Last executed (32): ALTER TABLE ident.ident1 NO INHERITS error
rsg_test.go:113: Last executed (33): ALTER TABLE ident.ident2 RESET ( 'string' , 'string' , NOTHING , ident )
rsg_test.go:113: Last executed (34): ALTER TABLE ident.ident3 ADD IF NOT EXISTS TIME BIT ( -441 ) ARRAY
rsg_test.go:113: Last executed (35): ALTER TABLE ident.ident4 ALTER ident SET GENERATED_BY_DEFAULT BY DEFAULT
rsg_test.go:113: Last executed (36): ALTER TABLE ident.ident5 RENAME CONSTRAINT ident TO VALUES
rsg_test.go:113: Last executed (37): ALTER TABLE ident.ident6 ALTER ISERROR DROP NOT NULL
rsg_test.go:113: Last executed (38): ALTER TABLE ident.ident7 DROP CONSTRAINT ident CASCADE
rsg_test.go:113: Last executed (39): ALTER TABLE ident.ident0 EXPERIMENTAL_AUDIT SET OFF
rsg_test.go:113: Last executed (40): ALTER TABLE ident.ident1 ALTER CONSTRAINT JOBS error
rsg_test.go:113: Last executed (41): ALTER TABLE ident.ident2 ALTER COLUMN DEC ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY
rsg_test.go:113: Last executed (42): ALTER TABLE ident.ident3 ALTER COLUMN GROUPING DROP STORED
rsg_test.go:113: Last executed (43): ALTER TABLE ident.ident4 ALTER PARTIAL SET NOT VISIBLE
rsg_test.go:113: Last executed (44): ALTER TABLE ident.ident5 ALTER COLUMN VALUES ADD GENERATED_BY_DEFAULT BY DEFAULT AS IDENTITY ( START WITH 443 )
rsg_test.go:113: Last executed (45): ALTER TABLE ident.ident6 ADD ident OFF . ident ARRAY
rsg_test.go:113: Last executed (46): ALTER TABLE ident.ident7 DROP COLUMN IF EXISTS IGNORE_FOREIGN_KEYS RESTRICT
rsg_test.go:113: Last executed (47): ALTER TABLE ident.ident0 EXPERIMENTAL_AUDIT SET READ WRITE
rsg_test.go:113: Last executed (48): ALTER TABLE ident.ident1 ALTER THROTTLING ADD GENERATED_ALWAYS ALWAYS AS IDENTITY ( )
rsg_test.go:113: Last executed (49): ALTER TABLE ident.ident2 ALTER INTERVAL SET INCREMENT -259
rsg_test.go:116: Currently active statements: map[]
rsg_test.go:593: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxSchemaChangeColumn3613286674
--- FAIL: TestRandomSyntaxSchemaChangeColumn (303.58s)
```
Help
See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)
Same failure on other branches
- #173856 sql/tests: TestRandomSyntaxSchemaChangeColumn failed [C-test-failure O-robot T-sql-foundations branch-release-25.2.23-rc release-blocker]
/cc @cockroachlabs/sql-foundations
[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestRandomSyntaxSchemaChangeColumn.*&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 by running TestRandomSyntaxSchemaChangeColumn in sql/tests and inspect rsg_test.go around the reported lines 113 and 593. Review the linked TeamCity logs and artifacts, the internal Go test failure investigation guide, and related issue #173856. Done means the reported failure is understood and the test passes on the affected branch.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, testing-qa
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100