diff options
Diffstat (limited to 'sqlglot/dialects/mysql.py')
-rw-r--r-- | sqlglot/dialects/mysql.py | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/sqlglot/dialects/mysql.py b/sqlglot/dialects/mysql.py index d2462e1..1dd2096 100644 --- a/sqlglot/dialects/mysql.py +++ b/sqlglot/dialects/mysql.py @@ -123,6 +123,8 @@ class MySQL(Dialect): KEYWORDS = { **tokens.Tokenizer.KEYWORDS, "CHARSET": TokenType.CHARACTER_SET, + "FORCE": TokenType.FORCE, + "IGNORE": TokenType.IGNORE, "LONGBLOB": TokenType.LONGBLOB, "LONGTEXT": TokenType.LONGTEXT, "MEDIUMBLOB": TokenType.MEDIUMBLOB, @@ -180,6 +182,9 @@ class MySQL(Dialect): class Parser(parser.Parser): FUNC_TOKENS = {*parser.Parser.FUNC_TOKENS, TokenType.SCHEMA, TokenType.DATABASE} + TABLE_ALIAS_TOKENS = ( + parser.Parser.TABLE_ALIAS_TOKENS - parser.Parser.TABLE_INDEX_HINT_TOKENS + ) FUNCTIONS = { **parser.Parser.FUNCTIONS, @@ -389,7 +394,7 @@ class MySQL(Dialect): LOCKING_READS_SUPPORTED = True NULL_ORDERING_SUPPORTED = False JOIN_HINTS = False - TABLE_HINTS = False + TABLE_HINTS = True TRANSFORMS = { **generator.Generator.TRANSFORMS, |