SQLite

All files named ”test/filter1.test”
Login

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)