summaryrefslogtreecommitdiff
path: root/django/db/models/sql/compiler.py
AgeCommit message (Collapse)Author
2019-01-14Fixed #30093 -- Fixed ordering of combined queryset ordered by F expressions.Sergey Fedoseev
2018-12-06Fixed #29932 -- Fixed combining compound queries with sub-compound queries ↵Mariusz Felisiak
on SQLite and Oracle.
2018-09-13Refs #14357 -- Deprecated Meta.ordering affecting GROUP BY queries.Ramiro Morales
Thanks Ramiro Morales for contributing to the patch.
2018-08-29Fixed #29694 -- Fixed column mismatch crash with QuerySet.values() or ↵Mariusz Felisiak
values_list() after combining querysets with extra() with union(), difference(), or intersection(). Regression in 0b66c3b442875627fa6daef4ac1e90900d74290b.
2018-08-03Fixed #28668 -- Allowed QuerySet.bulk_create() to ignore insert conflicts.Tom
2018-07-25Refs #29563 -- Fixed SQLCompiler.execute_sql() to respect ↵Andrew Brown
DatabaseFeatures.can_use_chunked_reads.
2018-07-14Fixed #29542 -- Fixed invalid SQL if a Subquery from the HAVING clause is ↵Mariusz Felisiak
used in the GROUP BY clause. Thanks Tim Graham for the review.
2018-07-10Deleted unused variable in SQLCompiler.get_related_selections().Mads Jensen
Unused since 01d440fa1e6b5c62acfa8b3fde43dfa1505f93c6.
2018-05-27Fixed #29416 -- Removed unnecesary subquery from GROUP BY clause on MySQL ↵Mariusz Felisiak
when using a RawSQL annotation. Regression in 1d070d027c218285b66c0bde8079034b33a87f11.
2018-04-19Fixed #28574 -- Added QuerySet.explain().Tom
2018-04-13Fixed #29286 -- Fixed column mismatch crash with QuerySet.values() or ↵Mariusz Felisiak
values_list() after combining an annotated and unannotated queryset with union(), difference(), or intersection(). Regression in a0c03c62a8ac586e5be5b21393c925afa581efaf. Thanks Tim Graham and Carlton Gibson for reviews.
2018-03-19Fixed #29229 -- Fixed column mismatch crash when combining two annotated ↵Astral
values_list() querysets with union(), difference(), or intersection(). Regression in 7316720603821ebb64dfe8fa592ba6edcef5f3e.
2018-02-10Fixed #24747 -- Allowed transforms in QuerySet.order_by() and distinct(*fields).Matthew Wilkes
2018-02-08Fixed #29108 -- Fixed crash in aggregation of distinct+ordered+sliced querysets.Simon Charette
Regression in 4acae21846f6212aa992763e587c7e201828d7b0. Thanks Stephen Brooks for the report.
2018-01-12Fixed #28996 -- Simplified some boolean constructs and removed trivial ↵Дилян Палаузов
continue statements.
2018-01-03Fixed #28982 -- Simplified code with and/or.Дилян Палаузов
2017-12-26Fixed #28944 -- Fixed crash when chaining values()/values_list() after ↵Ran Benita
QuerySet.select_for_update(of=()).
2017-12-11Fixed #28909 -- Simplified code using tuple/list/set/dict unpacking.Nick Pope
2017-12-07Fixed #28906 -- Removed unnecessary bool() calls.Tim Graham
2017-11-21Fixed #28817 -- Made QuerySet.iterator() use server-side cursors after ↵Dražen Odobašić
values() and values_list().
2017-11-12Fixed #28781 -- Added QuerySet.values()/values_list() support for union(), ↵Mariusz Felisiak
difference(), and intersection(). Thanks Tim Graham for the review.
2017-10-28Refs #28010 -- Allowed reverse related fields in SELECT FOR UPDATE .. OF.Ran Benita
Thanks Adam Chidlow for polishing the patch.
2017-10-09Fixed #28670 -- Added FETCH/OFFSET support on Oracle.Mariusz Felisiak
Thanks Tim Graham for the review.
2017-10-06Refs #24254 -- Removed unnecessary SQL AS clause in SQLCompiler.as_sql().Mariusz Felisiak
Incorrect on Oracle.
2017-10-04Refs #28670 -- Moved LIMIT/OFFSET SQL to DatabaseOperations.limit_offset_sql().Mariusz Felisiak
Thanks Tim Graham for the review.
2017-10-03Fixed #28675 -- Removed always True variable in ↵Tim Graham
SQLInsertCompiler.execute_sql() check. Unused since 7deb25b8dd5aa1ed02b5e30cbc67cd1fb0c3d6e6.
2017-10-02Fixed #28652 -- Fixed a few comments in django/db/models/*.Дилян Палаузов
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-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-07Removed unneeded __init__() methods.Sergey Fedoseev
2017-09-02Moved select_sql in SQLCompiler.get_extra_select() to improve performance.Mariusz Felisiak
2017-08-23Refs #28459 -- Improved performance of SQLCompiler.apply_converters().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-31Refs #20880 -- Removed non-cloning logic from Query.clone().Anssi Kääriäinen
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-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-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-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-04-10Fixed #26788 -- Fixed QuerySet.update() crash when updating a geometry to ↵Sergey Fedoseev
another one.
2017-04-10Used NotSupportedError instead of DatabaseError in SQLCompiler.as_sql().Mariusz Felisiak