database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
30,154 Commits 1,570 Branches 184 Tags
empty-table-optimizations
Commit Graph

9780 Commits

Author SHA1 Message Date
danielk1977
2b31b211c3 Add a test to try to hit the race-condition fixed by (6363). (CVS 6366) 
FossilOrigin-Name: 4310411f5027dba18e017023e21cb09982e26752
 2009-03-20 15:16:05 +00:00
drh
7555d8ec40 Rename the unused MEM2 static mutex to OPEN and reuse it to serialize access 
to the sqlite3BtreeOpen() routine to prevent a race condition on detection
of sharable caches.  Ticket #3735. (CVS 6363)

FossilOrigin-Name: 19fa5a29b97f017a9e176e48c848100299ba6920
 2009-03-20 13:15:30 +00:00
danielk1977
df0f3c06b6 Fix a problem in thread005.test cause errors on osx. (CVS 6362) 
FossilOrigin-Name: 56e6fca1a9da69c3a0fe43b00db9a6d9d93f03ba
 2009-03-20 10:24:03 +00:00
danielk1977
eefa000331 Fix a problem in loadext.test causing an error on OSX. This is not a real problem, just a case of the test script expecting a slightly different error message than the one returned. (CVS 6361) 
FossilOrigin-Name: 18680989b5365b0e35fadca5919dfced22433ff4
 2009-03-20 09:09:37 +00:00
danielk1977
238746a650 Fix a couple of fairly obscure cases where an assert() could fail following a malloc failure. (CVS 6360) 
FossilOrigin-Name: cc0d925669ddeb55048e88aa5b4f658be60b0962
 2009-03-19 18:51:06 +00:00
danielk1977
65a2ea1155 Change sqlite3_step() to return SQLITE_LOCKED if a statement cannot be re-compiled due to locks on the shared-cache schema. Also add a blocking wrapper of sqlite3_prepare_v2() to the test code. (CVS 6359) 
FossilOrigin-Name: e8be1af922098e298902820730f8b28603bd6fae
 2009-03-19 07:58:31 +00:00
danielk1977
cb9d8d8821 Fix a crash that could occur when creating an index in shared-cache mode with lookaside enabled. (CVS 6358) 
FossilOrigin-Name: 097737e3689b9a7e32815fe9c6fc6eed796ae53c
 2009-03-18 18:43:36 +00:00
danielk1977
308ef5a548 Modify test script backup2.test so that it works on OSX. (CVS 6357) 
FossilOrigin-Name: d82e8cd43f46dda15fd15b567901a7dbb2276287
 2009-03-18 13:55:29 +00:00
danielk1977
bd43455c38 Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) 
FossilOrigin-Name: a60f4191791dd7bb49d5c95b350a9924845b59a8
 2009-03-18 10:33:00 +00:00
drh
7f75122149 Move the rowid cache out of VdbeCursor and into BtCursor. When multiple 
BtCursors are open on the same table, set their rowid cache all at the
same time.  Ticket #3731. (CVS 6354)

FossilOrigin-Name: 189785832a7dc9f4a0a2113d850b92b987e0f9bf
 2009-03-17 22:33:00 +00:00
danielk1977
21822c58b0 Fix a problem that could cause a crash when a shared-cache schema contains column default values. (CVS 6353) 
FossilOrigin-Name: afadddc34eee3d6a39102b790ce1a869b33d4286
 2009-03-17 17:48:59 +00:00
drh
3ded8d6f2a Fix test script bugs in the thread002.test and thread_common.tcl. (CVS 6352) 
FossilOrigin-Name: d137e841ce90be92f4c18218f35d22e3a06b0f14
 2009-03-17 15:39:31 +00:00
drh
1f4969a117 Make sure the finished() array in thread005.test is cleared before the 
script starts. (CVS 6351)

FossilOrigin-Name: ddadc25d550efd56e319bf5508c27d66e346be1b
 2009-03-16 17:07:57 +00:00
danielk1977
d52acb3b5b Modify quick.test to support the QUICKTEST_INCLUDE environment variable, which can be used to override the built-in EXCLUDE list. (CVS 6350) 
FossilOrigin-Name: fdfe22f0a568b5e8a5a2ad302d7c06b2696809b0
 2009-03-16 14:48:18 +00:00
danielk1977
404ca07578 Add the sqlite3_unlock_notify() API. (CVS 6348) 
FossilOrigin-Name: b649a6cc5bfefddd6a04b1183647d2923e0a0daa
 2009-03-16 13:19:36 +00:00
danielk1977
1b870de6b0 Fix for #3719. When synthesizing a CREATE TABLE statement as as result of a "CREATE TABLE AS", quote the column type names unless they are simple identifiers or simple identifiers followed by one or two dimensions (e.g. "VARCHAR(10)"). (CVS 6345) 
FossilOrigin-Name: 7c6437efe0a0e935cfa8041bd6b94070c8654fa4
 2009-03-14 08:37:23 +00:00
danielk1977
2fe5cb1809 Avoid fts3 crash on (MATCH '""') expressions. Ticket #3717. (CVS 6343) 
FossilOrigin-Name: 03679857a320517a7b89e5214e948bce9af896a9
 2009-03-12 15:43:47 +00:00
danielk1977
20736d82e2 Make calls to sqlite3BtreeRollbackStmt() no-ops when passed a Btree* handle that does not have an open statement transaction. Ticket #3718. (CVS 6342) 
FossilOrigin-Name: a1bb1aef0e06140a2d5d5e4b6c10c73ce95c89e0
 2009-03-12 14:43:27 +00:00
danielk1977
6fa0fe13f0 Begin purging dirty pages from the cache once 90% of the cache is dirty (insteadof waiting until it is 100% dirty). This improves performance in some circumstances by effectively reserving 10% of the configured page-cache for frequently reused read-only pages. (CVS 6341) 
FossilOrigin-Name: 823fe7f5551e121e211d1ede606a7ce7487ffe0d
 2009-03-05 14:59:39 +00:00
shane
3c9cfa999c Changes to cleanup and improve the consistency of tests for large file support in bigfile.test. (CVS 6338) 
FossilOrigin-Name: 3dbdf68030855a5da24de0ae2f10a26da2531d33
 2009-03-05 04:27:08 +00:00
drh
d742bb78f8 Fix a bug in the GROUP BY alias name resolution. The bug was by 
check-in (6305).  Discovered by regression test on 64-bit linux.
Test cases added so that the problems is detected on 32-bit systems. (CVS 6332)

FossilOrigin-Name: fa0008502ec4f891bfed4a11f01650d274f95c44
 2009-03-02 01:22:40 +00:00
danielk1977
2f886d1d53 Instead of linking temporary triggers on non-temporary tables into the Table.pTrigger list, search the temp schema for them on demand. Fix for #3688. (CVS 6329) 
FossilOrigin-Name: 3befe1ef7e6ebddedfa69579553a1b85b411ee98
 2009-02-28 10:47:41 +00:00
danielk1977
02b4e3b34e In sqlite3_table_column_metadata(), hold the mutex on all attached BtShared objects while accessing schema objects. Fix for #3679. (CVS 6328) 
FossilOrigin-Name: d197afd658eecfc0e24913e5a779c8f1e2a138a6
 2009-02-26 07:15:59 +00:00
danielk1977
02f33725d2 Minor changes and coverge tests for "SELECT count(*)" optimization. (CVS 6324) 
FossilOrigin-Name: a3695b98f63fb776c3b7f77f0553e8a38bcc6f78
 2009-02-25 08:56:47 +00:00
danielk1977
7a895a8048 Fixes and some extra test cases for count(*) optimization. (CVS 6320) 
FossilOrigin-Name: 3f0baa1b63df31f7dc885fd39290ca12ad2be6df
 2009-02-24 18:33:15 +00:00
danielk1977
4d9c1dd262 Add test file test/count.test for testing "SELECT count(*)" statements. It is not properly populated yet. (CVS 6318) 
FossilOrigin-Name: a195d74ff9ce836447dba4da7edcc6f1cdae5574
 2009-02-24 10:48:27 +00:00
danielk1977
a55331620e Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) 
FossilOrigin-Name: d4aa6593183224b6868a322511511c0bbf63b598
 2009-02-24 10:01:51 +00:00
danielk1977
e2d7b24d08 Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315) 
FossilOrigin-Name: 294ba6f743c9132dce0e73da480bd3c2071e7239
 2009-02-23 17:33:49 +00:00
drh
699b3d4f89 Add the reverse_unordered_selects pragma. (CVS 6314) 
FossilOrigin-Name: bc078e0007b6c3dc07722820bb53798b643212b3
 2009-02-23 16:52:07 +00:00
drh
08de14908d Add a count parameter to the OP_Variable opcode and use it to simplify 
prepared statements that copy consecutive unnamed parameters into
consecutive registers (a common case). (CVS 6309)

FossilOrigin-Name: 48b77b04935d8942eb22f0c061f3bc5e99bbd7db
 2009-02-20 03:55:05 +00:00
danielk1977
6ab3a2ec8a Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) 
FossilOrigin-Name: d9f6ffbc5ea090ba0daac571fc9a6c68b9c864e4
 2009-02-19 14:39:25 +00:00
drh
076d4661a6 Make sure the auto_vacuum=INCREMENTAL setting is preserved across a VACUUM. 
Ticket #3663. (CVS 6304)

FossilOrigin-Name: ded04f12f41504e4a3ecd5164f0d4cbbde5e16f7
 2009-02-18 20:31:18 +00:00
drh
0388123f07 Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using 
the ALTER TABLE statement.  Ticket #3651. (CVS 6291)

FossilOrigin-Name: dd179ff2986bc2a86d70bbe927fd0e123e17d398
 2009-02-13 03:43:31 +00:00
drh
a32e0d05ff Update thread tests to clear the sqlite_open_file_count counter at the 
end.  This counter is not threadsafe and can end up with an invalid value
at the end of the thread tests. (CVS 6289)

FossilOrigin-Name: 8c4d71a169e529964d2d0cfba82bbad66a0bcd12
 2009-02-12 17:06:41 +00:00
danielk1977
f2a79f2248 Fix some edge cases with backing up databases that are exactly PENDING_BYTE bytes in size, or just slightly larger. (CVS 6288) 
FossilOrigin-Name: 2fc450e8e60248d6111d0b0d2b8f2344f5b89bca
 2009-02-12 17:01:49 +00:00
danielk1977
1435ccd52b Modify lock.test to account for "PRAGMA lock_status" returning "unknown" for in-memory databases. (CVS 6287) 
FossilOrigin-Name: 9a6e558ba6fe0b38376a85a6c1e2cea5570ea283
 2009-02-12 09:36:15 +00:00
danielk1977
f7f33fb08a Fix a case where during a rollback triggered by an IO or malloc error an unjournalled region of the database could be written to (with it's original data). This was causing an assert in test_journal.c to fail. Add a test case in ioerr2.test to trigger this case. (CVS 6286) 
FossilOrigin-Name: 315a6692f9a03a470871cce4f74567683546f343
 2009-02-12 09:11:56 +00:00
shane
ce14f6245e Updated for Windows compatibility. Test scripts only. (CVS 6285) 
FossilOrigin-Name: 2522ad1df3599fa71cd1d929142adaefaf3a4d67
 2009-02-11 16:06:18 +00:00
danielk1977
3d781c2176 Fix the backup.test script so that it works regardless of the value of SQLITE_TEMP_STORE and the initial contents of the file-system. (CVS 6283) 
FossilOrigin-Name: da660ea73ac6627b4e71706b8cd464646ea66550
 2009-02-11 15:11:00 +00:00
danielk1977
b8f12c1201 Reduce the number of iterations in one of the savepoint4.test crash tests. (CVS 6277) 
FossilOrigin-Name: fafb07b83721d67f6c6f3126c8de94b9b7efa519
 2009-02-10 14:45:12 +00:00
danielk1977
cd503d6a3b Reenable triggering vdbe tracing by creating file-system entries. Add a (redundant) test that modifying the temp schema expires all prepared statements. (CVS 6274) 
FossilOrigin-Name: f6590dac4612d0d05105fa820e8fcb80b5907a40
 2009-02-10 11:17:43 +00:00
danielk1977
8e3e881a24 Fix a bug in test file misc7.test. No code changes. (CVS 6272) 
FossilOrigin-Name: d919d2a14c8cbbda3fbd6fb2ddae174fa709177b
 2009-02-10 05:45:41 +00:00
danielk1977
3d0cbc3362 Fix a problem in backup.c causing OsTruncate() to be called with an argument larger than the current file-size. (CVS 6271) 
FossilOrigin-Name: b34bde80c7e2028baf7ba2ff26e587a63a170f3d
 2009-02-09 18:55:45 +00:00
drh
0daa002c7c Better error message when DISTINCT is used on an aggregate function that 
takes two or more arguments.  Ticket #3641. (CVS 6269)

FossilOrigin-Name: e20bf384668bcde7c2f2152ca88e28cf65a02679
 2009-02-09 13:19:28 +00:00
danielk1977
53b6028b9c Attempt to reproduce ticket #3643. No luck yet. (CVS 6267) 
FossilOrigin-Name: 8f2f98d247b04ae6bda34621e9ccdba904f34ad7
 2009-02-09 05:18:33 +00:00
danielk1977
03ab035796 Changes to the backup API: (1) if a negative number is passed as the second argument to backup_step(), this is interpreted as "copy all remaining pages" and (2) if backup_finish() is called after backup_step() fails with a BUSY or LOCKED error, then this error is also returned by backup_finish() (same handling as for other errors encountered by backup_step()). (CVS 6266) 
FossilOrigin-Name: 9b8c8b18cf6b7d44d5fd64760537bc030097756b
 2009-02-06 05:59:44 +00:00
drh
f4883888ca Fix a test case that was still using the old pending_byte mechanism. (CVS 6265) 
FossilOrigin-Name: 08ec4f2c394ec834c20bfce0d98bbe6b4ce2be65
 2009-02-05 17:00:54 +00:00
drh
c7a3bb94c2 Make the pending byte adjustable via sqlite3_test_control() on all builds, 
not just on test builds. (CVS 6263)

FossilOrigin-Name: e8f192e2a93350a136d86bd9caceff65f52f3513
 2009-02-05 16:31:45 +00:00
drh
dc2c491525 Add "backup" and "restore" methods to the TCL interfaces and test cases 
to exercise those methods. (CVS 6260)

FossilOrigin-Name: e420a3cedc7ee086a77cd719f6b9fb85415eb5f3
 2009-02-04 22:46:47 +00:00
drh
b309becded Simplify wording of backup API error message. Decapitalize some other 
error messages. (CVS 6256)

FossilOrigin-Name: f92405afb649b698b735b423cd9195d4f8f137c9
 2009-02-04 17:40:57 +00:00