Constraints shown from different table

[mokraemer]

Adminer version:5.3.0
Compiled:mysqli
Driver:
Database version: Maria 11.4.7

If I show the structure of some tables there is a (new) area with all defined constraints. Sometimes this area is filled with the constraints from a different table.
My guess is, this happens, when the constraint has the same name.

By excuting show create table you can see the constraint is not set on this table and table_information_schema is also correct. Maybe some caching issue, or query is missing the table/database on information_schema (or where you get the information)

[vrana]

Please provide a reproducible example. Give me a minimal SQL export which causes this.

[vrana]

There's no caching here and the query is:

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME =

[mokraemer]

I'd like to reopen this issue.
Note this is MariaDB - constraints in mariadb do not have to be unique in one database.

CREATE TABLE `A` (
`ID` mediumint(8) unsigned NOT NULL,
  CONSTRAINT `Basic` CHECK (ID>0)
) ENGINE=Aria 
create table B(
 `XX` int(10) unsigned NOT NULL,
 CONSTRAINT `basic` CHECK(XX>0)
)ENGINE=Aria 

Open Adminer. See Checks of table A or B
Both checks are shown.

SELECT *
FROM `TABLE_CONSTRAINTS`
WHERE `TABLE_NAME` IN ("A","B")

CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_SCHEMA	TABLE_NAME	CONSTRAINT_TYPE
def	demo_marc	Basic	demo_marc	A	CHECK
def	demo_marc	basic	demo_marc	B	CHECK