-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
3.4.1
-
None
-
MOODLE_34_STABLE
The SQL statement builder is passing numeric parameters to prepared statements as quoted strings, making the query optimizer (MySQL) to ignore the indexed numeric fields and there are hundreds of unused indices as reported by the MySQL statistics. I consider this to affect other databases as well.
Examples include the auto-increment field id of any table, courseid, userid etc.
- has been marked as being related by
-
MDLSITE-1007 Debugging: Error: mdb->get_record() found more than one record!
-
- Closed
-