Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8887

SHOW CREATE TABLE shows backticks

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: 10.1.7
        • Fix Version/s: N/A
        • Component/s: Data Definition - Alter Table
        • Labels:
          None

          Description

          SHOW CREATE TABLE shows backticks around the encryption options

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8884 InnoDB redo log encryption not working and documentation incomplete

                • Blocker - Blocks development and/or testing work, production could not run.
                • Open

                  Activity

                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  This is intentional behavior. These table attributes are defined by the engine, not by the server, they can be arbitrary identifiers. See https://mariadb.com/kb/en/mariadb/engine-defined-new-tablefieldindex-attributes/

                  In the future new keywords can be added to the grammar that could conflict with these attributes. To make sure that old SQL table dumps will continue to be readable and usable, SHOW CREATE TABLE quotes all engine-defined table attributes.

                  If you don't like quotes, you can disable them with SET SQL_QUOTE_SHOW_CREATE=0

                  Show
                  serg Sergei Golubchik added a comment - This is intentional behavior. These table attributes are defined by the engine, not by the server, they can be arbitrary identifiers. See https://mariadb.com/kb/en/mariadb/engine-defined-new-tablefieldindex-attributes/ In the future new keywords can be added to the grammar that could conflict with these attributes. To make sure that old SQL table dumps will continue to be readable and usable, SHOW CREATE TABLE quotes all engine-defined table attributes. If you don't like quotes, you can disable them with SET SQL_QUOTE_SHOW_CREATE=0

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      michaeldg Michaël de groot
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: