django.git/django/db/models/sql/compiler.py, branch 1.11.8 django http://cgit.adnoto.dev/django.git/atom?h=1.11.8 2017-11-21T15:45:02Z [1.11.x] Fixed #28817 -- Made QuerySet.iterator() use server-side cursors after values() and values_list(). 2017-11-21T15:45:02Z Dražen Odobašić dodobas@quaternion.co 2017-11-19T15:13:10Z urn:sha1:7f4e17451135a8aee597e24aac4670a6d8860047 Backport of d97f026a7ab5212192426e45121f7a52751a2044 from master [1.11.x] Fixed #28781 -- Added QuerySet.values()/values_list() support for union(), difference(), and intersection(). 2017-11-12T13:33:41Z Mariusz Felisiak felisiak.mariusz@gmail.com 2017-11-12T13:28:11Z urn:sha1:67316720603821ebb64dfe8fa592ba6edcef5f3e Thanks Tim Graham for the review. Backport of 2d3cc94284674638c334670903d49565039d77ae from master [1.11.x] Fixed #28399 -- Fixed QuerySet.count() for union(), difference(), and intersection() queries. 2017-07-15T13:10:42Z Florian Apolloner florian@apolloner.eu 2017-07-14T16:11:29Z urn:sha1:9350f77c69a5cef3d7a9b8078ab33ff43335a112 Backport of adab280cefb15659c39558ac26ea392b0a1e456c from master [1.11.x] Fixed #28378 -- Fixed union() and difference() when combining with a queryset raising EmptyResultSet. 2017-07-10T18:50:50Z Mariusz Felisiak felisiak.mariusz@gmail.com 2017-07-10T17:45:09Z urn:sha1:346b46a274aa8f945aec7d63ea962b41c2c32e40 Thanks Jon Dufresne for the report. Thanks Tim Graham and Simon Charette for the reviews. Backport of ca74e563500e291480f1976b58fcd34aac768dca from master [1.11.x] Fixed #28293 -- Fixed union(), intersection(), and difference() when combining with an EmptyQuerySet. 2017-06-13T06:33:26Z Mariusz Felisiak felisiak.mariusz@gmail.com 2017-06-13T06:16:16Z urn:sha1:44e29ea1e906859e85bb2a46ae5ea9d82bd96f5f Thanks Jon Dufresne for the report and Tim Graham for the review. Backport of 82175ead723f8fa3f9271fbd4b24275097029aab from master [1.11.x] Fixed #28091 -- Re-raised original exception when closing cursor cleanup fails 2017-04-20T15:43:39Z François Freitag mail@franek.fr 2017-04-18T18:15:42Z urn:sha1:56746fb21f6bbf93fe96f4e3908040111439c9c3 [1.11.x] Removed unused variables that are overwritten. 2017-01-25T14:15:36Z Mads Jensen mje@inducks.org 2017-01-25T14:14:05Z urn:sha1:c94cb4f86541d8f76ee27652e214fedd0c0920fe Backport of ebf34c3cdcd2c75349c60a064427ac255958bf9b from master Fixed #27718 -- Added QuerySet.union(), intersection(), difference(). 2017-01-14T13:32:07Z Florian Apolloner apollo13@users.noreply.github.com 2017-01-14T13:32:07Z urn:sha1:84c1826ded17b2d74f66717fb745fc36e37949fd Thanks Mariusz Felisiak for review and Oracle assistance. Thanks Tim Graham for review and writing docs. Refs #16614 -- Prevented database errors from being masked by cursor close. 2017-01-14T12:13:00Z François Freitag mail@franek.fr 2017-01-13T23:21:33Z urn:sha1:6b6be692fcd102436c7abef1d7b3fa1d37ad4bdf When an error occurred during the cursor.execute statement, the cursor is closed. This operation did not fail with client-side cursors. Now, with server-side cursors, the close operation might fail (example below). The original error should be raised, not the one raised by cursor.close(), this is only clean-up code. For example, one can attempt to create a named cursor for an invalid query. psycopg will raise an error about the invalid query and the server-side cursor will not be created on PostgreSQL. When the code attempts to cursor.close(), it asks psycopg to close a cursor that was not created. pyscopg raises a new error: psycopg2.OperationalError: cursor "_django_curs_140365867840512_20" does not exist. Refs #16614 -- Made QuerySet.iterator() use server-side cursors on PostgreSQL. 2017-01-11T14:25:37Z François Freitag mail@franek.fr 2016-06-03T22:31:21Z urn:sha1:f3b7c059367a4e82bbfc7e4f0d42b10975e79f0c Thanks to Josh Smeaton for the idea of implementing server-side cursors in PostgreSQL from the iterator method, and Anssi Kääriäinen and Kevin Turner for their previous work. Also Simon Charette and Tim Graham for review.