Oracle 11g LIMIT 10000 OFFSET 0 (ActiveRecord::StatementInvalid)

anlek / mongify

Mongify allows you to map your data from a sql database and into a mongodb document database.

http://github.com/anlek/mongify

MIT License

317 stars 82 forks source link

Open ramananswaminathan opened 6 years ago

ramananswaminathan commented 6 years ago

Hi Andrew, When i tried to use Oracle enhanced adapter, it throws the error

"Oracle 11g LIMIT 10000 OFFSET 0 (ActiveRecord::StatementInvalid)"

The select statement having the syntax "LIMIT 10000 OFFSET 0" is not supported by oracle. I guess the same issue is reported in issue#150.

Is there a workaround or fork available for this issue?

Thanks, Swami

anlek commented 6 years ago

Sorry, but that's outside of my testing abilities. :( I have not heard of any workaround either.