Log of /moodle/lib/dml/mysqli_native_moodle_database.php

MDL-20625 new delegated transaction support in DML

MDL-20734 normalise_value() - moving from private to protected everywhere and abstracting

MDL-20734 empties and zeros - implemented the normalise_value() function in
mysql and postgres to perform central normalisation of values for insert/
update/set_field. Now all DB drivers cast empty strings to 0 when working
with numeric columns (integer and decimal)

MDL-19474 One year and a half ago we started designing and implementing our new databse abstraction layer which included brand new moodle native drivers. Today we are finally removing old legacy drivers that were still using adodb internally. From now on the adodb will be used only in some authentication and enrolment plugins, we are probably going to drop adodb there too later in 2.x. Thanks everybody who helped test and improve our new drivers, even bigger thanks to all the great developers who created ADOdb!

begin_sql() now uses current storage engine info to know if transactions are going to work
(only InnoDB detected as trasaction-able)

MDL-15181 temporary tables - now mysql driver uses the temptables object to
solve its carences handling temp tables.

Enforce strict mode in mysqli session in order to get consistent behaviour
in various operations (casting, altering columns...)

NOBUG. Add 2 missing fix_sql_params() calls in insert/update_record_raw()
causing named and qm parameters to be mixed in the same query. Curiously,
due to the ordered nature of the qms it wasn't breaking, but was incorrect.

MDL-14990 implemented query loggin in new native DML drivers

MDL-14679 fixing old TODOs

MDL-19470 fixing DML license headers

MDL-19470 detection of nested transactions, only one level allowed

MDL-14992 sessions - proper destructor method and fixed dispose() behaviour.

MDL-19010 reverting last commit- DML must throw exceptions - fix the calling code

MDL-19010 Fixing upgrade code to work with mysql. Also returning false when get_recordset_sql hits a SQL error, instead of crashing during upgrade with a Fatal error: Exception thrown without a stack frame in Unknown on line 0

lib/dml: new compatibility method sql_cast_2signed for when MySQL thinks that 1 * -1 = 18446744073709551615

MDL-18244 sql_length() - new cross-db function to calculate the length in chars of any expression ; from 19_STABLE

MDL-18194 detect if driver install before trying to create db

MDL-17458 rewritten installer

MDL-14992 pg session locking (8.2 and later only), refactoring and db session not default yet in new installs

MDL-14992 pg sessions advisory locks accept only integers :-( trying to find a workaround

MDL-14992 towards better db sessions - session locking for mysql

MDL-17880 removed debug code, grr

MDL-17880 fixed removing of leading 0 from strings when emulating bounds in DML

MDL-17859 implemented caching in get_tables()

MDL-17522 improved dml tests, fixed sql LIMIT support in native drivers

MDL-14679 removed unnecessary CFG from native drivers

Added create_database() method (to be used at least by Win32 installers)

MDL-14679 improved limit handling

MDL-17377 DML: prefixless database regression in new native drivers

MDL-15837 more dml unit tests

MDL-17317 DML: more exceptions - now in connect too

MDL-17347 reintroduced duplicate tests in get_records_sql()

MDL-17354 moved reset_sequence into dbmanager

MDL-17317 DML: Exceptions used by all drivers now :-) expect some more commits/cleanup soon

MDL-16920 mysqli: refactored driver to use new query logging

MDL-16920 mysqli: refactored driver to use new query logging

MDL-16669 dml: improved sql_substring(), added unit tests

MDL-17036 dml:  dbpersist moved into dboptions

MDL-14679 dml/native_mysqli transactions support

MDL-14679 dml/native_mysqli fixed sql concat

MDL-14679 dml/native_mysqli adding lang strings

MDL-14679 dml/native_mysqli fixed decimal columns - unittests now complete without errors!

MDL-14679 dml/native_mysqli implemented blob type

MDL-14679 dml/native_mysqli fixed column cache

MDL-14679 dml/native_mysqli improvements

MDL-14679 dml/native_mysqli new experimental native driver for mysqli - not fully finished yet, seems to work fine