Skip to content

Missing MySQL 8.0 keywords lead to unquoted identifiers #3673

@loilo

Description

@loilo

Bug Report

Q A
BC Break no
Version 2.9.2

Summary

This repo's list of MySQL 8.0 keywords seems to be incomplete.

This leads to keywords not being quoted when they should. The example I ran into is the MEMBER keyword, as described in contao/contao#727.

That keyword is relatively new (MySQL 8.0.17, released in July). However, as far as I can tell, the list is missing quite a number of keywords. Not sure whether that is intentended.

Current behaviour

The MEMBER keyword is not recognized as a keyword by DBAL which leads to incorrect generated SQL syntax if a member field is present.

How to reproduce

I'm not at all proficient in DBAL usage, therefore the only reproduce steps I've got are the non-minimal ones I outlined in contao/contao#727

Expected behaviour

Identifier names should be correctly quoted.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions