search

ebean-orm / ebean-migration

DB Migration runner (similar to Flyway) which can be used standalone or with Ebean (run migrations on EbeanServer start)
Apache License 2.0
9 stars 5 forks source link

Option to disable "FOR UPDATE" #37

Closed thibaultmeyer closed 6 years ago

thibaultmeyer commented 6 years ago

It could be nice to add option to disable usage of FOR UPDATE on the queries like

select id, mtype, mstatus, mversion, mcomment, mchecksum, run_on, run_by, run_time from db_migration order by id for update

It will allow usage of database like CockroachDB who is using PostgreSQL driver but don't have all sub-feature like FOR UPDATE.

rbygrave commented 6 years ago

Pretty sure you can ... by specifying a resource to override the 'platform selected' resource (that has the sql in it).

It is also 'platform aware' ... so could make it CockroachDB aware.

rbygrave commented 6 years ago

Closing this as we have merged in https://github.com/ebean-orm/ebean-migration/pull/38

Great work, thanks.