Menu
▾
▴
#4966 (ok 4.5) MySQL constraint violation errors are not shown when DebugSQL is on
Go to sakila (db strcuture) and try deleting film table with foreign key constraints enabled. Table should not be deleted since foreign key constraints prevent that from happening. However, row corresponding to film table is removed and upon refreshing appears again.
When DebugSQL is on, PMA_DatabaseInterface::getError() is called to record if there is an error. This calls PMA_DatabaseInterface::formatError() to format error message if there is in fact an error. However, formatError() issues a new query to get the variable 'language' which erases the original error message causing this bug