diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-03-23 15:11:03 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-03-23 15:31:05 -0400 |
| commit | 0883d8213bcfbeb5e0ae6dd1cbcf70494eb06dac (patch) | |
| tree | 71282de7e6a7878dbb8d8b309be625cbfcbae887 /test/orm | |
| parent | 1fcbc17b7dd5a5cad71ee79441aa3293c00b8877 (diff) | |
| download | sqlalchemy-0883d8213bcfbeb5e0ae6dd1cbcf70494eb06dac.tar.gz | |
Treat collation names as identifiers
The expression used for COLLATE as rendered by the column-level
:func:`.expression.collate` and :meth:`.ColumnOperators.collate` is now
quoted as an identifier when the name is case sensitive, e.g. has
uppercase characters. Note that this does not impact type-level
collation, which is already quoted.
Change-Id: I83d5d9cd1e66a4f20b96303bb84c5f360d5d6a1a
Fixes: #3785
Diffstat (limited to 'test/orm')
| -rw-r--r-- | test/orm/test_query.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/test/orm/test_query.py b/test/orm/test_query.py index ce119cf50..9924c9547 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -1396,9 +1396,9 @@ class OperatorTest(QueryTest, AssertsCompiledSQL): def test_collate(self): User = self.classes.User - self._test(collate(User.id, 'binary'), "users.id COLLATE binary") + self._test(collate(User.id, 'utf8_bin'), "users.id COLLATE utf8_bin") - self._test(User.id.collate('binary'), "users.id COLLATE binary") + self._test(User.id.collate('utf8_bin'), "users.id COLLATE utf8_bin") def test_selfref_between(self): User = self.classes.User |