DB Update Fails: Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'
QFQ in combination with dbq2/form2 throws an exception on load:
Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'
Updated by Carsten Rose over 3 years ago
- Status changed from New to In Progress
The problem: tablenames might be case insesitive. In DB 'math' we have 'form' (dbq2) and 'Form' (QFQ). For regular queries (SELECT, INSERT, UPDATE, ...) this seems not to be a problem under Linux. But for "SHOW TABLE STATUS WHERE Name='Form'" (even udner linux) this breaks.
Approach to fix:
1) the DB-UPDATE check will handle multiple matching tables automatically
2) the DB_UPDATE check can be switched off.