[MDEV-32493] support foreign keys in tables partitioned by system time Created: 2023-10-17 Updated: 2024-01-18 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Versioned Tables |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major |
| Reporter: | Sergei Golubchik | Assignee: | Aleksey Midenkov |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | Performance, foreign-keys | ||
| Issue Links: |
|
||||||||
| Description |
|
foreign keys aren't supported for partitioned tables yet (MDEV-12483) fixing this is a rather big task. but a special case of tables partitioned by system time is much simpler — it's can work by adding foreign keys only to the current partition. as partitioning system versioned tables is pretty much the only way to make them faster, this is an important use case that justifies a special fix. |