SQLite

All files named ”test/windowB.test”
Login

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

History for test/windowB.test

2023-02-06
10:47
[aad7c31739] part of check-in [81c118d90b] Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [81c118d90b] user: dan branch: trunk, size: 13042)
2023-02-01
20:14
[cf1278912c] part of check-in [d090948a69] Update testrunner.tcl to use a separate process for each test script. And to run some extra tests too. (check-in: [d090948a69] user: dan branch: testrunner, size: 13036)
2023-01-19
18:16
[57f9fb931e] part of check-in [fa10e561f5] Fix numbering issue in and remove duplicate test from windowB.test. (check-in: [fa10e561f5] user: dan branch: trunk, size: 12995)
2023-01-17
15:46
[b9c544673d] part of check-in [ce18f0ed68] Update virtual tables json_each and json_tree so that adding "ORDER BY rowid" to a query does not require an external sort. (check-in: [ce18f0ed68] user: dan branch: trunk, size: 13102)
2022-04-20
16:42
[f2fb42b864] part of check-in [9430ead7ba] Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query. (check-in: [9430ead7ba] user: dan branch: trunk, size: 11030)
2021-09-30
21:42
[cb96e42def] part of check-in [86f9c07a4f] Adjust 3 query result expectations to reflect changed group_concat() behavior with varying separator. (check-in: [86f9c07a4f] user: larrybr branch: group_concat_varsep, size: 10140)
2021-09-29
00:32
[b67bda5645] part of check-in [98e0f2bf67] Get group_concat() to handle varying separator lengths when windowing (check-in: [98e0f2bf67] user: larrybr branch: group_concat_varsep, size: 10146)
2021-03-06
14:46
[6e601f8178] part of check-in [01eae68e85] Ensure the correct collation sequence is used for comparisons when delimiting a RANGE window. (check-in: [01eae68e85] user: dan branch: trunk, size: 9837)
2019-09-25
16:41
[7a983ea1cc] part of check-in [5fe15c1d83] Further simplifications to window-function code. (check-in: [5fe15c1d83] user: dan branch: trunk, size: 9319)
2019-09-24
20:20
[f9a79e1bd6] part of check-in [040e196a8b] Bug fixes for window frames of the form (... RANGE BETWEEN b PRECEDING AND a PRECEDING) or (... RANGE a FOLLOWING AND b FOLLOWING) where (a > b). (check-in: [040e196a8b] user: dan branch: trunk, size: 8100)
2019-09-16
05:34
[be2ecc1298] part of check-in [ca564d4b5b] Fix a problem with processing CTEs that use a WINDOW clause. (check-in: [ca564d4b5b] user: dan branch: trunk, size: 6272)
2019-09-14
00:21
[af8f3b0a24] part of check-in [f464d847af] Fix the windows inverse function on the JSON aggregates. (check-in: [f464d847af] user: drh branch: trunk, size: 5677)
2019-09-13
20:42
[fae072a311] part of check-in [4a1978814d] Fix a problem with using json1 window functions with an EXCLUDE clause. (check-in: [4a1978814d] user: dan branch: trunk, size: 4684)
18:59
[3f0ae24a78] part of check-in [807975c76b] Fix the windowB test module so that it works even if SQLite is built without JSON support. (check-in: [807975c76b] user: drh branch: trunk, size: 3004)
2019-09-07
18:20
Added: [24daa26628] part of check-in [6aa438ce41] Add the SQLITE_SUBTYPE flag, which can be passed to sqlite3_create_function() and similar to indicate to the core that a user function is likely to use sqlite3_result_subtype(). (check-in: [6aa438ce41] user: dan branch: window-functions-subtype-fix, size: 2975)