91fd4d46ad
Miscellaneous code simplifications and cleanup and test coverage
...
enhancements. (CVS 4730)
FossilOrigin-Name: af129b6d158cc90ce9752dd6383c1de47f7b3e43
2008-01-19 20:11:25 +00:00
1527ff4e52
Fix test instrumentation problems on shared_err.test. (CVS 4728)
...
FossilOrigin-Name: 5aef5b0dd8e44a56f84fbc6f843016bca5101987
2008-01-18 17:03:32 +00:00
5ba7cac1d8
Remove an absolute path from crash5.test. (CVS 4727)
...
FossilOrigin-Name: 42d8a377551baef01fb4e80f35fc12f9454a3cd4
2008-01-18 14:17:20 +00:00
a98d7b4797
Add a test (and fix) for possible corruption if malloc() fails during a CREATE INDEX statement, the application continues with the transaction, then crashes. (CVS 4725)
...
FossilOrigin-Name: 65245d9904db19568d5092926b27f0c193c9ef0b
2008-01-18 13:42:54 +00:00
c5531beb56
Fix a bug in the test scripts that was preventing many scripts from
...
running with all.test. Lots of hidden failures now come to light. (CVS 4723)
FossilOrigin-Name: 251c78a982a33194a052897c37a2a79ae9654452
2008-01-18 02:31:56 +00:00
008e476c28
Test coverage for date.c. (CVS 4722)
...
FossilOrigin-Name: a676f949b68c968d7e71aceb060c1639b42ba680
2008-01-17 22:27:53 +00:00
3334e948cf
Improved test coverage in date.c. Report an error if a malloc
...
fails within strftime(). (CVS 4721)
FossilOrigin-Name: 495fb41626dfbfbeeb748675b9476a4f7cec6c7a
2008-01-17 20:26:46 +00:00
9cbf3425fb
Registerification of the VDBE is complete. The operand stack has been
...
removed from the code. All instructions operate out of registers only. (CVS 4718)
FossilOrigin-Name: 706b41b70bd1e2030e6fa44358c38a26c5cf0985
2008-01-17 16:22:13 +00:00
1db639cef3
Registerification of the WHERE clause logic. (CVS 4716)
...
FossilOrigin-Name: b3a141b2b0c09bf3c7704deeade290d71b7c9b77
2008-01-17 02:36:28 +00:00
24acd8f939
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)
...
FossilOrigin-Name: 3a289b6d28bcf399845586b15f100d7c3a78b550
2008-01-16 18:20:41 +00:00
93aed5a177
Get all tests running without memory leaks. (CVS 4714)
...
FossilOrigin-Name: 5807921f5a6e2e08f2c9e79aa91d8c587d64de74
2008-01-16 17:46:38 +00:00
db4e8867a4
Work around using (regexp) in the (ifcapable) function of the test suite. So that simpler versions of tcl can call it. (CVS 4713)
...
FossilOrigin-Name: 3aa5606bd4bd750a365454f42ab07826320f5b98
2008-01-16 08:24:46 +00:00
949f9cd565
The sqlite3_trace() callback now prints a message as each trigger fires
...
within a statement. (CVS 4709)
FossilOrigin-Name: 110c000d86bd4a0b4b946c62d11a435426b02d16
2008-01-12 21:35:57 +00:00
2dcef11bb9
Continuing work toward converting the VM to a register machine. (CVS 4708)
...
FossilOrigin-Name: 426f31ecdd05d1179a2e49c2ca1666011cede9c6
2008-01-12 19:03:48 +00:00
b765411161
Continuing work toward converting the VM into a register machine. (CVS 4707)
...
FossilOrigin-Name: a6dddebcc5ccbbf3009c9d06163a8b59036331de
2008-01-12 12:48:07 +00:00
7d67f321d4
Fix a test script problem associated with the new crash4.test file.
...
Ticket #2882 . (CVS 4701)
FossilOrigin-Name: 1134c5ea7116bb2f342ccf09548d075c308c427b
2008-01-09 23:21:25 +00:00
04adf4161d
Finish registerizing the core logic of INSERT and UPDATE. (CVS 4696)
...
FossilOrigin-Name: 5fd1036788dbbc48ff1c746d2e1ba12b04a7e58c
2008-01-08 18:57:50 +00:00
f858740ce9
Add crash4.test with additional crash testing. (CVS 4695)
...
FossilOrigin-Name: 87b4ac4b73fb84411ced9e9a859dd0e2d211c4b3
2008-01-08 16:03:49 +00:00
cb1f0f6c26
Add additional randomness to crash tests. (CVS 4694)
...
FossilOrigin-Name: 3ccce1f58be46787f8a35f0fa6d738ed126c0f07
2008-01-08 15:18:52 +00:00
6a288a33f9
Registerify the AUTOINCREMENT processing and the OP_IsNull and OP_NotNull
...
operators. (CVS 4692)
FossilOrigin-Name: aa48867cfa04da265b906e5b583bc7ac6b6a1157
2008-01-07 19:20:24 +00:00
1013c9320d
Registerify the SRT_Subroutine destination for SELECT results. (CVS 4690)
...
FossilOrigin-Name: 8201f71729c3afbb41764cea3cda65b03150cb0c
2008-01-06 00:25:21 +00:00
a9d1ccb9b0
First pass at optimizing max()/min() as described in #2853 . Some refinements to come. (CVS 4687)
...
FossilOrigin-Name: c449e04f1870b1ff726c95c0bf1c6c6a22ca588a
2008-01-05 17:39:29 +00:00
b1fdb2adea
Get rid of OP_Dup, OP_MemStore, OP_MemLoad, and OP_MemMove. Replace
...
with OP_Copy, OP_SCopy, and OP_Move. Add the infrastructure for
operation properties in1, in2, in3, out2, and out3 but do not yet
use any of these. (CVS 4682)
FossilOrigin-Name: cc149eb9ca3c672cc6fea3528353234ac2ed5745
2008-01-05 04:06:03 +00:00
287fb61c6b
Some modifications to insert.c to work without using the stack. (CVS 4678)
...
FossilOrigin-Name: d9ac6beef538376d0ea0a1daa95cf1dfe36143cf
2008-01-04 19:10:28 +00:00
eb9ae90137
Add some extra tests for the recent trigger compilation optimization. (CVS 4653)
...
FossilOrigin-Name: de54dad800f0b62740ad4ebb3780464b44eb6dff
2008-01-02 04:41:24 +00:00
8f2c54e6e2
Optimize trigger compilation to avoid populating the OLD.* and NEW.* pseudo-tables with data that will never be used. Some testing to come. (CVS 4651)
...
FossilOrigin-Name: e08a33ed7255c22ce2805363f44a1d7770acb2dd
2008-01-01 19:02:09 +00:00
41c58b78b9
Add experimental pragma "quick_check", a reduced version of integrity_check that runs without most of the overhead of the full integrity_check. (CVS 4645)
...
FossilOrigin-Name: 2ddc8d72723e5a294e850491fcd9c1fb7474a9c3
2007-12-29 13:39:19 +00:00
641b0f4ffa
Fix for #2854 . "BEGIN EXCLUSIVE" excludes other shared cache users from using the database. (CVS 4642)
...
FossilOrigin-Name: 2e59b1d07ee422bd799b5b7aeea44ebc998d9481
2007-12-21 04:47:25 +00:00
fc02882ba9
Add the ioerr3.test file, that found an error in br3317. The error is not present in this branch. (CVS 4640)
...
FossilOrigin-Name: d3efec148968538e225f5716359a6a25e8941362
2007-12-19 09:20:41 +00:00
cbd2da9ce9
When SQLITE_MAX_SQL_LENGTH is 0, disable the limit. Make the default 0.
...
Once again build the sqlite3 CLI from individual source files so that
it can be built on systems that lack tclsh. Tickets #2845 and #2846 . (CVS 4636)
FossilOrigin-Name: 07aeca3b9c51e538ba7939950a970f62e51bd3ea
2007-12-17 16:20:06 +00:00
49df6b749c
Fix an out-of-memory NULL pointer defer in the code generator. Ticket #2843 . (CVS 4630)
...
FossilOrigin-Name: b821b6ed176b4259e1d4b56c8eb548933b6f530a
2007-12-14 15:12:21 +00:00
85b623f2f9
Change all instances of "it's" in comments to either "its" or "it is",
...
as appropriate, in case the comments are ever again read by a pedantic
grammarian. Ticket #2840 . (CVS 4629)
FossilOrigin-Name: 4e91a267febda572e7239f0f1cc66b3102558c36
2007-12-13 21:54:09 +00:00
b9fdb2c2f7
Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement is a compound SELECT. No faults found. (CVS 4626)
...
FossilOrigin-Name: 49b67adfe9f15dfac34cb30f965920bf61bceee7
2007-12-13 18:24:21 +00:00
43f6e06460
Additional test cases for tkt2822. Fix a related bug in printf(). (CVS 4624)
...
FossilOrigin-Name: 8f184e40ff79c3c5ef98337615f58a4a6d0249dd
2007-12-13 17:50:22 +00:00
61116ae1ca
Return an error if the user attempts to rename a view. Related to (but not a fix for) #2831 . (CVS 4623)
...
FossilOrigin-Name: 19d56d997f50be81ac2baace16b7e7a1b674301a
2007-12-13 08:15:30 +00:00
01874bfc51
Adjust the test suite to account for recent changes related to #2822 . Most changes are related to English language error messages only. (CVS 4622)
...
FossilOrigin-Name: 2f88b9b3e3c9abc3ae4a5dcef82707dd74f8aace
2007-12-13 07:58:50 +00:00
1e281291fb
ORDER BY in a compound SELECT will first match against the left-most SELECT.
...
If there is no match there, it begins working its way to the right. (CVS 4621)
FossilOrigin-Name: 56063ec84b130bcdb0e90bc76fabca394d0d867f
2007-12-13 03:45:07 +00:00
9a99334d54
Towards getting ORDER BY to match against the correctin columns.
...
This version only looks at the left-most column in a compound SELECT.
That is the correct thing to do, but not what SQLite has historically done. (CVS 4620)
FossilOrigin-Name: bbddf16ac9539c7d48adfc73c5a90eecb8df6865
2007-12-13 02:45:31 +00:00
9019f4a65f
Minor cleanup changes on the OP_StackDepth opcode. Added the
...
sidedelete test for additional testing of ticket #2832 . (CVS 4619)
FossilOrigin-Name: c0689409320de1532be0c0cae12b4b716f6bffb9
2007-12-12 22:24:12 +00:00
c32a93fe95
Remove an (explain) accidentally left in tkt2832.test. (CVS 4618)
...
FossilOrigin-Name: 48947e2b75d39c5be0d08fe1c7b888d9065f9116
2007-12-12 18:05:20 +00:00
967573d56a
Fix some problems similar to #2832 , but caused by triggers instead of an OR REPLACE clause. (CVS 4615)
...
FossilOrigin-Name: ee98ae17187296f7b0181c3d4d2b942d5cd4bc8f
2007-12-12 16:06:23 +00:00
2d78617d66
Test file containing minimal example of bug #2832 . (CVS 4614)
...
FossilOrigin-Name: ed2e61a9fab6a9a102031c10bc6f89e78b4c7447
2007-12-12 14:46:58 +00:00
ae271d6a38
Fix test numbering in tkt2822.test. Ticket #2830 . (CVS 4611)
...
FossilOrigin-Name: 8fe8e9c460e0f8ebc4267de96b0c971cb6370861
2007-12-12 04:38:26 +00:00
70517ab9a1
Further modifications to do with ORDER BY and compound SELECT queries. Related to ticket #2822 . (CVS 4606)
...
FossilOrigin-Name: 0d9b0e6e3a8f8a66956878084085842e94c3cb2f
2007-12-10 18:51:47 +00:00
284f4aca32
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828 . (CVS 4603)
...
FossilOrigin-Name: 0b34a18651764e650faba983be8593992ab2f4a9
2007-12-10 05:03:46 +00:00
4c77431448
Better resolution of ORDER BY terms in compound queries. Candidate
...
solution for ticket #2822 . Needs more testing and documentation
before going final. (CVS 4602)
FossilOrigin-Name: 62a78d212c53a9cb1759d03134653a75f3a086b6
2007-12-08 21:10:20 +00:00
9213d9e5fb
Strengthen the tests for aggregate functions in GROUP BY clauses.
...
Changes to test cases only. No changes to code. (CVS 4601)
FossilOrigin-Name: 4be8e6765bf8bc48747b2542f2ed77066fb9dcb9
2007-12-08 18:01:30 +00:00
464fc33a82
Fix a leaking database connection in the vacuum2 test script.
...
Ticket #2827 . (CVS 4596)
FossilOrigin-Name: f29deb5f0bfcd6d00795aeb66dece717a6c1768a
2007-12-06 17:41:27 +00:00
ddac25c732
Add the ability to change the autovacuum status of an existing database
...
by setting the auto_vacuum pragma then running the VACUUM command. (CVS 4592)
FossilOrigin-Name: bdfc19e838b369a8c5d5d23663fad690f55ba3d7
2007-12-05 01:38:23 +00:00
77658e2f0d
Make sure statement journals are initiated when doing DROP operations
...
(since the DROP might fail after sqlite_master changes). Also make
sure statement journals are initiated if there are pending SELECT
statements. Ticket #2820 . (CVS 4591)
FossilOrigin-Name: bf34284ff0c60ae6e735e09bb29cd48b158e8dce
2007-12-04 16:54:52 +00:00