SQLite

All files named ”test/count.test”
Login

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

History for test/count.test

2022-06-21
13:41
[cd4bd53106] part of check-in [9322a7c21f] Allow a HAVING clause on any aggregate query, even if there is no GROUP BY clause. This brings SQLite into closer agreement with PostgreSQL and fixes the concern raised by forum post 1a7fea4651. (check-in: [9322a7c21f] user: drh branch: trunk, size: 6218)
2021-11-15
14:11
[013d64569c] part of check-in [e30917278c] Fix a problem causing the count(*) optimization to be misapplied in some cases where an aggregate sub-query uses a count() expression that is aggregated against the outer query. (check-in: [e30917278c] user: dan branch: trunk, size: 6185)
2021-03-20
15:11
[5364003488] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 5843)
2020-05-08
18:22
[e0699a1571] part of check-in [0d23a0b209] Fix the count-optimization so that it honors the NOT INDEXED clause. (check-in: [0d23a0b209] user: drh branch: trunk, size: 5867)
2015-04-21
15:16
[cb2e0f934c] part of check-in [d1e6bc918b] Change an assert() in the aggregate query code generator into a testcase(). (check-in: [d1e6bc918b] user: drh branch: trunk, size: 5055)
2013-11-12
14:55
[42a251178e] part of check-in [9117477978] Make sure the count(*) optimization works correctly on WITHOUT ROWID tables. (check-in: [9117477978] user: drh branch: trunk, size: 4899)
2009-06-05
17:09
[454e1ce985] part of check-in [1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec2b] user: drh branch: trunk, size: 4828)
2009-05-01
21:13
[99c78f5840] part of check-in [12bcb03d9b] Record within the Token structure itself whether or not the token has been dequoted. This steals one bit from the length of a token and thus limits the size of tokens to 1GiB. (CVS 6589) (check-in: [12bcb03d9b] user: drh branch: trunk, size: 4839)
2009-04-02
20:27
[276b32260e] part of check-in [e0c1a780f5] Make sure count(*) works on the sqlite_master table of an empty database. Ticket #3774. (CVS 6443) (check-in: [e0c1a780f5] user: drh branch: trunk, size: 4828)
2009-02-25
08:56
[89df9e4cf3] part of check-in [a3695b98f6] Minor changes and coverge tests for "SELECT count(*)" optimization. (CVS 6324) (check-in: [a3695b98f6] user: danielk1977 branch: trunk, size: 4674)
2009-02-24
18:33
[27293d5708] part of check-in [3f0baa1b63] Fixes and some extra test cases for count(*) optimization. (CVS 6320) (check-in: [3f0baa1b63] user: danielk1977 branch: trunk, size: 4060)
10:48
Added: [51c69ee6b3] part of check-in [a195d74ff9] Add test file test/count.test for testing "SELECT count(*)" statements. It is not properly populated yet. (CVS 6318) (check-in: [a195d74ff9] user: danielk1977 branch: trunk, size: 2135)