/**
* Change the current SQL mode, and ensure its WordPress compatibility.
*
* If no modes are passed, it will ensure the current MySQL server
* modes are compatible.
*
* @since 3.9.0
*
* @param array $modes Optional. A list of SQL modes to set.
*/
public function set_sql_mode($modes = array())
{
if (empty($modes)) {
$res = $this->dbh->query('SELECT @@SESSION.sql_mode;');
if (!$res) {
return;
}
$modes_str = $this->dbh->query_result(0);
if (empty($modes_str)) {
return;
}
$modes = explode(',', $modes_str);
}
$modes = array_change_key_case($modes, CASE_UPPER);
/**
* Filter the list of incompatible SQL modes to exclude.
*
* @since 3.9.0
*
* @param array $incompatible_modes An array of incompatible modes.
*/
$incompatible_modes = (array) apply_filters('incompatible_sql_modes', $this->incompatible_modes);
foreach ($modes as $i => $mode) {
if (in_array($mode, $incompatible_modes)) {
unset($modes[$i]);
}
}
$modes_str = implode(',', $modes);
$this->dbh->query("SET SESSION sql_mode='{$modes_str}';");
}
