sqlalchemy.sql.expression.false() doesn't render to 0 on sqlite
Issue #2368
resolved
Thus creating a Column('foo', Boolean, server_default=sqlalchemy.sql.expression.false()) will trigger an error as the Boolean type adds a check constraint for 1 or 0 (as on sqlite there are only integers, no booleans).
I've tried sqlalchemy.func.false() too, but that generates the string 'false()' which also breaks.
Comments (3)
-
repo owner -
repo owner OK these two constructs have not been widely published so were somewhat forgotten. In 8c05a3bf6599f92bbf8d2246123597e8966f3a52 I moved them to be accessible via sqlalchemy.sql and also got sqlite dialect to render to 0 and 1.
-
repo owner - removed milestone
Removing milestone: 0.7.5 (automated comment)
- Log in to comment
wow, somehow I didn't get an email for this ticket, will look soon.