Closed
Description
Migrated issue, originally created by Anonymous
"Enum type now works using VARCHAR + CHECK constraint for all other"
Now SA uses SMALLINT without CHECK to create Boolean columns in dialects not having native BOOLEAN type. I suggest using CHECK (value IN (0,1)) for Boolean too "for all others".
Metadata
Metadata
Assignees
Type
Projects
Relationships
Development
No branches or pull requests
Activity
sqlalchemy-bot commentedon Dec 6, 2009
Michael Bayer (@zzzeek) wrote:
Did a refactoring of the ENUM logic to simplify in f9cb6f5, the Boolean change is in 7dc4df8. This includes removing all of the dialect specific Boolean types from currently supported dialects and putting common logic into types.Boolean. The whole feature isn't supported on MySQL since they don't have CHECK constraint.
sqlalchemy-bot commentedon Dec 6, 2009
Changes by Michael Bayer (@zzzeek):