phpmyadmin/phpmyadmin

[Bug]: Adding system versioning to a table makes foreign keys unusable

Open

#20.095 aperta il 11 feb 2026

Vedi su GitHub
 (4 commenti) (1 reazione) (0 assegnatari)PHP (3454 fork)batch import
Awaiting Maintainer ResponseBugaffects/5.2help wanted

Metriche repository

Star
 (6886 star)
Metriche merge PR
 (Merge medio 2g 17h) (11 PR mergiate in 30 g)

Descrizione

Describe the bug

When I add system versioning to a MariaDB table, phpmyadmin acts as if there was no more foreign keys on this table, but they are still there (doing versioning without partitioning)

How to Reproduce

  1. Add system versioning without partition to a table :
ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START,
              ADD COLUMN te TIMESTAMP(6) GENERATED ALWAYS AS ROW END,
              ADD PERIOD FOR SYSTEM_TIME(ts, te),
              ADD SYSTEM VERSIONING;
  1. go to structure => relation view
  2. the foreign keys are not listed
  3. in the browse tab, there is no link in the data for those foreign keys
  4. but SHOW CREATE TABLE t still shows the foreign key CONSTRAINT

Expected behavior

I expected foreign keys to be still there with system versioning (without partition)

Screenshots

No response

Operating System

Linux

Web Server

Apache/2.4.66 (Debian)

Database Server

MariaDB

Database version

11.8.5-MariaDB-ubu2404

PHP version

8.3.30

phpMyAdmin version

5.2.3

browser

Firefox 147.0.3

Additional context

It may be related to the fact that SHOW CREATE TABLE adds a line PERIOD FOR SYSTEM_TIME (ts, te), before the constraints

Guida contributor