diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2018-05-10 11:39:06 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2018-05-10 15:27:05 -0400 |
| commit | bd1d6012dcbe5fbc6d1097a79d85b972b0d4fd8a (patch) | |
| tree | bc685b00e84b4ccd74cd984f3868958117fc76bf /doc | |
| parent | 513a6e5bcea5dccabaf86166906233542a4669e7 (diff) | |
| download | sqlalchemy-bd1d6012dcbe5fbc6d1097a79d85b972b0d4fd8a.tar.gz | |
SQL Server is not native boolean; add new flag for CHECK constraint
Fixed a 1.2 regression caused by :ticket:`4061` where the SQL Server
"BIT" type would be considered to be "native boolean". The goal here
was to avoid creating a CHECK constraint on the column, however the bigger
issue is that the BIT value does not behave like a true/false constant
and cannot be interpreted as a standalone expression, e.g.
"WHERE <column>". The SQL Server dialect now goes back to being
non-native boolean, but with an extra flag that still avoids creating
the CHECK constraint.
Change-Id: I4765d2a2a00b0d14f50282603cc4d48d4739dac1
Fixes: #4250
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/build/changelog/unreleased_12/4250.rst | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/build/changelog/unreleased_12/4250.rst b/doc/build/changelog/unreleased_12/4250.rst new file mode 100644 index 000000000..d28bc1d4d --- /dev/null +++ b/doc/build/changelog/unreleased_12/4250.rst @@ -0,0 +1,12 @@ +.. change:: + :tags: bug, mssql + :tickets: 4250 + + Fixed a 1.2 regression caused by :ticket:`4061` where the SQL Server + "BIT" type would be considered to be "native boolean". The goal here + was to avoid creating a CHECK constraint on the column, however the bigger + issue is that the BIT value does not behave like a true/false constant + and cannot be interpreted as a standalone expression, e.g. + "WHERE <column>". The SQL Server dialect now goes back to being + non-native boolean, but with an extra flag that still avoids creating + the CHECK constraint. |