Bug #23956 "Incorrect table name" on selecting triggers
Submitted: 3 Nov 2006 18:13 Modified: 5 Dec 2006 12:28
Reporter: Christian Brackmann Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.22-community-nt OS:Windows (Win2003)
Assigned to: CPU Architecture:Any
Tags: 'Incorrect table name' trigger

[3 Nov 2006 18:13] Christian Brackmann
Description:
Hi,

when I execute the following command on mysql:
"SELECT * FROM TRIGGERS T;"

It gives me the following result:
"Incorrect table name 'banco'"

I can't view any registries at the table.
There is no table named 'banco' in my database.

How to repeat:
Executing the command:
"SELECT * FROM TRIGGERS T;"

Suggested fix:
I should visualize all triggers of the server.
[5 Nov 2006 12:28] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.27. In case of the same problem, try to search for any files like banco.* in your data directory and all the subdirectories. Inform about the results.
[6 Dec 2006 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".