maria-developers team mailing list archive
Mailing list archive
Re: 6ac19d09c66: MDEV-16978 Application-time periods: WITHOUT OVERLAPS
Well, I've pushed that logic. Looks about 2 lines prettier
ср, 4 дек. 2019 г., 19:19 Sergei Golubchik <serg@xxxxxxxxxxx>:
> 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