sqlite unique constraint reflection w/ dots in names

Issue #3495 resolved
Mike Bayer repo owner created an issue

likely a bug in the regex we have to use here

diff --git a/lib/sqlalchemy/testing/suite/test_reflection.py b/lib/sqlalchemy/testing/suite/test_reflection.py
index 3edbdeb..ba70d5c 100644
--- a/lib/sqlalchemy/testing/suite/test_reflection.py
+++ b/lib/sqlalchemy/testing/suite/test_reflection.py
@@ -537,6 +537,7 @@ class ComponentReflectionTest(fixtures.TablesTest):
                 {'name': 'unique_a_b_c', 'column_names': ['a', 'b', 'c']},
                 {'name': 'unique_c_a_b', 'column_names': ['c', 'a', 'b']},
                 {'name': 'unique_asc_key', 'column_names': ['asc', 'key']},
+                {'name': 'i.have.dots', 'column_names': ['b']},
             ],
             key=operator.itemgetter('name')
         )
#!

AssertionError: {'column_names': ['b'], 'name': 'i.have.dots'} != {'column_names': [u'b'], 'name': None}

Comments (3)

  1. Mike Bayer reporter
    • Fixed bug in SQLite dialect where reflection of UNIQUE constraints that included non-alphabetic characters in the names, like dots or spaces, would not be reflected with their name. fixes #3495

    → <<cset f39e692d1249>>

  2. Log in to comment