activerecord-cockroachdb-adapter icon indicating copy to clipboard operation
activerecord-cockroachdb-adapter copied to clipboard

AOST (As of System Time) Queries: support the other parameter types like an interval or any of the helper functions

Open nollenr opened this issue 2 years ago • 1 comments

The current commit only supports passing in an explicit timestamp as the parameter to AS OF SYSTEM TIME. It doesn't look to support the other parameter types like an interval or any of the helper functions.

nollenr avatar Oct 23 '23 19:10 nollenr

@nollenr absolutely. I wouldn't suggest using this feature anyway as the is per query, and it is likely you are using transactions.

I don't have acces to a laptop now but I'll try to make some pseudo code :

ApplicationRecord.connection.execute("set transaction ...")

Please refer to the doc you mentioned for the SQL syntax!

We could consider more features in that direction but seen the small footprint of this code i don't really see the benefits

BuonOmo avatar Oct 29 '23 20:10 BuonOmo

Closing for now due to low activity. Feel free to comment below if the feature feels important

BuonOmo avatar Sep 03 '24 15:09 BuonOmo