Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/filter1.test
|
2023-02-17
| ||
| 22:48 | [590f8ba9a0] part of check-in [e0a0bf56f1] Fix a harmless typo in the test case added by [29fc06465efb948f]. (check-in: [e0a0bf56f1] user: drh branch: trunk, size: 6511) | |
| 18:27 | [caa347bebb] part of check-in [29fc06465e] Do not allow the COUNTOFVIEW optimization to run if the count() contains a FILTER clause. dbsqlfuzz 4f8e0de6e272bbbb3e1b41cb5aea31e0b47297e3 (check-in: [29fc06465e] user: drh branch: trunk, size: 6511) | |
|
2020-07-01
| ||
| 14:07 | [6c483ecf78] part of check-in [2094da753f] 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: [2094da753f] user: dan branch: trunk, size: 5984) | |
|
2020-01-15
| ||
| 12:49 | [a348b35fce] part of check-in [dadedf41c7] Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: [dadedf41c7] user: drh branch: apple-osx, size: 6071) | |
|
2019-12-27
| ||
| 08:57 | [8a6f047a00] part of check-in [1ffc045d2b] 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: [1ffc045d2b] user: dan branch: trunk, size: 5572) | |
|
2019-10-29
| ||
| 16:18 | [fe7fcfeff4] part of check-in [4d424f3047] 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: [4d424f3047] user: drh branch: trunk, size: 5086) | |
|
2019-10-10
| ||
| 15:17 | [edd797ab2e] part of check-in [ccba7202b6] Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. (check-in: [ccba7202b6] user: dan branch: trunk, size: 5087) | |
|
2019-09-26
| ||
| 15:53 | [c2f34e58ee] part of check-in [1cc6cf6407] 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: [1cc6cf6407] user: dan branch: trunk, size: 4588) | |
|
2019-09-20
| ||
| 20:52 | [f0ee87b2ad] part of check-in [b1d7e104e0] Fix a problem with queries containing a min() or max() function for which the FILTER clause excludes all rows. (check-in: [b1d7e104e0] user: dan branch: trunk, size: 3651) | |
|
2019-08-08
| ||
| 15:24 | [94a6d26588] part of check-in [1e17ea2fd1] 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: [1e17ea2fd1] user: drh branch: omit-stat3, size: 2796) | |
|
2019-07-13
| ||
| 17:45 | [b6d80d882b] part of check-in [871796bb19] Fix error handling for the case where a window function is passed the wrong number of arguments. (check-in: [871796bb19] user: dan branch: trunk, size: 2798) | |
| 16:22 | [5830d62143] part of check-in [5dac8c38df] Rework the FILTER clause implementation to share more code with window functions. (check-in: [5dac8c38df] user: dan branch: filter-clause, size: 2805) | |
|
2019-07-03
| ||
| 18:31 | [8a0f541d21] part of check-in [28aa1702f7] Add tests for the FILTER clause. And a bugfix. (check-in: [28aa1702f7] user: dan branch: filter-clause, size: 2328) | |
|
2019-07-02
| ||
| 11:56 | Added: [d706edd2c3] part of check-in [1f1ae2d6ac] Experimental implementation of FILTER clause for aggregate functions. (check-in: [1f1ae2d6ac] user: dan branch: filter-clause, size: 2320) | |