index
:
sqlite
master
sqlite mirror
about
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
test
/
select3.test
Commit message (
Expand
)
Author
Age
*
Remove unnecessary "www." prefixes on domain names in URLs.
drh
2025-04-10
*
Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility
drh
2023-10-20
*
Add test cases related to fix [e717e029].
dan
2022-07-26
*
TK_IF_NULL_ROW expressions must be accumulated in the same way as TK_COLUMN
drh
2022-07-25
*
Do not attempt the OP_Count optimization on queries with HAVING clauses.
dan
2022-07-01
*
Allow a HAVING clause on any aggregate query, even if there is no GROUP BY
drh
2022-06-21
*
Avoid deleting expression nodes in the flattener code, as they may be referen...
dan
2020-06-13
*
Apply the correct affinity transformations when pulling values off of the
drh
2020-03-10
*
Disable the optimization where a REAL value with no fractional part
drh
2019-05-09
*
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)
danielk1977
2008-01-16
*
Adjust the test suite to account for recent changes related to #2822. Most ch...
danielk1977
2007-12-13
*
Disallow empty GROUP BY clauses. Ticket #2431. (CVS 4099)
drh
2007-06-20
*
Make sure that integer values are converted to real when pulled from
drh
2007-02-24
*
Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS...
drh
2006-04-11
*
Create separate affinities for INTEGER and REAL. (CVS 2766)
drh
2005-11-14
*
Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now
drh
2005-11-01
*
SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678)
drh
2005-09-08
*
Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674)
drh
2005-09-08
*
The SUM() aggregate function returns an integer result if all inputs are
drh
2005-09-08
*
Make the ORDER BY clause return equal elements in the same order they were
drh
2005-04-01
*
Tcl interface transfers values directly between SQLite and Tcl_Objs, without
drh
2004-08-20
*
Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569)
danielk1977
2004-06-11
*
Remove the COPY command. (CVS 1477)
drh
2004-05-27
*
Most sorting problems are fixed. Dead code has been removed. 3 test failures
drh
2004-05-21
*
Allow double-quoted strings as string constants in the IN operator. As a
drh
2003-01-31
*
Allow an aggregate function in the HAVING clause even if no aggregates appear
drh
2002-12-03
*
Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannot
drh
2002-08-04
*
Constant ORDER BY or GROUP BY expressions are an error. (CVS 352)
drh
2002-01-22
*
The right-hand side of an AS in a SELECT can be used within expressions of
drh
2002-01-22
*
Disclaimed copyright. Preparing for release 2.0. (CVS 250)
drh
2001-09-16
*
:-) (CVS 81)
drh
2000-06-08
*
:-) (CVS 59)
drh
2000-06-06