On 1/14/21 6:42 PM, Surafel Temesgen wrote: > Hi Simon, > Thank you for all the work you does > > On Mon, Jan 11, 2021 at 5:02 PM Simon Riggs <simon.ri...@enterprisedb.com> > wrote: > >> >> >> * Anomalies around use of CURRENT_TIMESTAMP are not discussed or resolved. >> Probably need to add a test that end_timestamp > start_timestamp or ERROR, >> which effectively enforces serializability. >> >> > > This scenario doesn't happen.
It *does* happen and the standard even provides a specific error code for it (2201H). Please look at my extension for this feature which implements all the requirements of the standard (except syntax grammar, of course). https://github.com/xocolatl/periods/ -- Vik Fearing