Skip Menu |

This queue is for tickets about the DB-Introspector CPAN distribution.

Report information
The Basics
Id: 7499
Status: open
Priority: 0/
Queue: DB-Introspector

People
Owner: Nobody in particular
Requestors: Bernhard.Schmalhofer [...] biomax.de
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 0.07
Fixed in: (no value)



Subject: 'SHOW INDEX' in MySQL/Introspector.pm
Hi, I am using DB::Introspector with MySQL 3.23.58 . In a migration script I'm checking wether indexes on a column exist or not. For MySQL there seems to be invalid SQL sytax used for that. The fix that works for me is to replace 'SHOW INDEXES FROM' by 'SHOW INDEX FROM' in DB::Introspector::MySQL::Introspector::_fetch_indexes(). CU, Bernhard
[guest - Fri Aug 27 11:28:44 2004]: Thanks for fixing, I am absolutely amazed how fast this ticket was resolved. CU, Bernhard