Support #3863
closed
DB Update Fails: Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'
Added by Carsten Rose almost 7 years ago.
Updated almost 7 years ago.
Description
QFQ in combination with dbq2/form2 throws an exception on load:
Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'
- Status changed from New to In Progress
Check: https://mariadb.com/kb/en/mariadb/server-system-variables/#lower_case_table_names
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.
- Status changed from In Progress to Closed
Also available in: Atom
PDF