9eb516c0eb
min() ignores NULL values. Ticket #800 . (CVS 1802)
...
FossilOrigin-Name: 166234a2b61e1d6a501e48dde1caec0a02bec90b
2004-07-18 20:52:32 +00:00
3aeab9e438
Apply (1679) to version 3. Ticket #777 . (CVS 1680)
...
FossilOrigin-Name: 0a26b9158095f0995fce2f0ccdfb383ab26c76a5
2004-06-24 00:20:04 +00:00
cbb18d2256
Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483)
...
FossilOrigin-Name: 4984a130ccf3b8e486941a5d0d0cc70a691f0dac
2004-05-28 11:37:27 +00:00
8d059845fc
Add some more code to support manifest typing in indices. Not activated yet. (CVS 1362)
...
FossilOrigin-Name: 2f16c9ef3c101c4280991ce3cb0c3bea7b6ed439
2004-05-12 11:24:02 +00:00
e4de1feb3e
Enhance the ORDER BY clause so that an integer term means to sort by the
...
corresponding column. (CVS 602)
FossilOrigin-Name: 7acbf84b492202d8b5a05276a95b475027eb5f58
2002-06-02 16:09:01 +00:00
739105c72c
Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597)
...
FossilOrigin-Name: 19ae12bef210ae5fe171f10833faa38d640c129f
2002-05-29 23:22:23 +00:00
c754fa5486
Fix the "alias.*" bug found by Bernie Cosell and reported on the newsgroup. (CVS 593)
...
FossilOrigin-Name: f562d542304c0c1b18b0cee78b1ecc353327a02e
2002-05-27 03:25:51 +00:00
bb113518f9
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592)
...
FossilOrigin-Name: 0e268d0c0faa02c3f95e1567cf631b7a04bfbdf0
2002-05-27 01:04:51 +00:00
ad2d8307ac
Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join
...
syntax. The basic functionality is there but there is still a lot of testing
to do. (CVS 587)
FossilOrigin-Name: 99bd1f5b9a1a20bfeefe15c00d96a34a5f40923e
2002-05-24 20:31:36 +00:00
d5feede1ff
Fix for ticket #35 : Ignore any ORDER BY clause on a subquery in a FROM clause. (CVS 557)
...
FossilOrigin-Name: 1b0ee944c9af10078aba628e85d79f8682afa2b6
2002-05-08 21:46:14 +00:00
bf3a4fa4cb
Make the FROM clause on a SELECT optional. If omitted, the result of
...
the SELECT is a single row consisting of the values in the expression list. (CVS 520)
FossilOrigin-Name: 28ce42f7872e2660faa22e66b508db9b1f046af0
2002-04-06 13:57:42 +00:00
5447322939
Fix for bug #2 : Add support for TABLE.* in SELECT statements. (CVS 518)
...
FossilOrigin-Name: c2320eabfe44d6eb05c02b76547e5bd48a29943c
2002-04-04 02:10:55 +00:00
832508b7ea
Subquery flattening is implemented and passes all regression tests.
...
We still need to add addition tests to the suite to further exercise
the flattener, however. (CVS 408)
FossilOrigin-Name: d5d3e79cc58da5bd315cc1fea1f7cbf46274da16
2002-03-02 17:04:07 +00:00
fbc990826c
Change the IFNULL and NVL functions to COALESCE. Change MIN and MAX so that
...
they require at least one argument. (CVS 404)
FossilOrigin-Name: 7d86749d4a78d05930bae2b6491d9428f06fe836
2002-02-28 03:14:18 +00:00
89425d5e02
The new function code passes regression tests. (CVS 403)
...
FossilOrigin-Name: b00cf110b1cc671b7200a5ce8b9e704f660763c9
2002-02-28 03:04:48 +00:00
8e0a2f903a
Added support for user-defined normal functions. Support for user-defined
...
aggregates is pending. (CVS 390)
FossilOrigin-Name: c490a1ff951c5d4a2de8e4f8d349189bfaef7f74
2002-02-23 23:45:45 +00:00
9208643d2a
Constant ORDER BY or GROUP BY expressions are an error. (CVS 352)
...
FossilOrigin-Name: 035984a5b00b4a1a6505405f40b15c7695283c0a
2002-01-22 14:11:29 +00:00
a2e00042a1
The right-hand side of an AS in a SELECT can be used within expressions of
...
the WHERE, ORDER BY, GROUP BY, and/or HAVING clauses. (CVS 350)
FossilOrigin-Name: 3684beab0f8a71ebdf453871bbde7a9ab1f65385
2002-01-22 03:13:42 +00:00
7c917d196f
Added the ability to say things like "SELECT rowid, * FROM table1;" (CVS 332)
...
FossilOrigin-Name: ffbdd43f5de62e7bf81631c83473aca29c3a6c98
2001-12-16 20:05:05 +00:00
17e24df621
Added support for LIMIT. (CVS 302)
...
FossilOrigin-Name: 177012249ae93dbea4a11fb50faaae7912848bd0
2001-11-06 14:10:41 +00:00
6a535340bc
Version 2.0.6 (CVS 291)
...
FossilOrigin-Name: 8467d84fc6e67bd93051f54338a8f6c9b1711ee1
2001-10-19 16:44:56 +00:00
98808babd3
Support for UTF-8 and ISO8859 characters in identifiers. Bug fix in
...
the column name generator for selects (was coreing). (CVS 290)
FossilOrigin-Name: 22948fc685299ca888907eea68edb8a6e87c3f49
2001-10-18 12:34:46 +00:00
1bee3d7b43
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)
FossilOrigin-Name: 747bf1b30b74cfd0e9c27e7c0bc5172637f35520
2001-10-15 00:44:35 +00:00
382c0247c7
Adding table column query capability to support ODBC. (CVS 278)
...
FossilOrigin-Name: b63b3f3684a3d584ef99f54cde76b6c483bbfef7
2001-10-06 16:33:02 +00:00
b19a2bc603
Disclaimed copyright. Preparing for release 2.0. (CVS 250)
...
FossilOrigin-Name: 4e926efe2b59adfec4086eb1d2ba830238facb4c
2001-09-16 00:13:26 +00:00
d400728ac1
More testing (CVS 209)
...
FossilOrigin-Name: 3bde128418fe70a2fd62bf9e013999827a16053c
2001-04-12 23:21:58 +00:00
c4a3c779b1
Added transaction support (CVS 196)
...
FossilOrigin-Name: 35a8feed0d10e780c477f7440fbe80637fcf9906
2001-04-04 11:48:57 +00:00
e1b6a5b803
better column labels in select results (CVS 110)
...
FossilOrigin-Name: 3bf434d93a54a24f4882d0d9375f82ceee0b7602
2000-07-29 13:06:59 +00:00
967e8b7351
:-) (CVS 104)
...
FossilOrigin-Name: e1bf96a467b739373191bf75e6a097fc0f24bffc
2000-06-21 13:59:10 +00:00
cc85b411c7
:-) (CVS 70)
...
FossilOrigin-Name: d3baa046c946a2c4d5567ee57d96a6c8aa5740b9
2000-06-07 15:11:27 +00:00
5974a30f1a
:-) (CVS 1697)
...
FossilOrigin-Name: 5d773b5d4e9c23b81f53afd0cef7bd2300fff329
2000-06-07 14:42:26 +00:00
2282792a4a
GROUP BY and HAVING installed (CVS 58)
...
FossilOrigin-Name: db88a0c2d4b5c5cd05e0172f061fc33763fe3829
2000-06-06 17:27:05 +00:00
da9d6c4572
:-) (CVS 25)
...
FossilOrigin-Name: 35a8f523e8389a1a6e41f6561500644b165d556e
2000-05-31 18:20:14 +00:00
3aadb2e64c
:-) (CVS 24)
...
FossilOrigin-Name: 4cd98ebaeaedf66b258bbfa3a04d90c054294322
2000-05-31 17:59:25 +00:00
