82286fd237
Add tests to create and drop a virtual table during a recursive call from
...
an application-defined function. Ticket #3080 . (CVS 5061)
FossilOrigin-Name: d4d6eff353edd5680776436ab3406227b8c830b3
2008-04-28 17:12:10 +00:00
f51bf48b32
Fix a shared-cache mode problem triggered when sqlite3_open16() was used to open the second or subsequent connections to a utf-8 database. (CVS 5059)
...
FossilOrigin-Name: 20946bf6dd704416c41edd863103e85fc7ab4ef2
2008-04-28 16:19:35 +00:00
d65e530b7c
Changes to test scripts to accommodate different architectures and different
...
versions of Tcl. (CVS 5057)
FossilOrigin-Name: 8eb2c07c520c12c2cd4610596dbec451c8275e95
2008-04-28 13:02:57 +00:00
05a3e474cb
Add test cases to prove that ticket #3082 has been fixed. (CVS 5048)
...
FossilOrigin-Name: 776e7024101dd2eeb29484a36c7e1ac751444ec8
2008-04-25 12:10:15 +00:00
9c9eb741be
Fix a problem with the test scripts caused by not cleaning up the global tcl namespace. (CVS 5044)
...
FossilOrigin-Name: 440492395854a0886ef954ef2ed638bf587c6f03
2008-04-24 12:38:28 +00:00
36961ed23f
Ensure that it is not possible to open either virtual table or view columns using the blob API. Ticket #3078 . (CVS 5041)
...
FossilOrigin-Name: 6039328fe05aaf9380d545e84dfabccb32a4d8ea
2008-04-24 09:49:55 +00:00
5cd6256950
Add some tests for journal_mode=off. Need to come up with a way of handling
...
rollback attempts when there is no journal. (CVS 5034)
FossilOrigin-Name: e29b870ed0db6360a95fb017f56c0b5388efb437
2008-04-19 20:53:26 +00:00
16e45a4306
Continuing work on journal_mode. Journal_mode=persist now appears to be
...
working, though additional testing would be welcomed. (CVS 5033)
FossilOrigin-Name: 277e4099cee9105e1801a6d7f5d477f0d2efa858
2008-04-19 20:34:18 +00:00
dafc0ce818
Additional work on ticket #3015 . The previous fix (check-in (4919)) did
...
not appear to work in all cases and it disabled indexing in some places
where it should not have. New test cases added to help insure that the
current fix is better. (CVS 5026)
FossilOrigin-Name: 0d2e258e1a3276e55903ba2ded987f8d8a18cacd
2008-04-17 19:14:02 +00:00
f3a87624a2
In exclusive locking mode, commit by zeroing the first 28 bytes of the
...
journal file, not by truncating the journal. Overwriting is much faster
than truncating. (CVS 5023)
FossilOrigin-Name: 8efb7f4ffbfc3ad901a3bb1b4ff9390b8c13760b
2008-04-17 14:16:42 +00:00
0e0d73c120
Clear a global variable in the incrblob.test script. Ticket #3062 . (CVS 5021)
...
FossilOrigin-Name: 1c19854ae7790a8a1d5c9cfe8b2cb71e2c19ce50
2008-04-16 23:39:26 +00:00
78ddb7ceed
Fix the bind.test test script so that the tests for zeros embedded in
...
strings work correctly for UTF-16 encoded databases. (CVS 5020)
FossilOrigin-Name: 7c094c80b2439480ffc680b2d63031d1033b266a
2008-04-16 16:11:49 +00:00
10dfbbb580
Add tests to verify that strings may use embedded zero characters.
...
Ticket #3056 . (CVS 5018)
FossilOrigin-Name: bb0f9e92e427d4ae8ea143d3d3773c9552e63565
2008-04-16 12:58:53 +00:00
4c68e6d28a
Add speed-test scripts that also show EXPLAIN output. (CVS 5017)
...
FossilOrigin-Name: d11f5dafdaf7c18c43615d0ac018c7d221460244
2008-04-16 12:57:48 +00:00
f93d99990c
Do not attempt to omit unused columns of a view in an instead-of trigger
...
since sometimes those columns can be used in ways that we do not expect.
Ticket #3055 . (CVS 5012)
FossilOrigin-Name: f5fc42e96d36b78797d7fa10b01d22b8501112b1
2008-04-15 14:36:42 +00:00
191b54cb5d
Fix a code generator bug caused by the new CSE optimization. Add test cases
...
to prevent a recurrence. (CVS 5011)
FossilOrigin-Name: d04246a46399e839e70b1bd57e209f80143f0d5b
2008-04-15 12:14:21 +00:00
5f3a367bf3
Fix a bug in the RTRIM collating sequence discovered while working
...
on condition/decision branch coverage. Increase test coverage of
the date/time functions. (CVS 5010)
FossilOrigin-Name: c5435f71efa0b34c759bac4a15fdf43abf39ddfc
2008-04-15 04:02:40 +00:00
521cc8494e
Add out-of-range tests on the first parameter to sqlite3_limit().
...
Add the ability to record tests that have been skipped due to
configuration limitations. (CVS 5009)
FossilOrigin-Name: b7ffc6f0f33b14430ab84a6c60110bc07514f056
2008-04-15 02:36:33 +00:00
110af53360
Add a test case to cover the bug fixed in check-in (5007). (CVS 5008)
...
FossilOrigin-Name: 1863e87c40499ee3d9fd9cba6670e9a0e946d390
2008-04-15 00:01:59 +00:00
1c9f50a277
Make sure the page size in crash6.test does not exceed the maximum
...
configured page size. (CVS 5003)
FossilOrigin-Name: 36b6610b25997074f398a2f2ddcdd6ace8c83fba
2008-04-14 15:27:19 +00:00
10b20ef148
Disable auto_vacuum during the vacuum3 test. (CVS 5000)
...
FossilOrigin-Name: e2e1ca818c5f77abdb423aebe34eea80b2fb84b2
2008-04-14 13:42:39 +00:00
c5d0bd907b
Get the SQLITE_SECURE_DELETE compile-time option working again.
...
Ticket #3050 . (CVS 4999)
FossilOrigin-Name: 40ba51fd4c621e29e7ff85495b1212c92f06ab31
2008-04-14 01:00:57 +00:00
006015d8e5
Remove entries from the sqlite_stat1 table whenever an index is dropped. Related to #3033 . (CVS 4989)
...
FossilOrigin-Name: 349aab42c7896f04ecb6ca33f08a4c194051e837
2008-04-11 17:11:26 +00:00
26c9b5eaba
Speed improvements by removing unnecessary memset() operations.
...
Also: do not resize the opcode array of a virtual machine to its
minimum size after code generation completes. The extra resize
merely uses time. (CVS 4987)
FossilOrigin-Name: 2589955507fc1717891c4e07d1d658eb41660b87
2008-04-11 14:56:53 +00:00
80106e5c4b
Enhancements to the change counter tests. Ticket #3013 . (CVS 4986)
...
FossilOrigin-Name: 1aaed6a4694f60ebcec5dee98f09fe756c81dfa4
2008-04-10 18:44:36 +00:00
665850fbef
Correctly handle virtual tables that are created and dropped all within
...
a single transaction. Ticket #2994 . (CVS 4985)
FossilOrigin-Name: 0acb1b428d1181f597a2a665cae3eef5775f15f1
2008-04-10 18:35:21 +00:00
1e21fd523b
Add the --ostrace and --ossummary options to tester.tcl. To log calls the vfs layer from within test scripts. (CVS 4984)
...
FossilOrigin-Name: e1322415d0ca2d6b45f35ef9257b37161ec043e2
2008-04-10 17:27:38 +00:00
00e087b24b
Enhanced testing and documentation of sqlite3_result_error_code().
...
Ticket #2940 . (CVS 4983)
FossilOrigin-Name: 5be56dbe879f89351239accf5069e4cb166e0792
2008-04-10 17:14:07 +00:00
19bba916f9
Make sure check-in (4976) also fixes ticket #2935 . (CVS 4981)
...
FossilOrigin-Name: e3f798b1cafc3458941cf86ac4f9d4269fdf5b7e
2008-04-10 16:42:58 +00:00
4154c22345
Verify that a RAISE(ROLLBACK,...) works like RAISE(FAIL,...) when not
...
inside a transaction. Ticket #3035 . (CVS 4979)
FossilOrigin-Name: 87dc82d0436c6c3a9bd67544d52911012a5a7c66
2008-04-10 15:12:45 +00:00
b5df14486d
Make sure changes to virtual tables are counted the same as real tables.
...
Ticket #3038 . (CVS 4976)
FossilOrigin-Name: 55591fc49c8ab8146c1f3eff733e637501bff627
2008-04-10 14:00:09 +00:00
08c88eb0d3
First cut at optimizing single-row updates to use a one-pass algorithm. (CVS 4973)
...
FossilOrigin-Name: fba97f7874d723111e873d1470fc1a95e64f922d
2008-04-10 13:33:18 +00:00
67ade0a2d0
Add three new test cases to speed4p.test. Two of the three do single-row
...
updates based on rowid and on primary key. (CVS 4972)
FossilOrigin-Name: a2da7f9ac24ed17329ce9bde2e521a5b945e4ec2
2008-04-10 13:32:36 +00:00
0e6ed0f040
Fix a bug in the speed4p.test performance testing script. (CVS 4971)
...
FossilOrigin-Name: 80311594149af093f1719ec433a633c332a5955e
2008-04-10 13:20:21 +00:00
335d29d208
Smaller and hopefully faster routine for converting blob literals into binary. (CVS 4967)
...
FossilOrigin-Name: 92d49499ee3371db64267c7e2ba72a5e12ea76f3
2008-04-04 15:12:21 +00:00
1c22f2ddfb
Fix the output labels on the tests in malloc9. (CVS 4966)
...
FossilOrigin-Name: 9987a7b193095dc90a83666bdac5e23105909cba
2008-04-04 12:21:25 +00:00
d543a42248
Use an improved RDTSC access routine. (CVS 4961)
...
FossilOrigin-Name: b4eba9c533f6aac9dde4f2c9796fe02e25158a0f
2008-04-03 19:40:59 +00:00
3a2c8c8b73
Avoid an out-of-bounds read in sqlite3_prepare() and fix a case where the output variable *pzTail was being set incorrectly. Fix for #3027 . (CVS 4957)
...
FossilOrigin-Name: c287a7b29410be12cf88f886e8e2525a42aa9c03
2008-04-03 14:36:25 +00:00
ce98bba24b
Change the allocator in mem2.c (used when SQLITE_MEMDEBUG is defined) so that allocations are not rounded up to the nearest 4 byte boundary. Fix a couple of errors in malloc.test related to sqlite3OsAccess() returning -1. (CVS 4956)
...
FossilOrigin-Name: fd97f8762cb1e4653c932402940f74d7c0ebf71f
2008-04-03 10:13:01 +00:00
47de955ea9
Avoid factoring single-instruction constants that end up getting replaced
...
by an SCopy instruction. (CVS 4952)
FossilOrigin-Name: e84ff57b6217afa84d60547dcc3a270b5e116818
2008-04-01 18:04:11 +00:00
c5499bef4b
Add the testcase() macro. Additional CSE test coverage. (CVS 4951)
...
FossilOrigin-Name: 492490f9c86e52c7a706d9e1bf0ba216d5bb8aba
2008-04-01 15:06:33 +00:00
b3843a82ea
Fix a problem with CASTs and the new CSE mechanism. (CVS 4950)
...
FossilOrigin-Name: e25939fb25ec8bde8500a672ca5be3cbb514ac3a
2008-04-01 12:24:11 +00:00
2f7794c111
More test cases and bug fixes with CSE. (CVS 4948)
...
FossilOrigin-Name: 7e8156129d6d240fe046bbc4ea269ebe1657e2a1
2008-04-01 03:27:39 +00:00
652fbf55c5
Initial test cases and bug fixes in the CSE logic. (CVS 4946)
...
FossilOrigin-Name: e5aff09ac693946dc7ebb2f245b6434995b12155
2008-04-01 01:42:41 +00:00
9e6675f73f
Add the veryquick.test script for a very fast overview test that omits
...
all i/o and malloc testing. (CVS 4944)
FossilOrigin-Name: f61df8daa89f07dad2a0ded00c326ef35dead257
2008-03-31 23:51:35 +00:00
f704c1d6cd
Set exclusive locking mode by default on the speed4p test. (CVS 4939)
...
FossilOrigin-Name: 2d9fea95335ab8f399868f63c51bee89ed7633fa
2008-03-29 17:26:01 +00:00
8359d8cb9d
Add the --pause option to the main test driver. (CVS 4934)
...
FossilOrigin-Name: 37dfcdf529378a8ef37ed8672e28339a7d9e9da6
2008-03-29 11:00:54 +00:00
473c35223e
Fix a problem with min() and descending indexes. (CVS 4933)
...
FossilOrigin-Name: 39705b617a775d4299e98ac88fab4525a64d8b78
2008-03-28 19:16:56 +00:00
e5f5b8f1f0
Fix for #3022 . Handle queries like "SELECT min(b) FROM T WHERE a = X AND b > X" when there is an index on (a,b). (CVS 4930)
...
FossilOrigin-Name: bce289753538ab504e55c4215d6cd4f5df137d9e
2008-03-28 18:11:16 +00:00
334c80d615
Change the pager's sector size algorithm to the maximum of the size
...
reported by xSectorSize() from the VFS and 512. It was using the
maximum of xSectorSize() and the current page size, but that was adding
an extra 512 bytes to the size of the journal file in the common case. (CVS 4929)
FossilOrigin-Name: 17ea0c97a8bac1b34af1f9183d93a2f2a6af9690
2008-03-28 17:41:13 +00:00
