e5f50722b4
Make sure the min() and max() optimizer works correctly when there
...
is a LIMIT clause. Ticket #396 . (CVS 1057)
FossilOrigin-Name: c35e50717678703763c696e3e9b265add2ca6454
2003-07-19 00:44:14 +00:00
9cb733c39d
In the test scripts, do not try to delete files that are still open.
...
Windows does not like it when you do. Ticket #397 . (CVS 1055)
FossilOrigin-Name: 93a2c961b17d2459272e2d8654bd4b972f52fbe1
2003-07-18 01:25:34 +00:00
a88dc3f629
Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346 . (CVS 1053)
...
FossilOrigin-Name: a31d0bd90af7cc95f8e36ca8ece21515f872235e
2003-07-16 11:51:35 +00:00
ef0cae500d
Allow negative values for LIMIT and OFFSET. Add tests for negative LIMITs
...
and OFFSETs. Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052)
FossilOrigin-Name: e6a752bfef24f773973c151c6262ff331a9dc57a
2003-07-16 02:19:37 +00:00
da808d56dc
An an extra test associated with ticket #387 . (CVS 1050)
...
FossilOrigin-Name: 6a07ac3782bc18f907ffcf66d908ddaa82ab9293
2003-07-09 16:34:56 +00:00
073e5a7751
Allow the output arguments in sqlite_compile and sqlite_step to be NULL
...
pointers. Tickets #384 and #385 . (CVS 1049)
FossilOrigin-Name: dd84f88f6c4012e4a093a4881f6fe50527bb2006
2003-07-09 00:28:13 +00:00
1dd59e0f94
Correctly handle comparing an INTEGER PRIMARY KEY against a floating point
...
number. Ticket #377 . (CVS 1045)
FossilOrigin-Name: 982aa3356bcc217003cd9e6a829619219c334797
2003-07-06 17:22:25 +00:00
3c8bf55a04
Make sure indices in ATTACH-ed databases are put into the right hash table.
...
Ticket #354 . (CVS 1044)
FossilOrigin-Name: eb4582831d536cd26a1738f9ad197e40486d0958
2003-07-01 18:13:14 +00:00
dc339ee29c
The prior fix of ticket #360 was incorrect and caused a memory leak. This
...
check-in plugs the memory leak and correctly fixes ticket #360 . (CVS 1040)
FossilOrigin-Name: fc490f677b89e623b41f9e7f5f3bade9b981562c
2003-06-29 20:25:08 +00:00
937dd84de8
Fix a bug in the soundex() code. Ticket #367 . Add tests for ticket #261
...
even thought the problem could not be reproduced. (CVS 1035)
FossilOrigin-Name: e2ca936feee35b3fce99c95c2cf8c0ad05cd9c3b
2003-06-28 16:20:22 +00:00
d60ccc6a75
In a SELECT, the rowid of a view or subquery which is really a join is
...
set to NULL if the join is flattened. Ticket #364 . (CVS 1034)
FossilOrigin-Name: bad8b55833f5120003a19883154dac5146cc36a3
2003-06-24 10:39:46 +00:00
8ce10ba65e
Make sure the source of a PULL opcode is not an ephemeral string. Ticket #360 . (CVS 1031)
...
FossilOrigin-Name: cb70ee67ea9f5a47d58820e0e8b28c8f945217ed
2003-06-22 01:41:49 +00:00
d93d8a812e
Add the %z format to the sqlite_mprintf() and related functions. (CVS 1028)
...
FossilOrigin-Name: eca1398eaac67d772aff2676a470d9a6d96a93ca
2003-06-16 03:08:18 +00:00
3fc673e622
Do not flatten a subquery which is the right term of a LEFT OUTER JOIN
...
if the subquery contains a WHERE clause. Ticket #350 . (CVS 1027)
FossilOrigin-Name: dd8943e8583cf7ed3b662570a5607856fd246dac
2003-06-16 00:40:34 +00:00
ed717fe3b2
Enhance the "PRAGMA integrity_check" command to verify that all indices are
...
correctly constructed. New calls to integrity_check are made in the test
suite. These changes are intended to prevent any future problems such
as seen in ticket #334 . (CVS 1024)
FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13
2003-06-15 23:42:24 +00:00
81e293b4b2
Extend the authorization mechanism to disallow the ATTACH and DETACH commands.
...
Ticket #340 . (CVS 1010)
FossilOrigin-Name: a97dca73aed0b42d8dcf944360667ae93c5324fd
2003-06-06 19:00:42 +00:00
7d02cb73ca
Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999).
...
Also clean up some compiler warnings for VC++. (CVS 1005)
FossilOrigin-Name: af6f2bdf59fb621ff3e1d061e429f01ebd7d0b42
2003-06-04 16:24:39 +00:00
b8ec20925d
Adjust test cases to cope with the extra column returned by the database_list
...
pragma. (CVS 1004)
FossilOrigin-Name: fa10c6df5a80127508fb198c21ef93acfc93ebe2
2003-06-04 15:53:02 +00:00
bc2bca0843
Disable the unreadable file test (attach-6.2) under windows because of
...
problems in the OS. (CVS 1000)
FossilOrigin-Name: 4bfb30d20bdd33c6e26c8fb8392a75d3cf2ee4bd
2003-06-04 12:31:53 +00:00
5383ae5c12
Avoid corrupting indices when doing a REPLACE on a table with an
...
INTEGER PRIMARY KEY that also has another index. Ticket #334 . (CVS 999)
FossilOrigin-Name: e813faae0e4086571d13c769f793add7f1f979af
2003-06-04 12:23:30 +00:00
4312db55d9
Additional testing of the ATTACH command with bug fixes for the new problems
...
that the tests found. (CVS 998)
FossilOrigin-Name: 3e8889d7ce5e99fc855526fc1bb62ddbe282bfc5
2003-06-03 01:47:11 +00:00
2394e376d6
Fix a bug in the COPY command introduced by check-in (991). (CVS 996)
...
FossilOrigin-Name: 77ec13dab85b70795ef06ff2c714cca0cd496837
2003-06-02 22:50:25 +00:00
a0217ba720
Add the ability to INSERT or UPDATE using the "rowid" column even on tables
...
that lack an integer primary key. (CVS 991)
FossilOrigin-Name: 903adbe802ca0e987b867e5ad33aae02ad2a43d4
2003-06-01 01:10:33 +00:00
f26e09c87f
Tighter binding of views, triggers, and indices to their respective
...
databases. Ticket #323 . Much more testing needs to be done to the
sqliteFix...() routines in attach.c. (CVS 990)
FossilOrigin-Name: 7202d4f1a8853368954a967b7ccca9d8a6645a2e
2003-05-31 16:21:12 +00:00
6b8611126b
Additional attach testing. I now believe that ticket #317 was fixed
...
by check-in (981). (CVS 985)
FossilOrigin-Name: 24191373796b7fd6255ef9b70ce2344326308113
2003-05-17 19:23:51 +00:00
79a519c047
Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984)
...
FossilOrigin-Name: c8c823b068916711857fa67db10fb479999b55c2
2003-05-17 19:04:03 +00:00
8bf8dc9208
Fix problems with TEMP indices that lead to corrupt databases. These
...
problems were discovered while working on ticket #317 . No sure yet if
that ticket is fixed. (CVS 981)
FossilOrigin-Name: 01398fb78bab7e5c6f439f2b743f26e82118468a
2003-05-17 17:35:10 +00:00
a996e477d0
Make sure the ON CONFLICT clause on a BEGIN overrides the conflict resolution
...
specified by an index. This fixes a bug reported on the newsgroup. (CVS 975)
FossilOrigin-Name: 0f92736d1fbe3b587592fe1f26dfb3558cc49727
2003-05-16 02:30:27 +00:00
8af4d3ace6
Restrain the flattener in the presence of outer joins. Ticket #306 . (CVS 958)
...
FossilOrigin-Name: 6d4b6597e560578253960d9876dc8c8657f41fef
2003-05-06 20:35:16 +00:00
66b4ebafb2
Added tests trying (unsuccessfully) to reproduce ticket #304 . (CVS 957)
...
FossilOrigin-Name: fda637f453d35b74f676997fcf056a948ccd771b
2003-05-04 20:42:56 +00:00
7ad4334add
Fix deficiencies in sqlite_complete() pointed out by R. Dennis Cote. (CVS 955)
...
FossilOrigin-Name: 54b33a5ed9f7a89435c2f1395a3177e8c778bb8a
2003-05-04 17:58:25 +00:00
e9ffc168d8
Additional tests of the new flattener added. Ticket #272 . (CVS 949)
...
FossilOrigin-Name: 8d9ee45ab487614191e8d6aef845141fdddf832a
2003-05-02 16:44:25 +00:00
c31c2eb82c
Enhance the query flattener to handle subqueries that are joins.
...
All regressions pass but new tests need to be added before release.
Ticket #272 . (CVS 948)
FossilOrigin-Name: ad57693e9f1b83a8cc4d028264b35018a9a4a701
2003-05-02 16:04:17 +00:00
6a3ea0e6ef
VDBE cursors numbers for tables in a join do not have to be consecutive.
...
This is one step on the road to fixing ticket #272 . (CVS 947)
FossilOrigin-Name: be7aed2011b4af868b6a0c370c3d41354ae0cdf4
2003-05-02 14:32:12 +00:00
524a5bf5f6
Fix the sqlite_complete() routine so that it recognizes /*...*/ comments.
...
Ticket #277 . (CVS 937)
FossilOrigin-Name: ef8eb580fc6c40264219c2ae77a9c4f8a5803c8b
2003-04-26 02:31:54 +00:00
85e2096fb6
Report the correct authorization context in the authorization callback
...
when coding an INSTEAD OF trigger on an update or delete. (CVS 936)
FossilOrigin-Name: 67746833fc8de3afff80db413bd63a362bb28218
2003-04-25 17:52:11 +00:00
2e6d11bc07
Add tests to insure VACUUM works in the presence of I/O errors. Fix some
...
problems that came to light by these tests. (CVS 935)
FossilOrigin-Name: 8d3e879349fc9523c72cb46111e0058b57ce9341
2003-04-25 15:37:57 +00:00
9c05dc6298
Work around a name collision problem on windows. (CVS 934)
...
FossilOrigin-Name: c3b1f84dfce13b2523c9923e4270577862ca0595
2003-04-25 13:28:02 +00:00
f7c5753174
Make VACUUM work even if multiple processes have the database open at once. (CVS 933)
...
FossilOrigin-Name: caa960289f3d1f5e8f35a94e9e4321996c211ed2
2003-04-25 13:22:51 +00:00
45a304ee8c
Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931)
...
FossilOrigin-Name: 5afb88008fed253e6d1fc0ed5172370b61d3727b
2003-04-25 02:43:08 +00:00
5cf590c128
Fix some issues with INSTEAD OF triggers. (CVS 930)
...
FossilOrigin-Name: 206b17397b1d2b55179c935927ff1d8215728c32
2003-04-24 01:45:04 +00:00
b5a20d3ceb
Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a
...
"trace" method to the TCL interface. (CVS 929)
FossilOrigin-Name: 6289b863590ecc5de3d1efaaa60aa6f3f64fefb3
2003-04-23 12:25:23 +00:00
e22a334b78
Update the authorizer API so that it reports the database that table and
...
indices belong to and so that it reports when actions are taken in response
to a trigger. (CVS 928)
FossilOrigin-Name: c675a5504138f34cae6def782b5d3add2c67d2bc
2003-04-22 20:30:37 +00:00
f0f258b11b
Add support for TEMPORARY triggers. Such triggers can write temporary or
...
permanent tables. (CVS 926)
FossilOrigin-Name: 58ddd587b0f5d565ae3b0ba3a1fa5c20d459f3fc
2003-04-21 18:48:45 +00:00
881b890af4
Add more tests for the in-memory database. (CVS 925)
...
FossilOrigin-Name: 11cab41c4f02cdddc4fd3f57555573ac2814a81b
2003-04-20 23:45:23 +00:00
b2fe7d8cb7
Added tests for the in-memory database backend. Also updated some comments
...
in other modules. (CVS 924)
FossilOrigin-Name: fb89adf4d1325c5ea471759ebfd8df7faa4f9a80
2003-04-20 17:29:23 +00:00
7bdc0c1def
Modify the optimizer so that it does not assume that functions are
...
constant. (CVS 920)
FossilOrigin-Name: 767f1af236d115e8388e1dcc28a4df1be48d6c85
2003-04-19 17:27:24 +00:00
37ea94b8c9
Bug in WHERE clause processing fixed. Ticket #298 . (CVS 919)
...
FossilOrigin-Name: 9b619c98b586a207a87942640d3a94220ff8ab02
2003-04-19 16:34:04 +00:00
cab20050bb
Fix for ticket #297 - bug in sqliteSortCompare(). (CVS 917)
...
FossilOrigin-Name: 4ded1965eb83dee0f28c27ba935d615c77331571
2003-04-18 17:45:14 +00:00
a69d91681d
Fix triggers to work in an ATTACHed database. Ticket #295 . (CVS 915)
...
FossilOrigin-Name: 1e5e00fb73c308378efd034cb291caf338c9fe84
2003-04-17 22:57:53 +00:00
