[Sqlalchemy-tickets] Issue #3184: sqlite does not reflect unique constraints (zzzeek/sqlalchemy)

[Johannes E. <iss...@bi...>]

New issue 3184: sqlite does not reflect unique constraints
https://bitbucket.org/zzzeek/sqlalchemy/issue/3184/sqlite-does-not-reflect-unique-constraints

Johannes Erdfelt:

sqlite treats unique indexes and unique constraints as distinct entities. However, only indexes are reflected and unique constraints aren't.

This is different than mysql (which aliases unique constraints to a unique index) and postgresql (which has distinct unique indexes and unique constraints).

The attached script shows the problem.