SQLite

All files named ”test/select5.test”
Login

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

History for test/select5.test

2023-06-09
13:08
[b75d129322] part of check-in [f587891134] Experimental change to add a per-connection option that raises an error if a bare column appears in an aggregate query. (check-in: [f587891134] user: drh branch: newbie-safe-aggregates, size: 7114)
2021-04-26
14:32
[8afc5e5dcd] part of check-in [7178dc3a32] When doing the optimization that attempts to avoid sorting on a GROUP BY, do not assume that the values in an index on an expression are non-NULL. Bug discovered by Wang Ke's fuzzer and reported at forum post 74330094d8. (check-in: [7178dc3a32] user: drh branch: trunk, size: 6670)
2018-06-05
20:04
[df9ec0d218] part of check-in [dce2dfbe15] Calculate non-aggregate expressions in the SELECT list of an aggregate query that does not use min() or max() once per group, instead of once per row visited. (check-in: [dce2dfbe15] user: dan branch: exp-agg-opt, size: 6407)
2008-08-21
14:15
[e758b8ef94] part of check-in [6855711595] Reinsert an SCopy operation that was removed in (5523) because coverage testing indicated that it was dead code. Ticket #3324 shows that the code was not as dead as we thought it was. (CVS 5578) (check-in: [6855711595] user: drh branch: trunk, size: 6407)
2008-08-20
16:35
[2c54642834] part of check-in [daf730d1de] Refactor the name resolution procedures in the code generator. (CVS 5569) (check-in: [daf730d1de] user: drh branch: trunk, size: 5001)
2008-08-02
03:50
[1bddfe92ae] part of check-in [f1e44eb323] Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) (check-in: [f1e44eb323] user: drh branch: trunk, size: 5012)
2008-01-16
18:20
[5ad14ea338] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 4818)
2006-01-21
12:08
[0b47058d3e] part of check-in [29281dea81] Fix more problems with malloc() and IO failures. (CVS 2985) (check-in: [29281dea81] user: danielk1977 branch: trunk, size: 4820)
2005-09-20
18:13
[07a90ab3c7] part of check-in [655e75ac7d] Add VM code comments on the group-by processing. Extra group-by test case. (CVS 2731) (check-in: [655e75ac7d] user: drh branch: trunk, size: 4684)
13:12
[93323dd60e] part of check-in [d9b0c97053] NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) (check-in: [d9b0c97053] user: drh branch: trunk, size: 4194)
2005-09-08
20:37
[cf5c42137d] part of check-in [6281859425] SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: [6281859425] user: drh branch: trunk, size: 3868)
10:37
[2dcd382d1d] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 3867)
2005-09-07
22:48
[1e2258ed2a] part of check-in [7e85a162d0] More bug fixes. But there are still tests that fail. (CVS 2664) (check-in: [7e85a162d0] user: drh branch: trunk, size: 3869)
2005-08-19
03:03
[ae1b5ee248] part of check-in [4281a838f2] Additional tests for better coverage. (CVS 2602) (check-in: [4281a838f2] user: drh branch: trunk, size: 3869)
2005-01-26
03:58
[2d414f712b] part of check-in [0642d3e3d6] Allow GROUP BY on non-aggregate queries. Ticket #1064 (CVS 2276) (check-in: [0642d3e3d6] user: danielk1977 branch: trunk, size: 3775)
2004-08-20
18:34
[94db800bbe] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 2949)
2004-05-27
17:22
[3f3f0f31e6] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 2941)
2001-10-15
00:44
[c2a6c4a003] part of check-in [747bf1b30b] Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) (check-in: [747bf1b30b] user: drh branch: trunk, size: 2975)
2001-09-16
00:13
[00a240e331] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 2632)
2000-06-21
13:59
[e2b9d51d88] part of check-in [e1bf96a467] :-) (CVS 104) (check-in: [e1bf96a467] user: drh branch: trunk, size: 3175)
2000-06-08
16:26
[80ea257ce3] part of check-in [33355b2d8d] :-) (CVS 82) (check-in: [33355b2d8d] user: drh branch: trunk, size: 3173)
11:25
[b6f8b6bef4] part of check-in [305b043f4f] :-) (CVS 79) (check-in: [305b043f4f] user: drh branch: trunk, size: 1977)
11:13
Added: [052369e09b] part of check-in [923c14fe12] :-) (CVS 78) (check-in: [923c14fe12] user: drh branch: trunk, size: 1854)