SQLite

All files named ”test/countofview.test”
Login

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

History for test/countofview.test

2023-03-31
23:48
[4088e461a1] part of check-in [babe2b5e59] Omit the the count-of-view optimization if there is a HAVING clause. This fixes a problem that originated with check-in [9322a7c21f1c22ba]. dbsqlfuzz 6a107e3055bd22afab31cfddabc2d9d54fcbaf69 (check-in: [babe2b5e59] user: drh branch: trunk, size: 2773)
2023-03-09
15:08
[f9025dba8a] part of check-in [2fc7c3fcee] Fix countofview.test so that it works with SQLITE_OMIT_PROGRESS_CALLBACK builds. (check-in: [2fc7c3fcee] user: dan branch: trunk, size: 1968)
2023-03-08
00:47
[5ecb4ab544] part of check-in [f45009533a] Fix a problem in the count-of-view optimization that can lead to incorrect bytecode. dbsqlfuzz 23d782160b71c3f8f535ccb2da313dfc8eb8c631. (check-in: [f45009533a] user: drh branch: trunk, size: 1933)
2023-03-01
13:54
[5773d192f6] part of check-in [abc3a38363] Do not attempt to apply the count-of-view optimization to a CTE. dbsqlfuzz ef8623915d843b150c159166ee4548c78cc6895a (check-in: [abc3a38363] user: drh branch: trunk, size: 1540)
2019-05-15
18:42
[e17d6e6688] part of check-in [05897ca48a] Fix the count-of-view optimization so that it is (correctly) disabled for a query that includes a WHERE clause or a GROUP BY clause. (check-in: [05897ca48a] user: drh branch: trunk, size: 1235)
2018-11-07
02:17
[e3d4cd6900] part of check-in [3212733cb6] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733cb6] user: drh branch: read-only-shadow, size: 948)
2018-08-03
20:19
Added: [2d0ce23dac] part of check-in [21235d9a41] Fix the handling of sub-queries with LIMIT clauses by the optimization activated by compile-time symbol SQLITE_COUNTOFVIEW_OPTIMIZATION. (check-in: [21235d9a41] user: dan branch: trunk, size: 949)