nm/period-fk-linear : lp:maria : Git : Code : MariaDB

Get this branch:: git clone -b nm/period-fk-linear https://git.launchpad.net/maria

Branch merges

Branch information

Name:: nm/period-fk-linear

Repository:: lp:maria

Recent commits

0b348fc... by Nikita Malyavin on 2020-01-21

Period: add versioning combination

7975dd1... by Nikita Malyavin on 2020-01-21

MDEV-16983 Application-time periods: foreign key PART 4/3

extra SHOW CREATE patch with ad-hoc table prelocking specific exclusively to SHOW CREATE

this will be rewritten after MDEV-21052 and after FK's will be stored in frm/frk

6918b68... by Nikita Malyavin on 2019-12-24

MDEV-16983 Application-time periods: foreign key PART 3/3

Support self-referencing foreign keys

d6b24b7... by Nikita Malyavin on 2019-12-16

MDEV-16983 Application-time periods: foreign key PART 2/3

Add correct update check, which preserves referential integrity on not-updated part of period

18fad2d... by Nikita Malyavin on 2019-11-29

MDEV-16983 Application-time periods: foreign key PART 1/3

This work adds support for FOREIGN KEYS for SQL:2011 Application-time periods feature.
* Two hidden keys are added in key matching a referred foreign key;
* Referential integrity check is done completely on sql layer, in handler;
* A new struct FOREIGN_KEY is introduced to store a prelocked referential metadata in TABLE

Limitations:
* Only versionde-to-versioned and plain-to-plain references are supported at this moment
* innodb: a flag denoting a period is added to FK flags,
see dict_create_add_foreign_to_dictionary() and dict_load_foreign().
In this way only one period per table is supported, and it's quite poorly scalable.

In this commit:
* Update is treated as delete + insert which causes false-positives. (will bi fixed in PART 2)
* Self-referencing tables have false-negatives during deletes, since the same row could be
fetched during lookup (will be fixed in PART 3)

17a8b01... by Nikita Malyavin on 2020-01-20