Paul Kuruvilla

@kashifsoofi could you confirm what version of dbmate you're running?

The `transaction:false` option was added in https://github.com/amacneil/dbmate/releases/tag/v1.5.0, I want to make sure that you're running a version that includes that change.

Got it, thanks! Will see if I can replicate.

@kashifsoofi the example in the description has only one statement - could you paste an example file here that triggers the error?

> https://github.com/amacneil/dbmate/issues/285#issuecomment-1077783065 @kashifsoofi if you use `transaction:false` in the script in that comment, does the error still occur? i.e. something like this: ``` -- migrate:up transaction:false create table users (...

Would love to help - I've been using dbmate in a few projects, and recently published a buildpack for using it on Heroku: https://github.com/codecrafters-io/heroku-buildpack-dbmate. Added notifications for all activity on...

@amacneil mind granting me triage access? I'd like to close resolved issues, example: https://github.com/amacneil/dbmate/issues/275

Related: https://github.com/cockroachdb/cockroach/issues/20296

@NLKNguyen have you tried using SQL comments? i.e. something like this: ```sql -- migrate:up CREATE TABLE foo; -- migrate:down DROP TABLE foo; -- testing -- CREATE TABLE foobar; ```

(Note: I haven't tested the above, but I imagine that'd work)