Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.14, 10.3.15, 10.3, 10.4
-
None
-
Windows 10 64 bit
Description
For some reason following query returns empty result set in 10.3.14 and 10.3.15 version.
SELECT table_name,table_name, ordinal_position
FROM information_schema.table_constraints t
JOIN information_schema.key_column_usage k
USING(constraint_name,table_name)
WHERE t.constraint_type='PRIMARY KEY'
AND t.table_schema= 'demodb'
AND k.table_schema= 'demodb'
order by table_name,ordinal_position;
But following does work:
SELECT * FROM (SELECT t.table_name, k.column_name, ordinal_position
FROM information_schema.table_constraints t
JOIN information_schema.key_column_usage k
USING(constraint_name,table_name)
WHERE t.constraint_type='PRIMARY KEY'
AND t.table_schema= 'demodb'
AND k.table_schema= 'demodb') tmp
order by table_name,ordinal_position