@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.
@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 dialects/ mysql/base. py.bak 2021-09-16 16:21:31.863078338 +0000 dialects/ mysql/base. py 2021-09-16 16:19:43.935195678 +0000
--- ./sqlalchemy/
+++ ./sqlalchemy/
@@ -982,7 +982,7 @@
"""Builds column DDL."""
colspec = [ format_ column( column) , preparer. format_ column( column) +"`",
self. dialect. type_compiler. process(
column. type, type_expression =column)
- self.preparer.
+ "`"+self.
]
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.