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?
LVL 1
Mark LewisAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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..
0
ste5anSenior DeveloperCommented:
Is there any acceptable explanation for this?
Sure:

- you're working with a buggy web front-end to query your database
- the tables where created by a buggy web front-end

So: did you query your database with the MySQL Workbench? Which is the tool you should use in most cases anyway.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MariaDB

From novice to tech pro — start learning today.