Ok, thanks. On Fri, Feb 8, 2019 at 10:36 PM Sergei Golubchik <s...@mariadb.org> wrote:
> Hi, Nikita! > > On Feb 08, Nikita Malyavin wrote: > > > > > +# auto_increment field overflow > > > > +create or replace table t (id tinyint auto_increment primary key, > > > > +s date, e date, period for apptime(s,e)); > > > > +insert into t values(127, '1999-01-01', '2018-12-12'); > > > > +delete from t for portion of apptime from '2000-01-01' to > '2018-01-01'; > > > > +ERROR 22003: Out of range value for column 'id' at row 1 > > > > > > add select * from t here, please > > > > > > > > > +# same for trigger case > > > > +delete from t for portion of apptime from '2000-01-01' to > '2018-01-01'; > > > > +ERROR 22003: Out of range value for column 'id' at row 1 > > > > > > and here > > > and select from the log_tbl too > > > > Ahhh, the results differ for Innodb and MyISAM because of transactions. > > > > Well, I came across with solution, but it may look cumbersome. I've put > the > > queries in while loop and cycle the engines. > > Please take a look at it in delete.test. Maybe You'll want it to be in > > different file, or have any better idea/suggestion. > > I see. Then just add it commented, like > > #select * from t; > #select * from log_tbl order by id; > > When I'll merge it, I'll uncomment and will see for myself how they > differ and if it's worth keeping them. > > Generally the usual solution is to add an .rdiff file, but I can do that > myself, just want to see the difference in results first. > > Regards, > Sergei > Chief Architect MariaDB > and secur...@mariadb.org > -- Yours truly, Nikita Malyavin
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp