Problem with Information Schema in MySQL 5.1.45-3 (5.0.51a-24+lenny3 works)
Posted by: Florian Bittner
Date: June 07, 2010 03:21AM

Hi,

for developement i cloned my php (prado framework) application to a few servers and desktops. Everywhere it works find except on my laptop with sidux (debian sid).

The following query is handled different with my newer mysqld version:

Code:

SELECT CONSTRAINT_NAME as con, COLUMN_NAME as col, REFERENCED_TABLE_SCHEMA as fkschema, REFERENCED_TABLE_NAME as fktable, REFERENCED_COLUMN_NAME as fkcol FROM `INFORMATION_SCHEMA`.`KEY_COLUMN_USAGE` WHERE REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = "status";


With mysqld 5.0.51a-24+lenny3 the response is:

"Empty set (0.00 sec)"


5.1.45-3 says:

"ERROR 1109 (42S02): Unknown table 'status' in information_schema"


Can anyone help on this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with Information Schema in MySQL 5.1.45-3 (5.0.51a-24+lenny3 works)
8205
June 07, 2010 03:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.