<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/django.git/tests/expressions_window, branch main</title>
<subtitle>github.com: django/django.git
</subtitle>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/'/>
<entry>
<title>Fixed #34368 -- Made subquery raise NotSupportedError when referencing outer window expression.</title>
<updated>2023-02-27T06:18:58+00:00</updated>
<author>
<name>Simon Charette</name>
<email>charette.s@gmail.com</email>
</author>
<published>2023-02-26T12:43:00+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=c67ea79aa981ae82595d89f8018a41fcd842e7c9'/>
<id>c67ea79aa981ae82595d89f8018a41fcd842e7c9</id>
<content type='text'>
Regression in f387d024fc75569d2a4a338bfda76cc2f328f627.

Co-authored-by: Jannis Vajen &lt;jvajen@gmail.com&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Regression in f387d024fc75569d2a4a338bfda76cc2f328f627.

Co-authored-by: Jannis Vajen &lt;jvajen@gmail.com&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Refs #28477 -- Reduced complexity of aggregation over qualify queries.</title>
<updated>2022-11-11T07:46:08+00:00</updated>
<author>
<name>Simon Charette</name>
<email>charette.s@gmail.com</email>
</author>
<published>2022-11-10T02:55:47+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=a9d2d8d1c36a4338758a792c475965180629a59f'/>
<id>a9d2d8d1c36a4338758a792c475965180629a59f</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Refs #33990 -- Renamed TransactionTestCase.assertQuerysetEqual() to assertQuerySetEqual().</title>
<updated>2022-10-08T06:07:38+00:00</updated>
<author>
<name>Gregor Gärtner</name>
<email>code@gregorgaertner.de</email>
</author>
<published>2022-09-24T10:29:58+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=f0c06f8ab7904e1fd082f2de57337f6c7e05f177'/>
<id>f0c06f8ab7904e1fd082f2de57337f6c7e05f177</id>
<content type='text'>
Co-Authored-By: Michael Howitz &lt;mh@gocept.com&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Co-Authored-By: Michael Howitz &lt;mh@gocept.com&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Refs #28333 -- Fixed NonQueryWindowTests.test_invalid_filter() on databases that don't support window expressions.</title>
<updated>2022-08-29T07:14:56+00:00</updated>
<author>
<name>Mariusz Felisiak</name>
<email>felisiak.mariusz@gmail.com</email>
</author>
<published>2022-08-29T07:14:56+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=f210de760b06cd57ff37b416e2bf9eafb0bfe929'/>
<id>f210de760b06cd57ff37b416e2bf9eafb0bfe929</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Refs #28333 -- Added partial support for filtering against window functions.</title>
<updated>2022-08-15T06:26:26+00:00</updated>
<author>
<name>Simon Charette</name>
<email>charette.s@gmail.com</email>
</author>
<published>2022-08-10T12:22:01+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=f387d024fc75569d2a4a338bfda76cc2f328f627'/>
<id>f387d024fc75569d2a4a338bfda76cc2f328f627</id>
<content type='text'>
Adds support for joint predicates against window annotations through
subquery wrapping while maintaining errors for disjointed filter
attempts.

The "qualify" wording was used to refer to predicates against window
annotations as it's the name of a specialized Snowflake extension to
SQL that is to window functions what HAVING is to aggregates.

While not complete the implementation should cover most of the common
use cases for filtering against window functions without requiring
the complex subquery pushdown and predicate re-aliasing machinery to
deal with disjointed predicates against columns, aggregates, and window
functions.

A complete disjointed filtering implementation should likely be
deferred until proper QUALIFY support lands or the ORM gains a proper
subquery pushdown interface.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Adds support for joint predicates against window annotations through
subquery wrapping while maintaining errors for disjointed filter
attempts.

The "qualify" wording was used to refer to predicates against window
annotations as it's the name of a specialized Snowflake extension to
SQL that is to window functions what HAVING is to aggregates.

While not complete the implementation should cover most of the common
use cases for filtering against window functions without requiring
the complex subquery pushdown and predicate re-aliasing machinery to
deal with disjointed predicates against columns, aggregates, and window
functions.

A complete disjointed filtering implementation should likely be
deferred until proper QUALIFY support lands or the ORM gains a proper
subquery pushdown interface.
</pre>
</div>
</content>
</entry>
<entry>
<title>Refs #33476 -- Refactored code to strictly match 88 characters line length.</title>
<updated>2022-02-07T19:37:05+00:00</updated>
<author>
<name>Mariusz Felisiak</name>
<email>felisiak.mariusz@gmail.com</email>
</author>
<published>2022-02-04T07:08:27+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=7119f40c9881666b6f9b5cf7df09ee1d21cc8344'/>
<id>7119f40c9881666b6f9b5cf7df09ee1d21cc8344</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Refs #33476 -- Reformatted code with Black.</title>
<updated>2022-02-07T19:37:05+00:00</updated>
<author>
<name>django-bot</name>
<email>ops@djangoproject.com</email>
</author>
<published>2022-02-03T19:24:19+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=9c19aff7c7561e3a82978a272ecdaad40dda5c00'/>
<id>9c19aff7c7561e3a82978a272ecdaad40dda5c00</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fixed #33304 -- Allowed passing string expressions to Window(order_by).</title>
<updated>2021-11-23T06:58:44+00:00</updated>
<author>
<name>Simon Charette</name>
<email>charette.s@gmail.com</email>
</author>
<published>2021-11-23T05:39:04+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=aec71aaa5b029640ce066fe5dc34f7a0050d50b2'/>
<id>aec71aaa5b029640ce066fe5dc34f7a0050d50b2</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fixed #32178 -- Allowed database backends to skip tests and mark expected failures.</title>
<updated>2020-12-10T17:00:57+00:00</updated>
<author>
<name>Hasan Ramezani</name>
<email>hasan.r67@gmail.com</email>
</author>
<published>2020-12-10T17:00:57+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=275dd4ebbabbbe758c7219a3d666953d5a7b072f'/>
<id>275dd4ebbabbbe758c7219a3d666953d5a7b072f</id>
<content type='text'>
Co-authored-by: Tim Graham &lt;timograham@gmail.com&gt;</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Co-authored-by: Tim Graham &lt;timograham@gmail.com&gt;</pre>
</div>
</content>
</entry>
<entry>
<title>Fixed #25534, Fixed #31639 -- Added support for transform references in expressions.</title>
<updated>2020-11-27T19:42:04+00:00</updated>
<author>
<name>Ian Foote</name>
<email>python@ian.feete.org</email>
</author>
<published>2020-11-15T22:43:47+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/django.git/commit/?id=8b040e3cbbb2e81420e777afc3ca48a1c8f4dd5a'/>
<id>8b040e3cbbb2e81420e777afc3ca48a1c8f4dd5a</id>
<content type='text'>
Thanks Mariusz Felisiak and Simon Charette for reviews.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Thanks Mariusz Felisiak and Simon Charette for reviews.
</pre>
</div>
</content>
</entry>
</feed>
