maria-developers team mailing list archive
Mailing list archive
Re: ef2519fee4e: MDEV-16546 System versioning setting to allow history modification
On Tue, Dec 1, 2020 at 7:54 PM Sergei Golubchik <serg@xxxxxxxxxxx> 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?
> > 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
> VP of MariaDB Server Engineering
> and security@xxxxxxxxxxx
All the best,