-
Bug
-
Resolution: Fixed
-
Major
-
1.7, 1.8
-
None
-
MSSQL & ORACLE
-
Microsoft SQL, Oracle
-
MOODLE_17_STABLE, MOODLE_18_STABLE
-
MOODLE_18_STABLE
In the ldap authentication plugin, the sync_users() function, has some conditional code to use temporal tables under MySQL and PostgreSQL, but there isn't corresponding code for MSSQL and Oracle.
While it shouldn't be problematic for Oracle:
create global temporary table $CFG->prefix .'extuser'
......
(on commit preserve rows?)
MSSQL has a limitatio: All the temp tables are named with '#' being the 1st char in the name. Obviously this breaks current code and $CFG->prefix usage
Any idea?
- duplicates
-
MDL-7525 auth_sync_users() only knows mysql and postgres
-
- Closed
-
- has been marked as being related by
-
MDL-7525 auth_sync_users() only knows mysql and postgres
-
- Closed
-
- will be (partly) resolved by
-
MDL-8590 Auth cleanup - META
-
- Closed
-
- will help resolve
-
MDL-8023 CLONE -auth_ldap_bulk_insert() potential problem for MSSQL and Oracle
-
- Closed
-