WebSVN – Moodle – Diff – /lib/dml/moodle_database.php

 define('SQL_PARAMS_QM', 2);
 /** SQL_PARAMS_DOLLAR - Bitmask, indicates $1, $2, ... type parameters are supported by db backend. */
+define('SQL_PARAMS_DOLLAR', 4);
+/** SQL_INT_MAX - Size of a large integer with cross database platform support. */
-define('SQL_PARAMS_DOLLAR', 4);
+define('SQL_INT_MAX', 9999999999);
 /** SQL_QUERY_SELECT - Normal select query, reading only. */
 define('SQL_QUERY_SELECT', 1);
     /**
      * Loads and returns a database instance with the specified type and library.
+     *
      * The loaded class is within lib/dml directory and of the form: $type.'_'.$library.'_moodle_database'
+     *
-     * @param string $type Database driver's type. (eg: mysqli, pgsql, mssql, sqldrv, oci, etc.)
+     * @param string $type Database driver's type. (eg: mysqli, pgsql, mssql, sqldrv, etc.)
      * @param string $library Database driver's library (native, pdo, etc.)
      * @param bool $external True if this is an external database.
      * @return ?moodle_database driver object or null if error, for example of driver object see {@see mysqli_native_moodle_database}
      */
     public static function get_driver_instance($type, $library, $external = false) {
+    }
     /**
      * Returns the database family type. (This sort of describes the SQL 'dialect')
      * Note: can be used before connect()
-     * @return string The db family name (mysql, postgres, mssql, oracle, etc.)
+     * @return string The db family name (mysql, postgres, mssql, etc.)
      */
     abstract public function get_dbfamily();
     /**
      * Returns a more specific database driver type
      * Note: can be used before connect()
-     * @return string The db type mysqli, pgsql, oci, mssql, sqlsrv
+     * @return string The db type mysqli, pgsql, mssql, sqlsrv
      */
     abstract protected function get_dbtype();
      * @param mixed $prefix string means moodle db prefix, false used for external databases where prefix not used
      * @param array $dboptions driver specific options
      * @return bool true
      * @throws dml_connection_exception if error
      */
-    abstract public function connect($dbhost, $dbuser, $dbpass, $dbname, $prefix, array $dboptions=null);
+    abstract public function connect($dbhost, $dbuser, $dbpass, $dbname, $prefix, ?array $dboptions=null);
     /**
      * Store various database settings
      * @param string $dbhost The database host.
      * @param string $dbname The name of the database being connected to.
      * @param mixed $prefix string means moodle db prefix, false used for external databases where prefix not used
      * @param array $dboptions driver specific options
      * @return void
      */
-    protected function store_settings($dbhost, $dbuser, $dbpass, $dbname, $prefix, array $dboptions=null) {
+    protected function store_settings($dbhost, $dbuser, $dbpass, $dbname, $prefix, ?array $dboptions=null) {
         $this->dbhost    = $dbhost;
         $this->dbuser    = $dbuser;
         $this->dbpass    = $dbpass;
         $this->dbname    = $dbname;
         $this->prefix    = $prefix;
      * @param string $dbname The name of the database being connected to.
      * @param array $dboptions An array of optional database options (eg: dbport)
+     *
      * @return bool success True for successful connection. False otherwise.
      */
-    public function create_database($dbhost, $dbuser, $dbpass, $dbname, array $dboptions=null) {
+    public function create_database($dbhost, $dbuser, $dbpass, $dbname, ?array $dboptions=null) {
         return false;
+    }
     /**
      * @param string $sql The query which is being debugged.
      * @param array $params The query parameters. (optional)
      * @param mixed $obj The library specific object. (optional)
      * @return void
      */
-    protected function print_debug($sql, array $params=null, $obj=null) {
+    protected function print_debug($sql, ?array $params=null, $obj=null) {
         if (!$this->get_debug()) {
             return;
+        }
         if (CLI_SCRIPT) {
             $separator = "--------------------------------\n";
      * @param string $table The table name that these conditions will be validated against.
      * @param array $conditions The conditions to build the where clause. (must not contain numeric indexes)
      * @return array An array list containing sql 'where' part and 'params'.
      * @throws dml_exception
      */
-    protected function where_clause($table, array $conditions=null) {
+    protected function where_clause($table, ?array $conditions=null) {
         // We accept nulls in conditions
         $conditions = is_null($conditions) ? array() : $conditions;
         if (empty($conditions)) {
      * Normalizes sql query parameters and verifies parameters.
      * @param string $sql The query or part of it.
      * @param array $params The query parameters.
      * @return array (sql, params, type of params)
      */
-    public function fix_sql_params($sql, array $params=null) {
+    public function fix_sql_params($sql, ?array $params=null) {
         global $CFG;
         require_once($CFG->libdir . '/ddllib.php');
     public function get_debug() {
         return $this->debug;
+    }
-    /**
-     * Enable/disable detailed sql logging
-     *
-     * @deprecated since Moodle 2.9
-     */
-    public function set_logging($state) {
-        throw new coding_exception('set_logging() can not be used any more.');
-    }
     /**
      * Do NOT use in code, this is for use by database_manager only!
      * @param string|array $sql query or array of queries
      * @param array|null $tablenames an array of xmldb table names affected by this request.
      * @return bool true
      * @param string $sql query
      * @param array $params query parameters
      * @return bool true
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    abstract public function execute($sql, array $params=null);
+    abstract public function execute($sql, ?array $params=null);
     /**
      * Get a number of records as a moodle_recordset where all the given conditions met.
+     *
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records (optional, required if $limitfrom is set).
      * @return moodle_recordset A moodle_recordset instance
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_recordset($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
+    public function get_recordset($table, ?array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
         list($select, $params) = $this->where_clause($table, $conditions);
         return $this->get_recordset_select($table, $select, $params, $sort, $fields, $limitfrom, $limitnum);
+    }
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records (optional, required if $limitfrom is set).
      * @return moodle_recordset A moodle_recordset instance.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_recordset_select($table, $select, array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
+    public function get_recordset_select($table, $select, ?array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
         $sql = "SELECT $fields FROM {".$table."}";
         if ($select) {
             $sql .= " WHERE $select";
+        }
         if ($sort) {
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records (optional, required if $limitfrom is set).
      * @return moodle_recordset A moodle_recordset instance.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    abstract public function get_recordset_sql($sql, array $params=null, $limitfrom=0, $limitnum=0);
+    abstract public function get_recordset_sql($sql, ?array $params=null, $limitfrom=0, $limitnum=0);
     /**
      * Get all records from a table.
+     *
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records in total (optional, required if $limitfrom is set).
      * @return array An array of Objects indexed by first column.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_records($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
+    public function get_records($table, ?array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
         list($select, $params) = $this->where_clause($table, $conditions);
         return $this->get_records_select($table, $select, $params, $sort, $fields, $limitfrom, $limitnum);
+    }
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records in total (optional, required if $limitfrom is set).
      * @return array of objects indexed by first column
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_records_select($table, $select, array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
+    public function get_records_select($table, $select, ?array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
         if ($select) {
             $select = "WHERE $select";
+        }
         if ($sort) {
             $sort = " ORDER BY $sort";
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records in total (optional, required if $limitfrom is set).
      * @return array of objects indexed by first column
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    abstract public function get_records_sql($sql, array $params=null, $limitfrom=0, $limitnum=0);
+    abstract public function get_records_sql($sql, ?array $params=null, $limitfrom=0, $limitnum=0);
     /**
      * Get the first two columns from a number of records as an associative array where all the given conditions met.
+     *
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records (optional, required if $limitfrom is set).
      * @return array an associative array
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_records_menu($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
+    public function get_records_menu($table, ?array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
         $menu = array();
         if ($records = $this->get_records($table, $conditions, $sort, $fields, $limitfrom, $limitnum)) {
             foreach ($records as $record) {
                 $record = (array)$record;
                 $key   = array_shift($record);
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records (optional, required if $limitfrom is set).
      * @return array an associative array
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_records_select_menu($table, $select, array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
+    public function get_records_select_menu($table, $select, ?array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0) {
         $menu = array();
         if ($records = $this->get_records_select($table, $select, $params, $sort, $fields, $limitfrom, $limitnum)) {
             foreach ($records as $record) {
                 $record = (array)$record;
                 $key   = array_shift($record);
      * @param int $limitfrom return a subset of records, starting at this point (optional).
      * @param int $limitnum return a subset comprising this many records (optional, required if $limitfrom is set).
      * @return array an associative array
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_records_sql_menu($sql, array $params=null, $limitfrom=0, $limitnum=0) {
+    public function get_records_sql_menu($sql, ?array $params=null, $limitfrom=0, $limitnum=0) {
         $menu = array();
         if ($records = $this->get_records_sql($sql, $params, $limitfrom, $limitnum)) {
             foreach ($records as $record) {
                 $record = (array)$record;
                 $key   = array_shift($record);
      *                        IGNORE_MULTIPLE means return first, ignore multiple records found(not recommended);
      *                        MUST_EXIST means throw exception if no record or multiple records found
      * @return stdClass|false a fieldset object containing the first matching record, false or exception if error not found depending on mode
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_record_select($table, $select, array $params=null, $fields='*', $strictness=IGNORE_MISSING) {
+    public function get_record_select($table, $select, ?array $params=null, $fields='*', $strictness=IGNORE_MISSING) {
         if ($select) {
             $select = "WHERE $select";
+        }
         try {
             return $this->get_record_sql("SELECT $fields FROM {" . $table . "} $select", $params, $strictness);
      *                        IGNORE_MULTIPLE means return first, ignore multiple records found(not recommended);
      *                        MUST_EXIST means throw exception if no record or multiple records found
      * @return mixed a fieldset object containing the first matching record, false or exception if error not found depending on mode
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_record_sql($sql, array $params=null, $strictness=IGNORE_MISSING) {
+    public function get_record_sql($sql, ?array $params=null, $strictness=IGNORE_MISSING) {
         $strictness = (int)$strictness; // we support true/false for BC reasons too
         if ($strictness == IGNORE_MULTIPLE) {
             $count = 1;
         } else {
             $count = 0;
      *                        IGNORE_MULTIPLE means return first, ignore multiple records found(not recommended);
      *                        MUST_EXIST means throw exception if no record or multiple records found
      * @return mixed the specified value false if not found
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_field_select($table, $return, $select, array $params=null, $strictness=IGNORE_MISSING) {
+    public function get_field_select($table, $return, $select, ?array $params=null, $strictness=IGNORE_MISSING) {
         if ($select) {
             $select = "WHERE $select";
+        }
         try {
             return $this->get_field_sql("SELECT $return FROM {" . $table . "} $select", $params, $strictness);
      *                        IGNORE_MULTIPLE means return first, ignore multiple records found(not recommended);
      *                        MUST_EXIST means throw exception if no record or multiple records found
      * @return mixed the specified value false if not found
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_field_sql($sql, array $params=null, $strictness=IGNORE_MISSING) {
+    public function get_field_sql($sql, ?array $params=null, $strictness=IGNORE_MISSING) {
         if (!$record = $this->get_record_sql($sql, $params, $strictness)) {
             return false;
+        }
      * @param string $select A fragment of SQL to be used in a where clause in the SQL call.
      * @param array $params array of sql parameters
      * @return array of values
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function get_fieldset_select($table, $return, $select, array $params=null) {
+    public function get_fieldset_select($table, $return, $select, ?array $params=null) {
         if ($select) {
             $select = "WHERE $select";
+        }
         return $this->get_fieldset_sql("SELECT $return FROM {" . $table . "} $select", $params);
+    }
      * @param string $sql The SQL query
      * @param array $params array of sql parameters
      * @return array of values
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    abstract public function get_fieldset_sql($sql, array $params=null);
+    abstract public function get_fieldset_sql($sql, ?array $params=null);
     /**
      * Insert new record into database, as fast as possible, no safety checks, lobs not supported.
      * @param string $table name
      * @param mixed $newvalue the value to set the field to.
      * @param array $conditions optional array $fieldname=>requestedvalue with AND in between
      * @return bool true
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function set_field($table, $newfield, $newvalue, array $conditions=null) {
+    public function set_field($table, $newfield, $newvalue, ?array $conditions=null) {
         list($select, $params) = $this->where_clause($table, $conditions);
         return $this->set_field_select($table, $newfield, $newvalue, $select, $params);
+    }
      * @param string $select A fragment of SQL to be used in a where clause in the SQL call.
      * @param array $params array of sql parameters
      * @return bool true
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    abstract public function set_field_select($table, $newfield, $newvalue, $select, array $params=null);
+    abstract public function set_field_select($table, $newfield, $newvalue, $select, ?array $params=null);
     /**
      * Count the records in a table where all the given conditions met.
+     *
      * @param string $table The table to query.
      * @param array $conditions optional array $fieldname=>requestedvalue with AND in between
      * @return int The count of records returned from the specified criteria.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function count_records($table, array $conditions=null) {
+    public function count_records($table, ?array $conditions=null) {
         list($select, $params) = $this->where_clause($table, $conditions);
         return $this->count_records_select($table, $select, $params);
      * @param array $params array of sql parameters
      * @param string $countitem The count string to be used in the SQL call. Default is COUNT('x').
      * @return int The count of records returned from the specified criteria.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function count_records_select($table, $select, array $params=null, $countitem="COUNT('x')") {
+    public function count_records_select($table, $select, ?array $params=null, $countitem="COUNT('x')") {
         if ($select) {
             $select = "WHERE $select";
+        }
         return $this->count_records_sql("SELECT $countitem FROM {" . $table . "} $select", $params);
+    }
      * @param string $sql The SQL string you wish to be executed.
      * @param array $params array of sql parameters
      * @return int the count
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function count_records_sql($sql, array $params=null) {
+    public function count_records_sql($sql, ?array $params=null) {
         $count = $this->get_field_sql($sql, $params);
         if ($count === false or !is_number($count) or $count < 0) {
             throw new coding_exception("count_records_sql() expects the first field to contain non-negative number from COUNT(), '$count' found instead.");
+        }
         return (int)$count;
      * @param string $select A fragment of SQL to be used in a WHERE clause in the SQL call.
      * @param array $params array of sql parameters
      * @return bool true if a matching record exists, else false.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function record_exists_select($table, $select, array $params=null) {
+    public function record_exists_select($table, $select, ?array $params=null) {
         if ($select) {
             $select = "WHERE $select";
+        }
         return $this->record_exists_sql("SELECT 'x' FROM {" . $table . "} $select", $params);
+    }
      * @param string $sql The SQL statement to execute.
      * @param array $params array of sql parameters
      * @return bool true if the SQL executes without errors and returns at least one record.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function record_exists_sql($sql, array $params=null) {
+    public function record_exists_sql($sql, ?array $params=null) {
         $mrs = $this->get_recordset_sql($sql, $params, 0, 1);
         $return = $mrs->valid();
         $mrs->close();
         return $return;
+    }
      * @param string $table the table to delete from.
      * @param array $conditions optional array $fieldname=>requestedvalue with AND in between
      * @return bool true.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    public function delete_records($table, array $conditions=null) {
+    public function delete_records($table, ?array $conditions=null) {
         // truncate is drop/create (DDL), not transactional safe,
         // so we don't use the shortcut within them. MDL-29198
         if (is_null($conditions) && empty($this->transactions)) {
             return $this->execute("TRUNCATE TABLE {".$table."}");
+        }
      * @param string $select A fragment of SQL to be used in a where clause in the SQL call (used to define the selection criteria).
      * @param array $params array of sql parameters
      * @return bool true.
      * @throws dml_exception A DML specific exception is thrown for any errors.
      */
-    abstract public function delete_records_select($table, $select, array $params=null);
+    abstract public function delete_records_select($table, $select, ?array $params=null);
     /**
      * Returns the FROM clause required by some DBs in all SELECT statements.
+     *
+    }
     /**
      * Returns whether we want to connect to slave database for read queries.
+     * @return bool Want read only connection
+     * @deprecated Since Moodle 5.0. See MDL-71257.
-     * @return bool Want read only connection
+     * @todo Final deprecation in Moodle 6.0. See MDL-83171.
+     */
+    #[\core\attribute\deprecated(
+        replacement: 'want_read_replica',
+        since: '5.0',
+        mdl: 'MDL-71257',
+        reason: 'Renamed'
-     */
+    )]
+    public function want_read_slave(): bool {
+        \core\deprecation::emit_deprecation(__FUNCTION__);
+        return false;
+    }
+    /**
+     * Returns whether we want to connect to replica database for read queries.
+     *
+     * @return bool Want read only connection.
+     */
-    public function want_read_slave(): bool {
+    public function want_read_replica(): bool {
         return false;
+    }
     /**
+     * Returns the number of reads before first write done by this database.
+     * @return int Number of reads.
-     * Returns the number of reads before first write done by this database.
+     * @deprecated Since Moodle 5.0
+     * @todo Final deprecation in Moodle 6.0. See MDL-83171.
+     */
+    #[\core\attribute\deprecated(
+        replacement: 'perf_get_reads_replica',
+        since: '5.0',
+        mdl: 'MDL-71257',
-     * @return int Number of reads.
+        reason: 'Renamed'
+    )]
+    public function perf_get_reads_slave(): int {
+        \core\deprecation::emit_deprecation(__FUNCTION__);
+        return 0;
+    }
+    /**
+     * Returns the number of reads before first write done by this database.
+     *
+     * @return int Number of reads.
      */
-    public function perf_get_reads_slave(): int {
+    public function perf_get_reads_replica(): int {
         return 0;
+    }
      */
     public function is_fulltext_search_supported() {
         // No support unless specified.
         return false;
+    }
+    /**
+     * Whether the database is able to support the COUNT() window function and provides a performance improvement.
+     *
+     * @return bool
+     */
+    public function is_count_window_function_supported(): bool {
+        // No support unless specified.
+        return false;
+    }
+    /**
+     * Retrieve records with a select query and count the total number of records.
+     *
+     * @param string $sql The query string.
+     * @param string $fullcountcolumn The column name used for counting total records.
+     * @param string $sort (Optional) Sorting criteria for the records.
+     *                      The reason to separate $sort from $sql are:
+     *                      1. The $sort needs to be placed outside the full count subquery
+     *                         in order to function properly in MariaDB.
+     *                      2. For unsupported databases, it is not allowed to run a query to get the total with the $sort.
+     *                         Please refer to the {@see ::generate_fullcount_sql()} for details.
+     * @param array|null $params (Optional) Parameters to bind with the query.
+     * @param int $limitfrom (Optional) Offset for pagination.
+     * @param int $limitnum (Optional) Limit for pagination.
+     * @return array Fetched records.
+     */
+    public function get_counted_records_sql(
+        string $sql,
+        string $fullcountcolumn,
+        string $sort = '',
+        ?array $params = null,
+        int $limitfrom = 0,
+        int $limitnum = 0,
+    ): array {
+        $fullcountsql = $this->generate_fullcount_sql($sql, $params, $fullcountcolumn);
+        if ($sort) {
+            // Remove "ORDER BY" with any extra spaces from $sort.
+            $sort = preg_replace('/\s*ORDER\s+BY\s*/i', '', $sort);
+            $fullcountsql .= " ORDER BY " . $sort;
+        }
+        return $this->get_records_sql($fullcountsql, $params, $limitfrom, $limitnum);
+    }
+    /**
+     * Retrieve a recordset with a select query and count the total number of records.
+     *
+     * @param string $sql The query string.
+     * @param string $fullcountcolumn The column name used for counting total records.
+     * @param string $sort (Optional) Sorting criteria for the records.
+     *                      The reason to separate $sort from $sql are:
+     *                      1. The $sort needs to be placed outside the full count subquery
+     *                         in order to function properly in MariaDB.
+     *                      2. For unsupported databases, it is not allowed to run a query to get the total with the $sort.
+     *                         Please refer to the {@see ::generate_fullcount_sql()} for details.
+     * @param array|null $params (Optional) Parameters to bind with the query.
+     * @param int $limitfrom (Optional) Offset for pagination.
+     * @param int $limitnum (Optional) Limit for pagination.
+     * @return moodle_recordset A moodle_recordset instance..
+     */
+    public function get_counted_recordset_sql(
+        string $sql,
+        string $fullcountcolumn,
+        string $sort = '',
+        ?array $params = null,
+        int $limitfrom = 0,
+        int $limitnum = 0,
+    ): moodle_recordset {
+        $fullcountsql = $this->generate_fullcount_sql($sql, $params, $fullcountcolumn);
+        if ($sort) {
+            // Remove "ORDER BY" with any extra spaces from $sort.
+            $sort = preg_replace('/\s*ORDER\s+BY\s*/i', '', $sort);
+            $fullcountsql .= " ORDER BY " . $sort;
+        }
+        return $this->get_recordset_sql($fullcountsql, $params, $limitfrom, $limitnum);
+    }
+    /**
+     * Helper function to generate window COUNT() aggregate function to the SQL query.
+     *
+     * @param string $sql The SQL select query to execute.
+     * @param array|null $params array of sql parameters
+     * @param string $fullcountcolumn An alias column name for the window function results.
+     * @return string The generated query.
+     */
+    private function generate_fullcount_sql(
+        string $sql,
+        ?array $params,
+        string $fullcountcolumn,
+    ): string {
+        $fullcountvalue = "COUNT(1) OVER()";
+        if (!$this->is_count_window_function_supported()) {
+            $sqlcount = "SELECT COUNT(1) FROM ($sql) results";
+            $fullcountvalue = $this->count_records_sql($sqlcount, $params);
+        }
+        return "SELECT results.*, $fullcountvalue AS $fullcountcolumn FROM ($sql) results";
+    }
+}

Proyectos de Subversion Moodle

(root)/lib/dml/moodle_database.php – Rev 1 → 1441