Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.14, 10.3.15, 10.3(EOL), 10.4(EOL)
-
None
-
Windows 10 64 bit
-
Not for Release Notes
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