Skip to content
Snippets Groups Projects

3261236: Use explicit SQL modes instead of ANSI and TRADITIONAL.

Open 3261236: Use explicit SQL modes instead of ANSI and TRADITIONAL.
issue/drupal-3261236:3261236-explicit-sql-modes into 9.4.x
1 unresolved thread
Open Ben Holt requested to merge issue/drupal-3261236:3261236-explicit-sql-modes into 9.4.x
1 unresolved thread

Closes #3261236 by explicitly listing all of the SQL modes instead of using the combined ANSI and TRADITIONAL modes.

The explicitly listed modes are based on the mysql definitions of ANSI and TRADITIONAL. There may be some further work required to determine whether they or some combination of the others used by mariadb are preferred.

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
core/modules/mysql/src/Driver/Database/mysql/Connection.php
222 222 ];
223 223
224 224 $connection_options['init_commands'] += [
225 'sql_mode' => "SET sql_mode = 'ANSI,TRADITIONAL'",
  • daffie
    daffie @daffie
    Developer

    Could we add a comment with that we used sql_mode "ANSI,TRADITIONAL", only that we changed it because of differences between MySQL and MariaDB.

  • Please register or sign in to reply
Please register or sign in to reply