• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 46
  • Last Modified:

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?
0
Mark Lewis
Asked:
Mark Lewis
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now