Comment 6 for bug 1774688

Revision history for this message
Olaf Seibert (oseibert-sys11) wrote :

@lbragstad: I created a very hacky workaround for the original problem:

/usr/lib/python2.7/dist-packages# diff -u ./sqlalchemy/dialects/mysql/base.py.bak ./sqlalchemy/dialects/mysql/base.py
--- ./sqlalchemy/dialects/mysql/base.py.bak 2021-09-16 16:21:31.863078338 +0000
+++ ./sqlalchemy/dialects/mysql/base.py 2021-09-16 16:19:43.935195678 +0000
@@ -982,7 +982,7 @@
         """Builds column DDL."""

         colspec = [
- self.preparer.format_column(column),
+ "`"+self.preparer.format_column(column)+"`",
             self.dialect.type_compiler.process(
                 column.type, type_expression=column)
         ]

After the keystone-manage db_sync command it's likely wise to undo this patch, since I don't trust that it works properly for all queries.