[MDEV-8887] SHOW CREATE TABLE shows backticks Created: 2015-10-02 Updated: 2015-10-03 Resolved: 2015-10-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Affects Version/s: | 10.1.7 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Michaël de groot | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
SHOW CREATE TABLE shows backticks around the encryption options |
| Comments |
| Comment by Sergei Golubchik [ 2015-10-02 ] |
|
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 |