← Back to team overview

maria-developers team mailing list archive

Re: 6ac19d09c66: MDEV-16978 Application-time periods: WITHOUT OVERLAPS


Hi, Nikita!

On Dec 04, Nikita Malyavin wrote:
> Another case:
> suppose you have to rows in table with periods (a<b<c<d):
> (a, c),
> (c, d).
> Let us update (c,d) --> (b,d). I call it "move left".
> ha_index_read_map with period_start < d will return (c,d). Again check
> is_update, and call ha_index_prev()

Yes, for update you might need a second check, if the first search will
find the old row. This will be always the case, no matter how you index.
In your patch you also have extra checks for update.

VP of MariaDB Server Engineering
and security@xxxxxxxxxxx

Follow ups