summaryrefslogtreecommitdiff
path: root/django/db/models/sql
AgeCommit message (Collapse)Author
2017-12-01[2.0.x] Fixed #28863 -- Fixed filter on annotation that contains Q.Sergey Fedoseev
Backport of cf12257db23fa248c89a3da3f718aa01a50ca659 from master
2017-11-21[2.0.x] Fixed #28817 -- Made QuerySet.iterator() use server-side cursors ↵Dražen Odobašić
after values() and values_list(). Backport of d97f026a7ab5212192426e45121f7a52751a2044 from master
2017-11-12[2.0.x] Fixed #28781 -- Added QuerySet.values()/values_list() support for ↵Mariusz Felisiak
union(), difference(), and intersection(). Thanks Tim Graham for the review. Backport of 2d3cc94284674638c334670903d49565039d77ae from master
2017-10-28[2.0.x] Refs #28010 -- Allowed reverse related fields in SELECT FOR UPDATE ↵Ran Benita
.. OF. Thanks Adam Chidlow for polishing the patch. Backport of 03049fb8d96ccd1f1ed0285486103542de42faba from master
2017-10-16[2.0.x] Fixed #28497 -- Restored the ability to use sliced QuerySets with ↵Tim Graham
__exact. Regression in ec50937bcbe160e658ef881021402e156beb0eaf. Thanks Simon Charette for review. Backport of 1b73ccc4bf78af905f72f4658cf463f38ebf7b97 from master
2017-10-06[2.0.x] Refs #24254 -- Removed unnecessary SQL AS clause in ↵Mariusz Felisiak
SQLCompiler.as_sql(). Incorrect on Oracle. Backport of 11ade8eefd32f5bc7ee6379b77824f02ca61c20b from master
2017-09-22Fixed #27332 -- Added FilteredRelation API for conditional join (ON clause) ↵Nicolas Delaby
support. Thanks Anssi Kääriäinen for contributing to the patch.
2017-09-20Removed unused list in Query.resolve_lookup_value().Nicolas Delaby
Unneeded since its introduction in 4f138fe5a496a81115c4fba6615a517fc62c3b17.
2017-09-18Fixed #26608 -- Added support for window expressions (OVER clause).Mads Jensen
Thanks Josh Smeaton, Mariusz Felisiak, Sergey Fedoseev, Simon Charettes, Adam Chainz/Johnson and Tim Graham for comments and reviews and Jamie Cockburn for initial patch.
2017-09-15Removed unnecessary check in SQLCompiler.get_related_selections().Tim Graham
2017-09-07Reverted "Fixed #27818 -- Replaced try/except/pass with contextlib.suppress()."Tim Graham
This reverts commit 550cb3a365dee4edfdd1563224d5304de2a57fda because try/except performs better.
2017-09-07Removed unneeded __init__() methods.Sergey Fedoseev
2017-09-03Updated EmpytResultSet import not to use the alias.Mariusz Felisiak
2017-09-02Moved select_sql in SQLCompiler.get_extra_select() to improve performance.Mariusz Felisiak
2017-08-31Fixed #28549 -- Fixed QuerySet.defer() with super and subclass fields.Jeremy Kerr
Previously, deferring fields in different classes didn't omit the superclass' deferred field. Thanks Simon Charette for the suggested fix.
2017-08-23Refs #28459 -- Improved performance of SQLCompiler.apply_converters().Sergey Fedoseev
2017-08-15Simplified generation of result in Query.get_aggregation().Sergey Fedoseev
2017-08-15Avoided creation of temporary set in Query.append_annotation_mask().Sergey Fedoseev
2017-08-11Simplified calculation of used joins in Query.build_filter().Sergey Fedoseev
2017-08-11Removed outdated comment in Query.build_filter().Sergey Fedoseev
2017-08-08Refs #28459 -- Improved performance of sql.compiler.cursor_iter().Sergey Fedoseev
2017-08-07Refs #28459 -- Improved performance of SQLCompiler.results_iter().Sergey Fedoseev
2017-08-01Fixed #28454 -- Simplifed use of Query.setup_joins() by returning a named tuple.Matthew Wilkes
2017-08-01Refs #28370 -- Moved db converters deprecation warning to improve performance.Sergey Fedoseev
2017-07-31Fixed #27985 -- Fixed query for __exact=value when get_prep_value() converts ↵Sergey Fedoseev
value to None. Also fixed crash of .filter(field__transform=None).
2017-07-31Refs #20880 -- Removed non-cloning logic from Query.clone().Anssi Kääriäinen
2017-07-31Fixed #28453 -- Made __exact=None lookup use transforms.Sergey Fedoseev
2017-07-31Avoided creating temporary lists for obtaining the first item.Sergey Fedoseev
2017-07-29Avoided creation of temporary sets.Sergey Fedoseev
2017-07-20Fixed #28370 -- Deprecated the context arg of Field.from_db_value() and ↵Tim Graham
Expression.convert_value(). Unused since a0d166306fbdc41f49e6fadf4ec84b17eb147daa.
2017-07-15Fixed #28399 -- Fixed QuerySet.count() for union(), difference(), and ↵Florian Apolloner
intersection() queries.
2017-07-10Fixed #28378 -- Fixed union() and difference() when combining with a ↵Mariusz Felisiak
queryset raising EmptyResultSet. Thanks Jon Dufresne for the report. Thanks Tim Graham and Simon Charette for the reviews.
2017-07-08Removed useless hasattr in UpdateQuery._setup_query().Tim Graham
The if statement always evaluates to True.
2017-07-07Removed unused Query.clone() memo kwarg.Tim Graham
Unused since 23ca3a01940c63942885df4709712cebf4df79ec.
2017-06-29Fixed #28010 -- Added FOR UPDATE OF support to QuerySet.select_for_update().Ran Benita
2017-06-29Removed obsolete Query.tables attribute.Anssi Kääriäinen
Obsolete since Query.alias_map became an OrderedDict (refs #26522).
2017-06-13Refs #23853 -- Updated sql.query.Query.join() docstring.Tim Graham
Follow up to ab89414f40db1598364a7fe4cfac1766cacd2668.
2017-06-13Fixed #28293 -- Fixed union(), intersection(), and difference() when ↵Mariusz Felisiak
combining with an EmptyQuerySet. Thanks Jon Dufresne for the report and Tim Graham for the review.
2017-06-08Removed unused sql.Query.query_termsClaude Paroz
Unused since 5008a4db440c8f7d108a6979b959025ffb5789ba.
2017-06-01Refs #23968 -- Removed unnecessary lists, generators, and tuple calls.Jon Dufresne
2017-06-01Fixed #27639 -- Added chunk_size parameter to QuerySet.iterator().François Freitag
2017-05-27Fixed #28249 -- Removed unnecessary dict.keys() calls.Jon Dufresne
iter(dict) is equivalent to iter(dict.keys()).
2017-05-11Fixed #24254 -- Fixed queries using the __in lookup with querysets using ↵Simon Charette
distinct() and order_by(). Thanks Tim for the review.
2017-05-11Fixed #28107 -- Disabled grouping of selected primary keys for unmanaged models.Simon Charette
The grouping caused an issue with database views as PostgreSQL's query planer isn't smart enough to introspect primary keys through views. Django doesn't support database views but documents that unmanaged models should be used to query them. Thanks powderflask for the detailed report and investigation.
2017-05-01Refs #16187 -- Stopped compiling query compilers during lookup rhs processing.Simon Charette
Lookup right hand side processing was compiling query compilers which happened to work by chance as SQLCompiler defines a as_sql() method with two optional parameters albeit it doesn't expect the same type of arguments.
2017-04-28Reverted "Refs #20939 -- Moved subquery ordering clearing optimization to ↵Simon Charette
the __in lookup." This reverts commit e62ea0bb9cbb54c1eef848871fe3eab2bad268dc since it broke multi-column __in lookups and _meta.order_wrt on Oracle.
2017-04-27Refs #20939 -- Moved subquery ordering clearing optimization to the __in lookup.Simon Charette
Queries could potentially be resolved in cases where ordering matter.
2017-04-27Replaced set |= operator with update() to avoid temporary set.Jon Dufresne
2017-04-25Refs #20939 -- Removed the Query._prepare_as_filter_value() hack.Simon Charette
2017-04-25Refs #20939 -- Removed the Query._forced_pk hack.Simon Charette