d4d595f94c
Make sure the min() and max() optimizations work on empty indexed tables.
...
Ticket #296 . (CVS 914)
FossilOrigin-Name: 98ef6110068e5ed3cd77a14b004f890b79b731f7
2003-04-17 12:44:23 +00:00
027850b676
Fix the authorizer so that it correctly interprets attempts to read the
...
OLD and NEW pseudo-tables of a trigger. (CVS 911)
FossilOrigin-Name: f04bd43254b3ba3fccc842214115d4c298e28138
2003-04-16 20:24:52 +00:00
bb07e9a34f
Simplify the number processing code. Fix for ticket #281 . (CVS 910)
...
FossilOrigin-Name: 4326b52a39cad4632dc2db37aa53a285a31af138
2003-04-16 02:17:35 +00:00
70ce3f0c58
Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291 .
...
This may also fix #159 . Still need to add tests so both bugs remain open
for the time being. (CVS 908)
FossilOrigin-Name: 0b996959b8d8bc2c82eab9cccc190befd0056505
2003-04-15 19:22:22 +00:00
49449834fc
Do not record the inserted rowid on when doing an INSERT within a trigger.
...
Ticket #290 . (CVS 906)
FossilOrigin-Name: 96a717661a3b7108fe0cacb588d81fd8e91eb640
2003-04-15 14:01:43 +00:00
a73af533de
More testing of ATTACH and DETACH. (CVS 899)
...
FossilOrigin-Name: 51f515f28cb1cc3e8f0c3531724dc8876b25f18e
2003-04-05 16:56:28 +00:00
2d4583473b
Begin testing the new ATTACH and DETACH commands. (CVS 898)
...
FossilOrigin-Name: 7a0f8024a1323a15d0c83afe9302400736f01fe8
2003-04-05 03:42:26 +00:00
0d1a643aea
Added experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896)
...
FossilOrigin-Name: 5efbf62313519d0a6e8b8f5dbb29d3ef428d73e8
2003-04-03 15:46:04 +00:00
048c530c01
Use a intermediate table when inserting a TEMP table from a SELECT that
...
reads from that same TEMP table. Ticket #275 . (CVS 895)
FossilOrigin-Name: 087d1e83af12b3a9aedd4945f02774a1043b1eb4
2003-04-03 01:50:44 +00:00
3aa31a16e6
Remove the experimental sqlite_open_aux_file() API. It will soon be replaced
...
by ATTACH and DETACH SQL commands. (CVS 889)
FossilOrigin-Name: b6d6e07f3a5cb493f2cf0675bc6061c5afe5c078
2003-03-30 19:17:01 +00:00
0be9df076a
Fix a memory leak in triggers and update tests to show the latest error
...
message text. (CVS 886)
FossilOrigin-Name: b90d9de32d10a71fe81f5bfd0cf57faae8c5c3b4
2003-03-30 00:19:49 +00:00
9468c7f489
Do not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877)
...
FossilOrigin-Name: 2aba40bea5fc1c4aef8cfd4c790d40808821ca14
2003-03-07 19:50:07 +00:00
2299706c2a
Add more tests to make sure that sqlite_changes() works when using the
...
non-callback API. Ticket #250 . (CVS 876)
FossilOrigin-Name: 13e501d190e327cc6fc16e182819ea9d7bb9c566
2003-03-01 19:53:15 +00:00
dde85d9e00
Get the non-callback API working with the EXPLAIN keyword and for PRAGMAs.
...
Tickets #258 and #257 . Update the API documentation on the sqlite_changes()
routine to explain how it works with the non-callback API. Ticket #250 . (CVS 875)
FossilOrigin-Name: 620e1065e978545dd7bf6fa6fad1e6b93918dbf8
2003-03-01 19:45:34 +00:00
e0194f2bbd
Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement
...
that fails. Ticket #249 . (CVS 1730)
FossilOrigin-Name: 66158843dfa073ffb8779a5170e091cebc018855
2003-02-26 13:52:51 +00:00
50cceb36b6
When the right table in a LEFT OUTER JOIN contains an INTEGER PRIMARY KEY
...
make sure that key is NULL if there is no row in the right table that
matches the current row in the left table. Tickets #246 and #247 . (CVS 873)
FossilOrigin-Name: 6a45fe3bd7e19cf9c20fc6cb65b0269cdd704490
2003-02-20 01:48:12 +00:00
e6da3c1816
Fix the parsing of the LIMIT clause when the limit and offset are separated
...
by a comma. The offset comes before the limit in that case. Ticket #245 . (CVS 872)
FossilOrigin-Name: 6ef91a364b2922f078b7de81816bca3f2ca0fe46
2003-02-20 00:44:52 +00:00
94e9203247
Added test code to check for file descriptor leaks. All regression tests pass
...
now on both win2k and linux. (CVS 868)
FossilOrigin-Name: 75ba78280f7ab6b6acce5878859312f3223ee898
2003-02-16 22:21:32 +00:00
99ee360003
Fix more bugs. The new rollback journal implementation now passes all
...
regression tests under Linux. (CVS 867)
FossilOrigin-Name: d10adc1c5727d76320d5919be55e86d030e9c8bc
2003-02-16 19:13:36 +00:00
4303feedd3
Fix the pager so that correct rollbacks occur when synchronous is turned off.
...
This check-in also included unrelated documentation updates. (CVS 866)
FossilOrigin-Name: 3ef0ad8a4f2696a58aff9d812f90038c2c63f3fc
2003-02-15 23:09:17 +00:00
973b6e333d
Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863)
...
FossilOrigin-Name: 792a9e157dd066fcaffd4f5b373010151fb4ca61
2003-02-12 14:09:42 +00:00
968af52acf
Modify the journal format to be more robust against garbage that might appear
...
in the file after a power failure. The changes are mostly working but more
testing is still required. This check-in is to checkpoint the changes so far. (CVS 861)
FossilOrigin-Name: 8ec5632536eea31197a3b1fd6abc57881a0cf1d7
2003-02-11 14:55:40 +00:00
bb999ef6fa
Make the GROUP BY clause work even if there are no aggregate functions. (CVS 859)
...
FossilOrigin-Name: b68792315883eed8523f5e11856ec8378dc972c1
2003-02-02 12:41:25 +00:00
17e9e29d1e
When a CREATE TABLE ... AS SELECT statement fails, make sure the table name
...
is removed from the internal hash tables. Ticket #238 . (CVS 858)
FossilOrigin-Name: 65264780c553e8a00ec7a40cf76b89a11b245faf
2003-02-01 13:53:28 +00:00
dcd997ea2e
The sqlite_exec() function now returns SQLITE_AUTH when authorization fails.
...
Ticket #231 . (CVS 857)
FossilOrigin-Name: d93c1aeb544a5b1056424945eb43854213b30e50
2003-01-31 17:21:49 +00:00
88eee38afd
Allow double-quoted strings as string constants in the IN operator. As a
...
side-efffect, allow the GROUP BY clause to refer to columns by their integer
column number. Ticket #237 . (CVS 856)
FossilOrigin-Name: 187d9c405891e543fc706f8ddb41f3966a842214
2003-01-31 17:16:36 +00:00
3a84069da3
Additional testing and bug fixing with the non-callback API. Updated the
...
C/C++ interface document to describe the non-callback API. (CVS 855)
FossilOrigin-Name: af1e9299468aa70d7d91e7a5445ba391ccc8ff8b
2003-01-29 22:58:26 +00:00
483750ba8a
Better error messages on constraint violations. Additional tests and bug fixes
...
for the callback-free API. (CVS 854)
FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e
2003-01-29 18:46:51 +00:00
326dce7451
The callback-free API is now working, though much more testing is need. (CVS 853)
...
FossilOrigin-Name: 162b259188e6967fe9c3722da26b81aab5655d83
2003-01-29 14:06:07 +00:00
b86ccfb26e
First code for the new callback-free API. All regression tests pass but the
...
new API is mostly untested and is unlikely to work. (CVS 852)
FossilOrigin-Name: 065fa818ffc8d7562889172acea16e4e44e773ef
2003-01-28 23:13:10 +00:00
fcb78a4900
Fix datatype reporting and collating sequence selection so that it works
...
correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839)
FossilOrigin-Name: 71cc292dce59cf8224b205d1cdbff59ad12f1043
2003-01-18 20:11:05 +00:00
db48ee02c4
Improvements to the pager to help large updates against a large database run
...
faster. Also improved the testing of the pager rollback algorithms. (CVS 835)
FossilOrigin-Name: 717523d3750dce784fa767ed9a8267d1246798ef
2003-01-16 13:42:43 +00:00
2c3831cb23
Finish out the test suite for the new sqlite_set_authorizer API. (CVS 834)
...
FossilOrigin-Name: 701a73918db22fd134a8b959670ba7a4a908c8c5
2003-01-14 13:48:20 +00:00
77ad4e4133
More tests of the sqlite_set_authorizer() API together with fixes for bugs
...
that the new tests uncovered. (CVS 832)
FossilOrigin-Name: cc2ae781ac186f9ee1afacdc9117087421955369
2003-01-14 02:49:27 +00:00
7160220495
Make the GLOB work write with upper-case characters. Ticket #226 . (CVS 831)
...
FossilOrigin-Name: 7ea46e706485cc159f9d1c7e69efcdd048a0bb12
2003-01-14 00:44:08 +00:00
e5f9c6442f
Revise the sqlite_set_authorizer API to provide more detailed information
...
about the SQL statement being authorized. Only partially tested so far. (CVS 830)
FossilOrigin-Name: 45de93f913a18026a45de6254963dbcd1b0f1a19
2003-01-13 23:27:31 +00:00
1962bda764
The initial round of tests for the sqlite_set_authorizer() API. More are
...
needed before release. Ticket #215 . (CVS 829)
FossilOrigin-Name: 5707b3d56efb6e988f816abefb1836f2f3254117
2003-01-12 19:33:52 +00:00
5a38705ecb
Document the SHOW_DATATYPES pragma and add tests for it to the test suite.
...
Make sure datatypes are show even for aliased columns.
Tickets #220 and #221 . (CVS 822)
FossilOrigin-Name: e84d3afe7b9153d003fdcca98221f446c004ffa2
2003-01-11 14:19:51 +00:00
428ae8cb41
Optimizations to the BTree module for a modest speed improvement. (CVS 810)
...
FossilOrigin-Name: 39902a70417475225956704a037493515e9b08b9
2003-01-04 16:48:09 +00:00
f33cb428e5
Make sure the host machine has enough disk space before running the
...
large file tests. (CVS 800)
FossilOrigin-Name: b1ec547865a76541951433630bd4528d1988a4de
2002-12-17 14:13:48 +00:00
3e7a609667
Save the full pathname of the database file so that journalling still works
...
even if the user changes working directories after opening the databae.
Ticket #200 . (CVS 798)
FossilOrigin-Name: 1c58b4fc032c5975dcce9b8ae844c0e516254a17
2002-12-07 21:45:14 +00:00
1a844c380b
Fix a bug in the reverse scan logic that comes up when the table being
...
scanned is empty. Add additional tests for the reverse scan. (CVS 797)
FossilOrigin-Name: 0051c87d5e8d07fae09da2eb7b0d8cbd1bbd3c8e
2002-12-04 22:29:28 +00:00
dd4852c3d1
Fixes to the logic that decides if the ORDER BY can be ignored due to the
...
use of an index. Tests updated. (CVS 796)
FossilOrigin-Name: bfb9a2aa939ecffc5dc2c7c23bddd57d357bdf13
2002-12-04 21:50:16 +00:00
2dcc9aa2a8
Add the sqliteBtreePrevious() routine to the BTree module API. This is
...
in anticipation of implementing reverse order searching of a table. (CVS 794)
FossilOrigin-Name: 0ad1d93879bee0d34b122591c025192a51b8490f
2002-12-04 13:40:25 +00:00
c66c5a266b
Allow an aggregate function in the HAVING clause even if no aggregates appear
...
in the result set. Ticket #187 . (CVS 793)
FossilOrigin-Name: 33c6fd6b3dc271fa1f2d4500b4f76c736accefce
2002-12-03 02:34:49 +00:00
174b619591
Honor ORDER BY clauses in VIEWs. Ticket #193 . (CVS 792)
...
FossilOrigin-Name: dbf7893234a6c5d6bb2d931e52080bb05784c0c9
2002-12-03 02:22:52 +00:00
d0d006e29c
Fixed large file support under Linux. I'm unable to test under Windows.
...
Ticket #191 . (CVS 790)
FossilOrigin-Name: 9864a1265b5a37c12b0dd8446d81b84c5a3acc43
2002-12-01 02:00:57 +00:00
647cb0e159
Add the sqlite_version() SQL function as a built-in. (CVS 777)
...
FossilOrigin-Name: 7c8c0e7633dca00bde7bc7c22075f688c034c200
2002-11-04 19:32:25 +00:00
38dd0b4ff0
In the VDBE, check to make sure a set has been initialized before using it.
...
Ticket #185 . (CVS 772)
FossilOrigin-Name: 8c4cbdd05517e91879a0f2c4559d0f0518d2385b
2002-10-30 22:42:58 +00:00
1f16230b5c
Minimal support for oracle8 outer join syntax. (CVS 771)
...
FossilOrigin-Name: 31df3690d0fe4bd4a293cbe8ca9a26c98c3ed3ce
2002-10-27 19:35:33 +00:00
