Changes between Initial Version and Version 2 of Ticket #32152


Ignore:
Timestamp:
Oct 27, 2020, 12:40:49 PM (3 years ago)
Author:
Christian Klus
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #32152 – Description

    initial v2  
    22
    33Example query:
    4 {{{
     4{{{#!python
    55Book.objects.all().annotate(
    66    pub_year=TruncYear('pubdate')
     
    1717Generated SQL on 3.0.6:
    1818
    19 {{{
     19{{{#!sql
    2020SELECT
    2121  django_date_trunc('year', "aggregation_regress_book"."pubdate") AS "pub_year",
     
    3636Generated SQL on current master:
    3737
    38 {{{
     38{{{#!sql
    3939SELECT
    4040  django_date_trunc('year', "aggregation_regress_book"."pubdate", NULL, NULL) AS "pub_year",
     
    9090The resulting query on master:
    9191
    92 {{{
     92{{{#!sql
    9393SELECT
    9494  django_date_trunc('year', "aggregation_regress_book"."pubdate", NULL, NULL) AS "pub_year",
Back to Top