Error 5502 (42602) on initializing with StarRocks

[Ferroman]

goose_db_version creation — goose wraps it in a transaction; StarRocks rejects DDL in transactions resulting in error:

✗ goose -dir migrations/starrocks starrocks "root:password@tcp(starrocks-mysql.domain.co:9030)/analytics?interpolateParams=true" up
2026/02/23 12:08:58 goose run: Error 5502 (42602): Getting analyzing error. Detail message: Unknown table 'analytics.goose_db_version'.; Error 5305 (25P01): Getting analyzing error. Detail message: Explicit transaction only support begin/commit/rollback/insert/update/delete/set/select statements.

Used version:

goose --version
goose version: v3.27.0

[mfridman]

I suspect we'll need to expose a flag like --isolate-ddl on the CLI, which is how we test it via the goose.Provider

https://pkg.go.dev/github.com/pressly/goose/v3#WithIsolateDDL

goose/internal/testing/integration/database_test.go

Line 146 in de28e04

testDatabase(t, database.DialectStarrocks, db, "testdata/migrations/starrocks", goose.WithIsolateDDL(true))

[Ferroman]

I guess so. This issue basically blocks any schema migrations for StarRocks.

[boblannon]

@mfridman If this was added as a flag, wouldn't that flag always need to be set when using starrocks? Couldn't it then be the default behavior in this context?

[mfridman]

Yep, I was thinking about it holistically.

But to unblock this specific issue, if it's StarRocks then we just set it by default. Should be an easy fix, and happy to review a change (sorry this just hasn't been the highest priority, since I don't use StarRocks .. but we try our best to support it for the community with hopefully a bit of help).

[mfridman]

Oh, actually this requires updating the main program to use the goose provider which has all the fancy locking primitives.

Alright, give me until the end of the week and I'll try and hammer this out. I do want to incrementally add that provider code anyways!

[boblannon]

Wow, that would be awesome, thanks! As far as I know, goose is the only migration tool with explicit starrocks support, so I appreciate this, and I'm sure the rest of the starrocks user community will too.