summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHuai Jiang <huajiang@ebaysf.com>2014-09-03 23:25:11 +0800
committerHuai Jiang <huajiang@ebaysf.com>2014-09-04 09:16:47 +0800
commitfb577ecd6ffcb91025cf6f2d748d3afdbe1c9657 (patch)
tree4e8ca546710a3585979a5e7101fc023155d554f8
parent9234bbbc8477694a2c3ccab86d10955dfeb9e54c (diff)
downloadoslo-db-fb577ecd6ffcb91025cf6f2d748d3afdbe1c9657.tar.gz
Use single quotes for db schema sanity check
double quotes would cause failure when mysql running on ANSI sql_mode. Change-Id: I891b61035ecb90b91a9ccdbec14dd567c575299b Closes-Bug:1365019
-rw-r--r--oslo/db/sqlalchemy/migration.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/oslo/db/sqlalchemy/migration.py b/oslo/db/sqlalchemy/migration.py
index d7a17b3..f1cecdd 100644
--- a/oslo/db/sqlalchemy/migration.py
+++ b/oslo/db/sqlalchemy/migration.py
@@ -93,7 +93,7 @@ def _db_schema_sanity_check(engine):
onlyutf8_sql = ('SELECT TABLE_NAME,TABLE_COLLATION '
'from information_schema.TABLES '
'where TABLE_SCHEMA=%s and '
- 'TABLE_COLLATION NOT LIKE "%%utf8%%"')
+ 'TABLE_COLLATION NOT LIKE \'%%utf8%%\'')
# NOTE(morganfainberg): exclude the sqlalchemy-migrate and alembic
# versioning tables from the tables we need to verify utf8 status on.