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) | |