/ All files named "test/filter1.test"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/filter1.test

2020-07-01
14:07
[6c483ecf] part of check-in [2094da75] Fix a problem with VM code generated for some aggregate SELECT statements that feature min()/max() aggregates both with and without FILTER clauses. (check-in: [2094da75] user: dan branch: trunk, size: 5984)
2020-01-15
12:49
[a348b35f] part of check-in [dadedf41] Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: [dadedf41] user: drh branch: apple-osx, size: 6071)
2019-12-27
08:57
[8a6f047a] part of check-in [1ffc045d] When determining if an aggregate within a sub-query should be processed as part of the sub-query or an outer query, consider any FILTER clause in the same way as the arguments to the aggregate. (check-in: [1ffc045d] user: dan branch: trunk, size: 5572)
2019-10-29
16:18
[fe7fcfef] part of check-in [4d424f30] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f30] user: drh branch: trunk, size: 5086)
2019-10-10
15:17
[edd797ab] part of check-in [ccba7202] Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. (check-in: [ccba7202] user: dan branch: trunk, size: 5087)
2019-09-26
15:53
[c2f34e58] part of check-in [1cc6cf64] Fix a window-functions problem that could occur if an ORDER BY clause contains an alias for a window-function that is not a top-level expression. (check-in: [1cc6cf64] user: dan branch: trunk, size: 4588)
2019-09-20
20:52
[f0ee87b2] part of check-in [b1d7e104] Fix a problem with queries containing a min() or max() function for which the FILTER clause excludes all rows. (check-in: [b1d7e104] user: dan branch: trunk, size: 3651)
2019-08-08
15:24
[94a6d265] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 2796)
2019-07-13
17:45
[b6d80d88] part of check-in [871796bb] Fix error handling for the case where a window function is passed the wrong number of arguments. (check-in: [871796bb] user: dan branch: trunk, size: 2798)
16:22
[5830d621] part of check-in [5dac8c38] Rework the FILTER clause implementation to share more code with window functions. (check-in: [5dac8c38] user: dan branch: filter-clause, size: 2805)
2019-07-03
18:31
[8a0f541d] part of check-in [28aa1702] Add tests for the FILTER clause. And a bugfix. (check-in: [28aa1702] user: dan branch: filter-clause, size: 2328)
2019-07-02
11:56
Added: [d706edd2] part of check-in [1f1ae2d6] Experimental implementation of FILTER clause for aggregate functions. (check-in: [1f1ae2d6] user: dan branch: filter-clause, size: 2320)