summaryrefslogtreecommitdiff
path: root/test/dialect/test_mysql.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2012-04-08 11:18:39 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2012-04-08 11:18:39 -0400
commit3269b73ff7a12303aadcaed0246d401ec649fa94 (patch)
tree4a067222d58144bc39fe2a14523b3baa713d9940 /test/dialect/test_mysql.py
parentb7abf86f72e62644846dfd540bcceae7959cd046 (diff)
downloadsqlalchemy-3269b73ff7a12303aadcaed0246d401ec649fa94.tar.gz
- adjust mysql patch a bit so that we use
built in quoting for the "idx_" name as well - [bug] Fixed bug whereby column name inside of "KEY" clause for autoincrement composite column with InnoDB would double quote a name that's a reserved word. Courtesy Jeff Dairiki. [ticket:2460]
Diffstat (limited to 'test/dialect/test_mysql.py')
-rw-r--r--test/dialect/test_mysql.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/test/dialect/test_mysql.py b/test/dialect/test_mysql.py
index 613fac7c3..9a2e17ecc 100644
--- a/test/dialect/test_mysql.py
+++ b/test/dialect/test_mysql.py
@@ -1411,7 +1411,7 @@ class SQLTest(fixtures.TestBase, AssertsCompiledSQL):
'CREATE TABLE sometable (assigned_id '
'INTEGER NOT NULL, id INTEGER NOT NULL '
'AUTO_INCREMENT, PRIMARY KEY (assigned_id, '
- 'id), KEY `idx_autoinc_id`(id))ENGINE=Inn'
+ 'id), KEY idx_autoinc_id (id))ENGINE=Inn'
'oDB')
t1 = Table('sometable', MetaData(), Column('assigned_id',
@@ -1436,7 +1436,7 @@ class SQLTest(fixtures.TestBase, AssertsCompiledSQL):
'id INTEGER NOT NULL, '
'`order` INTEGER NOT NULL AUTO_INCREMENT, '
'PRIMARY KEY (id, `order`), '
- 'KEY `idx_autoinc_order`(`order`)'
+ 'KEY idx_autoinc_order (`order`)'
')ENGINE=InnoDB')