SQLite

All files named ”test/minmax2.test”
Login

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

History for test/minmax2.test

2021-04-07
15:45
[cf9311babb] part of check-in [14b1d56ef8] Also prohibit the use of rowid from a subquery. Add the SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it. (check-in: [14b1d56ef8] user: drh branch: no-rowid-on-view, size: 9919)
2019-10-29
16:18
[1edf66901d] 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: 9798)
2017-10-26
20:04
[dae92964ac] part of check-in [6caec9082b] Enhance the min/max optimization so that it works with indexes on expressions. (check-in: [6caec9082b] user: drh branch: trunk, size: 9787)
2012-10-30
00:29
[b44bae787f] part of check-in [7af3acbbd4] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (check-in: [7af3acbbd4] user: drh branch: subquery-as-coroutine, size: 8896)
2008-01-05
17:39
[33504c01a0] part of check-in [c449e04f18] First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687) (check-in: [c449e04f18] user: danielk1977 branch: trunk, size: 8895)
2007-07-18
18:17
Added: [8294b67288] part of check-in [a80a3c9d0a] Get the min/max optimization working with descending indices. Ticket #2514. (CVS 4161) (check-in: [a80a3c9d0a] user: drh branch: trunk, size: 8887)