sql: Support SELECT FOR UPDATE

[tlvenn]

Hi all,

I tried to find an issue already covering this given I am surprised it did not surface yet but I failed..

Ecto (Elixir ORM) has recently introduced on master support for multiple concurrent migrators and they do this by locking the migration table using a SELECT FOR UPDATE statement which is not supported by CDB at the moment.

elixir-ecto/ecto@d28aeba

I suspect other migration tool will behave the same and I checked Flyway for example, and they do leverage it as well

https://github.com/flyway/flyway/blob/eb14b2d84f37a7396e30fbc4da285959ea50512c/flyway-core/src/main/java/org/flywaydb/core/internal/dbsupport/postgresql/PostgreSQLTable.java#L60

Is there any chance to support this ?

[tlvenn]

And somehow missed #6583

Sorry for the noise, will close this issue and will try to work with Ecto so that concurrent migrators are optional.

Thanks