aboutsummaryrefslogtreecommitdiff
path: root/test/select3.test
Commit message (Expand)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
* Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibilitydrh2023-10-20
* Add test cases related to fix [e717e029].dan2022-07-26
* TK_IF_NULL_ROW expressions must be accumulated in the same way as TK_COLUMNdrh2022-07-25
* Do not attempt the OP_Count optimization on queries with HAVING clauses.dan2022-07-01
* Allow a HAVING clause on any aggregate query, even if there is no GROUP BYdrh2022-06-21
* Avoid deleting expression nodes in the flattener code, as they may be referen...dan2020-06-13
* Apply the correct affinity transformations when pulling values off of thedrh2020-03-10
* Disable the optimization where a REAL value with no fractional partdrh2019-05-09
* Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)danielk19772008-01-16
* Adjust the test suite to account for recent changes related to #2822. Most ch...danielk19772007-12-13
* Disallow empty GROUP BY clauses. Ticket #2431. (CVS 4099)drh2007-06-20
* Make sure that integer values are converted to real when pulled fromdrh2007-02-24
* Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS...drh2006-04-11
* Create separate affinities for INTEGER and REAL. (CVS 2766)drh2005-11-14
* Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are nowdrh2005-11-01
* SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678)drh2005-09-08
* Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674)drh2005-09-08
* The SUM() aggregate function returns an integer result if all inputs aredrh2005-09-08
* Make the ORDER BY clause return equal elements in the same order they weredrh2005-04-01
* Tcl interface transfers values directly between SQLite and Tcl_Objs, withoutdrh2004-08-20
* Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569)danielk19772004-06-11
* Remove the COPY command. (CVS 1477)drh2004-05-27
* Most sorting problems are fixed. Dead code has been removed. 3 test failuresdrh2004-05-21
* Allow double-quoted strings as string constants in the IN operator. As adrh2003-01-31
* Allow an aggregate function in the HAVING clause even if no aggregates appeardrh2002-12-03
* Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannotdrh2002-08-04
* Constant ORDER BY or GROUP BY expressions are an error. (CVS 352)drh2002-01-22
* The right-hand side of an AS in a SELECT can be used within expressions ofdrh2002-01-22
* Disclaimed copyright. Preparing for release 2.0. (CVS 250)drh2001-09-16
* :-) (CVS 81)drh2000-06-08
* :-) (CVS 59)drh2000-06-06