I am not sure about this test. Might fail on oracle but we need to place something as local_offset is removed.

I will test this using oracle adaptor.

Or may be @yahonda want's to have a look