database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-21 09:00:59 +03:00
Code Activity
29,836 Commits 1,611 Branches 185 Tags
json-opt
Commit Graph

19158 Commits

Author SHA1 Message Date
shane
be21779385 Corrected typos and misspellings. Ticket #3702. (CVS 6336) 
FossilOrigin-Name: 6404afa0c515a6536fc2e878d4fb451e4dc06942
 2009-03-05 04:20:31 +00:00
shane
c0688ea172 Removed compiler warnings from MSVC builds. Ticket #3701. (CVS 6335) 
FossilOrigin-Name: 5477833ec7f707ea9937d3fd6a6d8ab49f2016f1
 2009-03-05 03:48:06 +00:00
shane
ce6fa1706a Converted EXPR_*SIZE macros to use offsetof() to avoid MSVC compiler warnings. (CVS 6334) 
FossilOrigin-Name: 5e8e16f7d505a4b21272f1d300f366ee0e211e56
 2009-03-02 17:18:48 +00:00
drh
18209cd6e2 Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT option for the new Expr compression 
logic of check-in (6305).  Bug discovered during regression testing. (CVS 6333)

FossilOrigin-Name: 91969edac737adf087e35e10aa0a732b3303afd5
 2009-03-02 14:24:21 +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
drh
d43fe20bc9 Suppress some compiler warnings (where possible). Ticket #3696. (CVS 6331) 
FossilOrigin-Name: a2373e5409e4e59903f315a4446db8cb6ba000cc
 2009-03-01 22:29:20 +00:00
drh
b45f65db8f Fix a critical bug in the VDBE opcode array resizer introduced by 
check-in (6307).  Bug detected by regression testing. (CVS 6330)

FossilOrigin-Name: ec3b18acaecabae6eb04eda006870e602faacb8c
 2009-03-01 19:42:11 +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
drh
da10822a61 Move the new genfkey shell command out from within #ifdef _WIN32_ (CVS 6327) 
FossilOrigin-Name: 48ee0e47e2d9669cc7425104e6b04ce49caf2e56
 2009-02-25 19:07:24 +00:00
danielk1977
e632004fdd Remove genfkey.c. Change genfkey.README to talk about the new shell dot-command, not the old standalone genfkey program. (CVS 6326) 
FossilOrigin-Name: 36d699660bc328e65170d72be715338e82dbbb50
 2009-02-25 15:43:57 +00:00
danielk1977
c8c7069035 Add the 'genfkey' functionality to the sqlite3 shell. Accessed using a new dot-command - ".genfkey". (CVS 6325) 
FossilOrigin-Name: 0a59fb28b46e5d85c850d1dfa1385a4656e4dda5
 2009-02-25 15:22:02 +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
drh
11b57d6929 Additional commands and another procedure name changes for clarity of 
presentation. No logic changes. (CVS 6323)

FossilOrigin-Name: 91d9d51e03657e7492dd7b93e66c82b152abec3b
 2009-02-24 19:21:41 +00:00
drh
c25eabedef Changes to comments and functions/procedure names for clarification. No 
changes to logic. (CVS 6322)

FossilOrigin-Name: b99c1815fe270decf1ac3d714acc7e945d1e728a
 2009-02-24 18:57:31 +00:00
danielk1977
2b0223ecf6 Remove old declaration of sqlite3_pending_byte (which was used by test code). It has been replaced by sqlite3PendingByte. Ticket #3677. (CVS 6321) 
FossilOrigin-Name: 44f0162ebb760dd6926ee5691752b6798e3aacb9
 2009-02-24 18:40:49 +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
drh
c74d0b1dfc Enhanced comments on table locking logic as it relates to preparing new 
statements.  Added assert() and testcase() but no other changes to code. (CVS 6319)

FossilOrigin-Name: 4a12f5b818b769d7518c942ff3dedf453dde698e
 2009-02-24 16:18:05 +00:00
danielk1977
2d2e7bd32e Reverse commit (6315) for now. (CVS 6317) 
FossilOrigin-Name: 0e7c369c23a8767b4d3e5cdd47c14716992fb71a
 2009-02-24 10:14:40 +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
danielk1977
7c5c3cab89 Ensure the return value of sqlite3_errmsg16() is aligned on a 2-byte boundary. Ticket #3665. (CVS 6313) 
FossilOrigin-Name: 9b8acf8319ec760713773407a4d5a33dea8d75e8
 2009-02-23 14:42:53 +00:00
danielk1977
d336e222f4 Instead of using SetNumColumns, specify the number of columns in a table or index using the P4 argument. (CVS 6310) 
FossilOrigin-Name: e43ed649630cbc49a6f2a25a26a4a6b5fce84c48
 2009-02-20 10:58:41 +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
drh
5053a79b6c Add the OP_HaltIfNull opcode and use it to simplify prepared statements 
for INSERTs and UPDATEs of tables with NOT NULL columns. (CVS 6308)

FossilOrigin-Name: feccad8d0d05925ce67856d40ffe1bc7054168a0
 2009-02-20 03:02:23 +00:00
drh
b2771ce24c Reuse space left-over opcode space at the end of the VDBE opcode array to 
store memory cells, VDBE cursors, and other content needed by the VDBE.
This reduces the memory required by a prepared statement. (CVS 6307)

FossilOrigin-Name: 58a1809257ccfb7d9112a35f79ca2f82b3daa878
 2009-02-20 01:28:59 +00:00
drh
e1935f2367 Remove code in malloc.c that was already commented out using #if 0. (CVS 6306) 
FossilOrigin-Name: e1ad757ec0abead25265f9251c954d2497bccc06
 2009-02-19 20:50:14 +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
8b39db1c83 Move the text of C-API requirements out of the sqlite.h.in source file and 
into separate files in the "docsrc" CM system.  Comment changes only - no
changes to code. (CVS 6303)

FossilOrigin-Name: 419eb48b6b4238526850091eef28af503b6c4579
 2009-02-18 18:37:58 +00:00
drh
50b6568454 Add tests to double-check that nothing within SQLite ever tries to allocate 
amounts of memory that are close to the maximum signed integer, leading to
an integer overflow within malloc().  This is not currently a problem.
The extra tests just insure it never becomes a problem. (CVS 6298)

FossilOrigin-Name: f6ba7bb9152cffc9f67dfa7de12e36a3244b7e03
 2009-02-17 18:37:28 +00:00
danielk1977
f37adcb40f Initialize an uninitialized buffer to silence a valgrind warning during a VACUUM operation. (CVS 6297) 
FossilOrigin-Name: 8c61968b33dd753618589cb3f859984223161d64
 2009-02-17 17:56:30 +00:00
danielk1977
0a54907159 Allow sqlite3_shutdown() to be called by a process before sqlite3_initialize() is. Prior to this commit such a call could segfault. (CVS 6296) 
FossilOrigin-Name: 79431c58d964d6057c7f42f7c1df74f3df4493eb
 2009-02-17 16:29:10 +00:00
drh
e8df800d4c Make sure result variables are initialized or unused following a failure 
of the xFullPathname VFS interface.  Problem detected by valgrind. (CVS 6295)

FossilOrigin-Name: 59a4755185f0e51699cd020ae67d279bee45de1c
 2009-02-17 16:17:01 +00:00
shane
65ad7d225f Changes to remove some compiler warnings from MSVC. (CVS 6294) 
FossilOrigin-Name: 68f15442e8db364952d30daf4ce60c6b938f5906
 2009-02-16 17:55:47 +00:00
drh
38aec8dc09 Fix a compiler warning in backup.c. (CVS 6293) 
FossilOrigin-Name: 82222fbf5d5a085ce3e2c172c648a4c6d9750626
 2009-02-16 16:23:09 +00:00
drh
f16ce3bc2a Make sure OOM errors in the ANALYSIS loader get reported back out to 
high-level layers.  Strange behavior can result otherwise. (CVS 6292)

FossilOrigin-Name: 88a6355cd65ddb319dbc27b5248c664dbf599778
 2009-02-13 16:59:53 +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
aff46970a7 Add additional cross-references from API documentation to other documents. 
Comment changes only; no changes to code. (CVS 6290)

FossilOrigin-Name: 97203a0ad7a7ddfae04daf99558389b0589fc170
 2009-02-12 17:07:34 +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
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
drh
46f33ef93c Continuing documentation refinements. Comment changes only. (CVS 6284) 
FossilOrigin-Name: 83e8308435be8c954fe7a347a64f28abcb81437b
 2009-02-11 15:23:35 +00:00
drh
ae1a880719 Add hyperlinks from sqlite3_limit() documention to the limits.html page. 
Comment changes only - no changes to code. (CVS 6282)

FossilOrigin-Name: f0189ec8c9b5d1dfe1f5d93746cc7b5703a80de5
 2009-02-11 15:04:40 +00:00
danielk1977
d6846d75ca Fix the crashtest infrastructure so that it doesn't trigger the "don't write to the locking region" assert in os_unix.c. (CVS 6281) 
FossilOrigin-Name: b7fd4615cd41179484bd44d2f4bd7aef04977911
 2009-02-11 14:27:04 +00:00
danielk1977
4faa5f41b8 Modify the test_journal.c code to (1) account for the backup code writing to parts of the pending-byte page when changing a databases page-size, and (2) to avoid reading from the pending-byte page and triggering the assert in os_unix.c. Changes to test code only. (CVS 6280) 
FossilOrigin-Name: 4879621658c2c785ab7b12dbae780901496d3a78
 2009-02-11 07:38:11 +00:00
danielk1977
9ec30744bf In test_mutex.c, zero the global structure staticly instead of in Sqlitetest_mutex_Init(). This is because Sqlitetest_mutex_Init() is now called by each thread during thread tests ((6193)). Test code changes only. (CVS 6279) 
FossilOrigin-Name: 8b318b9385d0542ca56750b901c0c6b7d05ca634
 2009-02-11 05:18:06 +00:00
danielk1977
2b754b4820 For the "onefile" demo, pass SQLITE_OPEN_TEMP_DB instead of MAIN_DB to the OS layer when opening the single file. This is to work around the assert() in os_unix.c that tests that the locking region is not written to. (CVS 6278) 
FossilOrigin-Name: 2da076a2c1663e916dc50e5e1679be216922dfc5
 2009-02-10 18:54:02 +00:00
danielk1977
2d42c2b247 Prevent code in test6.c from reading the 512 byte locking region (the PENDING_BYTE page) of a database file. Doing so triggers an assert failure in os_unix.c. (CVS 6276) 
FossilOrigin-Name: 2a6a43169220fab5a15a786e2a464b90cb893179
 2009-02-10 14:28:57 +00:00
drh
52224a73f1 Create links from backup API documentation to the backup application note. 
Comment changes only - no changes to code. (CVS 6275)

FossilOrigin-Name: 85de23fb4e63e5c71480c4c34efec331e774d7fb
 2009-02-10 13:41:42 +00:00