4 Dec
2019
4 Dec
'19
10:54 a.m.
Well, I've pushed that logic. Looks about 2 lines prettier ср, 4 дек. 2019 г., 19:19 Sergei Golubchik <serg@mariadb.org>:
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@mariadb.org