Hi, Sergei! On Tue, Dec 1, 2020 at 7:54 PM Sergei Golubchik <s...@mariadb.org> wrote: > > Hi, Aleksey! > > On Nov 24, Aleksey Midenkov wrote: > > > > And mysqldump should take care of setting system_versioning_insert_history > > sysvar. Right? Is everything else in the task description OK? > > Right. > > > 1. Add server variable system_versioning_insert_history which will allow > > INSERT history rows. > > 2. If secure_timestamp is YES or REPLICATION, > > system_versioning_insert_history does not have effect. If secure_timestamp > > is SUPER, system_versioning_insert_history requires special privilege (same > > as for setting current timestamp). > > Yes. It is correct, but could be expressed simpler: > > when @@system_versioning_insert_history=TRUE, one can directly insert > into row_start/row_end columns iff one can set @@timestamp variable. > > In other words, if one can create an arbitrary history by manipulating > @@timestamp variable, @@system_versioning_insert_history allows to do it > more conveniently. But if one cannot - he cannot.
Then do we need additional setting @@system_versioning_insert_history? Iff one can manipulate history via @@timestamp variable let him set row_start/row_end columns. > > Regards, > Sergei > VP of MariaDB Server Engineering > and secur...@mariadb.org -- All the best, Aleksey Midenkov @midenok _______________________________________________ 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