Link to home
Start Free TrialLog in
Avatar of Mike Paradis
Mike Paradis

asked on

Strange result after an information_schema query

Doing some work on a MySQL DB I found that a simple query like the following:
select
	table_name
from
	information_schema.KEY_COLUMN_USAGE
where
	table_schema = 'db-name'
	and referenced_table_name = 'table';

Open in new window

was showing a list like the following:
 table_name 	
sql.php?table=table-one&token=3d38d6f1a9fc11efb91793b8d6745f04
sql.php?table=table-two&token=3d38d6f1a9fc11efb91793b8d6745f04
sql.php?table=table-three&token=3d38d6f1a9fc11efb91793b8d6745f04

Open in new window

instead of a simple list of the tables referenced by the table "table" like this:
 table_name 	
table-one
table-two
table-three

Open in new window


Is there any acceptable explanation for this?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Kindly check other Information_schema queries and if they are displaying values correctly then this seems like a bug.
If not applied, try applying the latest patches and check it out once..
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial