diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-08-07 10:43:55 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-08-07 10:43:55 -0400 |
| commit | 3c6ff6adaec23d34f0a91a3889801589b10082e2 (patch) | |
| tree | 8fe5241834a672cf5d9c80bc6d0236b4883656b9 /doc | |
| parent | b35e6c69b726d445a2d51fc3433ff3f97a04ed38 (diff) | |
| download | sqlalchemy-3c6ff6adaec23d34f0a91a3889801589b10082e2.tar.gz | |
-Fixed bug where Postgresql JSON type was not able to persist or
otherwise render a SQL NULL column value, rather than a JSON-encoded
``'null'``. To support this case, changes are as follows:
* The value :func:`.null` can now be specified, which will always
result in a NULL value resulting in the statement.
* A new parameter :paramref:`.JSON.none_as_null` is added, which
when True indicates that the Python ``None`` value should be
peristed as SQL NULL, rather than JSON-encoded ``'null'``.
Retrival of NULL as None is also repaired for DBAPIs other than
psycopg2, namely pg8000.
fixes #3159
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/build/changelog/changelog_09.rst | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/doc/build/changelog/changelog_09.rst b/doc/build/changelog/changelog_09.rst index cde13441f..a797bfa29 100644 --- a/doc/build/changelog/changelog_09.rst +++ b/doc/build/changelog/changelog_09.rst @@ -14,6 +14,25 @@ :version: 0.9.8 .. change:: + :tags: bug, postgresql + :versions: 1.0.0 + :tickets: 3159 + + Fixed bug where Postgresql JSON type was not able to persist or + otherwise render a SQL NULL column value, rather than a JSON-encoded + ``'null'``. To support this case, changes are as follows: + + * The value :func:`.null` can now be specified, which will always + result in a NULL value resulting in the statement. + + * A new parameter :paramref:`.JSON.none_as_null` is added, which + when True indicates that the Python ``None`` value should be + peristed as SQL NULL, rather than JSON-encoded ``'null'``. + + Retrival of NULL as None is also repaired for DBAPIs other than + psycopg2, namely pg8000. + + .. change:: :tags: bug, sql :versions: 1.0.0 :tickets: 3154 |