Bug #78823 | sys.create_synonym_db() does not like reserved-word db names | ||
---|---|---|---|
Submitted: | 13 Oct 2015 18:21 | Modified: | 30 Jun 2016 17:31 |
Reporter: | Paul DuBois | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: SYS Schema | Severity: | S3 (Non-critical) |
Version: | 5.7.9 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[13 Oct 2015 18:21]
Paul DuBois
[30 Jun 2016 17:31]
Paul DuBois
Posted by developer: Noted in 5.7.14 changelog. The sys schema create_synonym_db() function failed if the synonym name was a reserved word or contained backtick (`) characters. The sys schema now has a quote_identifier() function that, given an identifier argument, produces a quoted identifier suitable for inclusion in SQL statements.