phpmyadmin/phpmyadmin
Vedi su GitHub[Bug]: Adding system versioning to a table makes foreign keys unusable
Open
#20.095 aperta il 11 feb 2026
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
- 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;
- go to
structure=>relation view - the foreign keys are not listed
- in the
browsetab, there is no link in the data for those foreign keys - but
SHOW CREATE TABLE tstill 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