Contrib.social

Update the list of reserved keywords in DatabaseConnection_mysql

Open on Drupal.org →
Created on 31 August 2023, over 1 year ago
Updated 13 November 2023, about 1 year ago

Problem/Motivation

In the DatabaseConnection_mysql we have a list of reserved keywords used by MySQL:

  /**
   * The list of MySQL reserved key words.
   *
   * @link https://dev.mysql.com/doc/refman/8.0/en/keywords.html
   */
  private $reservedKeyWords = array(
    ...
  );

In the meantime, two new keywords were added (see: https://dev.mysql.com/doc/refman/8.0/en/keywords.html):

  • INTERSECT (R); added in 8.0.31 (reserved)
  • LATERAL (R); added in 8.0.14 (reserved)

Some keywords were also removed, but for backwards compatibility I do not think we could remove them.

Proposed resolution

Add two new keywords.

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

📌 Task
Status

Fixed

Version

7.0 ⚰️

Component
MySQL driver  →

Last updated 8 days ago

Created by

🇸🇰Slovakia poker10

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024