Actions
Support #3863
closed
DB Update Fails: Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'
Status:
Closed
Priority:
Normal
Assignee:
Carsten Rose
Target version:
-
Start date:
07.06.2017
Due date:
% Done:
0%
Estimated time:
Discuss:
Prio Planung:
Vote:
Description
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 almost 7 years ago
- 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.
Actions