← Back to team overview

maria-developers team 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.
>
> Regards,
> Sergei
> VP of MariaDB Server Engineering
> and security@xxxxxxxxxxx
>

References