SQLite

All files named ”test/distinctagg.test”
Login

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

History for test/distinctagg.test

2024-01-29
19:30
[40d7169ae5] part of check-in [ad06868807] Consider an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records. (check-in: [ad06868807] user: dan branch: trunk, size: 6770)
2023-10-20
20:19
[ad2b4cf148] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 6577)
2023-02-01
20:14
[14ec5026e6] 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: 6580)
2021-04-08
20:29
[d76ef2e91f] part of check-in [0e4789860b] Fix a use-after-free error that could occur when processing "SELECT aggregate(DISTINCT <expr>)..." queries. (check-in: [0e4789860b] user: dan branch: trunk, size: 6558)
2021-04-03
19:23
[2ff06cbc65] part of check-in [0dcf808ddf] Fix a crash in handling queries of the form "SELECT aggregate(DISTINCT tbl.col) FROM ... LEFT JOIN tbl ...". Fixes a problem introduced by [ef4ac0ddd297bbd3]. (check-in: [0dcf808ddf] user: dan branch: trunk, size: 6386)
2021-03-13
17:21
[fd74c37837] part of check-in [01312a3dbd] Fix typos in comments and add test cases. (check-in: [01312a3dbd] user: dan branch: distinct-agg-opt, size: 5817)
2021-03-12
18:24
[bfdd84af79] part of check-in [3bca003cd2] Attempt to use an index for DISTINCT aggregate queries that have GROUP BY clauses. (check-in: [3bca003cd2] user: dan branch: distinct-agg-opt, size: 5030)
2009-02-09
13:19
[1a6ef9c87a] part of check-in [e20bf38466] Better error message when DISTINCT is used on an aggregate function that takes two or more arguments. Ticket #3641. (CVS 6269) (check-in: [e20bf38466] user: drh branch: trunk, size: 1759)
2005-09-12
23:03
[2b89d1c522] part of check-in [37116550d3] Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689) (check-in: [37116550d3] user: drh branch: trunk, size: 1615)
2005-09-11
11:56
Added: [08ba294140] part of check-in [2f397bd814] COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) (check-in: [2f397bd814] user: drh branch: trunk, size: 1205)