Incorrect behaviour with reserved words in CREATE ... LIKE ...

[donhardman]

Bug Description:

When we use a word that's a common reserved word, it seems our parser doesn't recognize it and can't parse it properly.

The fix here is that if we can't understand and need to escape this type of table name, we should send a clearer error message, not just "unexpected tablename," which doesn't really explain what's wrong.

Here's a Minimal Reproducible Example (MRE):

mysql> create table comment;
mysql> create table comment_1 like comment with data;
ERROR 1064 (42000): P03: syntax error, unexpected tablename, expecting $end near 'with data'
mysql> create table comment_1 like `comment` with data;
mysql>

Manticore Search Version:

Latest dev version

Operating System Version:

Ubuntu Jammy

Have you tried the latest development version?

Yes

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed
• Changelog updated