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

1564 Commits

Author SHA1 Message Date
drh
919e3b3908 Another fix to the hash signature algorithm in vfslog.c. 
FossilOrigin-Name: 34212aa8c405c4ff3f8045ec0cf2a860af61540f
 2013-10-10 13:41:04 +00:00
drh
7cd84ffc60 Fix the hash signature algorithm in vfslog.c. Add a utility program to 
show the hash signatures for every page of a database file.

FossilOrigin-Name: eaf4de13a63b2294ae575432a022493308a4313a
 2013-10-10 13:38:51 +00:00
drh
6f38a6418c Merge bug fixes from trunk. 
FossilOrigin-Name: 1d7b2dc0eae70c0c0e523b715acf758bb4cfa9ac
 2013-10-07 10:48:06 +00:00
drh
8ab88326cb Restore the hexrekey pragma which was accidently deleted during the 
pragma refactoring.  Make sure the hexkey and hexrekey pragmas do not
overflow buffers with a over-length key.

FossilOrigin-Name: 0aca31e1514b3df254c049b4251bcb199831681a
 2013-10-07 00:36:01 +00:00
drh
0af62b015a Improvements to the LogEst command-line tool used to convert between 
ordinary numbers and the LogEst representation.

FossilOrigin-Name: 5252aeb61988e511dcf8d527fa81e51a5c9385f9
 2013-10-05 18:32:30 +00:00
drh
bf539c4d5c Begin an experimental refactoring to estimate the average number of bytes 
in table and index rows and to use that information in query planner.
Begin by renaming WhereCost to LogEst and making that type and its
conversion routines available outside of where.c.

FossilOrigin-Name: 66c4a251d61582b47d5cbe50cbca160a9209bd06
 2013-10-05 18:16:02 +00:00
drh
f63936e805 Rework the PRAGMA implementation to only call sqlite3ReadSchema() from a single 
place, based on a flag in the pragma table, rather than separately from each
case which needs the schema.

FossilOrigin-Name: 8338232a111be16d6c2ab57176d0a23a001f02ad
 2013-10-03 14:08:07 +00:00
drh
01f75f2d68 In the lemon parser generator, change all hashes to unsigned to avoid 
potential problems with signed integer overflow.

FossilOrigin-Name: 8d399a03de63c15908d63ed69140ee15c6275b8d
 2013-10-02 20:46:30 +00:00
drh
be007dc61e Fix comments in the fast_vacuum.c demonstration program. 
FossilOrigin-Name: e0db7b38e1bc0edb1c3995cb23c46488aa6a0909
 2013-10-01 19:36:15 +00:00
drh
ba7df1188a Add the "fast_vacuum.c" demonstration program to the tool/ subdirectgory. 
FossilOrigin-Name: 2b60320d57a4638ebf97a2854527649c671d108e
 2013-10-01 19:02:56 +00:00
drh
2f312ee65f Updates to the sqlite3_analyzer utility: Change the names of some labels, 
especially change "Fragmentation" to "Non-sequential pages".  Revise the
computation of non-sequential pages so that it ignores itercalated non-leaf
pages (overflow and index pages).

FossilOrigin-Name: 3e5c7771fa91d8ae1e495432329b87af87b1ebc6
 2013-09-28 12:40:55 +00:00
mistachkin
02e8689233 VSIX tooling changes to support Visual Studio 2013. 
FossilOrigin-Name: d56fac40313e7d2e77dac3e2bc47cbbb3d10c656
 2013-09-13 22:38:54 +00:00
drh
77ff23f9c7 Fix the "const" qualifiers on the pragma name table. 
FossilOrigin-Name: b74e6be818fa7d19f1af6d86ad1d2ecba334b01b
 2013-09-13 21:03:45 +00:00
drh
55e85ca5f5 Add the soft_heap_limit pragma. 
FossilOrigin-Name: c326356f9a18bff5cf36bd59331e2cc207e349fa
 2013-09-13 21:01:56 +00:00
drh
d49c358e39 Tweak the new PRAGMA name parser to achieve full branch test coverage. 
FossilOrigin-Name: c82e05c4b8e000684d95ac8417afaef5e4d633e6
 2013-09-13 19:00:06 +00:00
drh
6bb64f6a31 Enhance the pragma lookup table generator script to output a comment that 
gives the number of pragmas.

FossilOrigin-Name: ca05205050752b5d5f583421b7813fba62f5085c
 2013-09-13 16:56:17 +00:00
drh
9ccd8659ff Change the PRAGMA parser to use a binary search for the pragma name. 
Also:  Minor performance enhancement to sqlite3DbFree() and to the
token dequoter.

FossilOrigin-Name: 870c030b4e1854e6e0d39907fadbd82774c16f56
 2013-09-13 16:36:46 +00:00
mistachkin
36c12888b5 Merge updates from trunk. 
FossilOrigin-Name: fca799f03ad04b7d36381108ff10e9c7d03656ac
 2013-09-12 00:40:54 +00:00
drh
59255f9a98 Merge in all the latest trunk changes, including the win32-longpath VFS and 
the fix for the segfault in the omit-left-join optimization.

FossilOrigin-Name: cdd3838b7876639cf99904b2054884247fbff529
 2013-09-03 14:49:07 +00:00
mistachkin
1a88b14e5d Revise the amalgamation tool to allow 'duplicate' include files to be retained manually while still preserving the existing line numbers. 
FossilOrigin-Name: aa48284637b954d63bcf77e19b25e75c7ad1a6d3
 2013-08-31 18:06:52 +00:00
mistachkin
2a43c28f06 Avoid commenting out #include statements when building the amalgamation source code file. 
FossilOrigin-Name: 2fca6d784b000fd3a4d6890e38a0b087767f3a7f
 2013-08-31 05:46:42 +00:00
dan
9f0656d8c5 Merge recent trunk changes. 
FossilOrigin-Name: 6cc54de88bba00e07fac9de36caac216d94bf070
 2013-08-23 17:54:46 +00:00
dan
7dd8d0a87b Modify script mkautoconfamal.sh to use the download.html naming convention for the tar.gz it creates. 
FossilOrigin-Name: 375b4e3db0e0c9e83034d1c33d7c57aca48e87b6
 2013-08-23 12:04:52 +00:00
drh
7fb30bd0dd Merge in the latest trunk changes, including partial indexes, the MAX_PATH 
fix in os_win.c, and the sqlite3_cancel_auto_extension() API.

FossilOrigin-Name: 7e1acb390770d1bd189fac7a3a7f96106f96e3a4
 2013-08-02 20:44:48 +00:00
drh
cc0713057f Enhance the sqlite3_analyzer tool to give reports on the sizes of individual 
indices.

FossilOrigin-Name: 3b4096cc8a3b4517cdf49dcfe1f33279a5eb8efb
 2013-07-17 18:12:15 +00:00
drh
fd64cedc4b Bring the sessions branch up-to-date with all the latest trunk changes. 
FossilOrigin-Name: 086a127236ee99d67513490fb7b5549e8b752c44
 2013-06-26 13:31:50 +00:00
mistachkin
463f348f2c Update comments and package flavor error message. 
FossilOrigin-Name: 9d1b96182af08a73de9dd0327965b96a6d48ac11
 2013-06-21 07:54:39 +00:00
mistachkin
9894742beb Use the target platorm version in the VS props file as well. 
FossilOrigin-Name: ce5a8cc1cf663546ebdce08bef7d957ed4d341c6
 2013-06-20 19:07:58 +00:00
mistachkin
50420545fc VSIX tooling changes to support Visual Studio 2013. 
FossilOrigin-Name: c5954c58c043fed24471fa184048e4ea0b5ba1d6
 2013-06-20 18:53:33 +00:00
drh
12ffbc7e69 Fix an off-by-one error in the WhereCost to integer conversion. 
FossilOrigin-Name: b5ca80d924f8c6d31f036247ba6e20d234f4482e
 2013-06-13 14:51:53 +00:00
drh
37ca04880a Merge all changes from trunk. 
FossilOrigin-Name: f2e15b1974e55373b5819e3b2326653f890f409f
 2013-06-12 17:17:45 +00:00
drh
5822d6feb2 Fix test cases for the new EXPLAIN QUERY PLAN format. Add the 
wherecosttest tool.  Other fixes to logarithm cost.

FossilOrigin-Name: aa580e368e3c398b8377b80342dfdd906324c248
 2013-06-10 23:30:09 +00:00
mistachkin
753050871a Improve manual cleaning step performed by the multi-platform build tool for MSVC. 
FossilOrigin-Name: d5bc1fe1c461bdb3d889ab2e50feb944881822a4
 2013-06-07 22:12:20 +00:00
dan
555c939dc7 Add the "dist" target to main.mk. For building the amalgamation autoconf package. 
FossilOrigin-Name: 3fdc8b56493350fc4854fb1eaefe29ac87784f91
 2013-05-27 18:37:33 +00:00
drh
ec7ecb8c9a Merge all recent trunk changes into the sessions branch. 
FossilOrigin-Name: 3879ab1b532828fcc12a50a95b6730faebcb69e9
 2013-05-03 18:29:22 +00:00
drh
4ee09b4bcc Allocate 4 bytes of unused header space for an "Application ID". Add 
the "PRAGMA application_id" command to set and query this identifier.
Add the "magic.txt" file to show how the posix file command might use
this application id.

FossilOrigin-Name: 28c9e7fdee2471a3026ee05ff591194d5f398131
 2013-05-01 19:49:27 +00:00
drh
e67f418d10 Fix the tool/build-shell.sh script to remove references to files that are 
now loadable extensions.

FossilOrigin-Name: aabeea98f53edde68f484f1794ae70789dac3889
 2013-04-25 17:27:08 +00:00
drh
16fb176814 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 6994826c0784280f2e9728dfa4185848846d03df
 2013-04-22 23:59:06 +00:00
dan
d7a959c694 Add virtual table module 'fts3tokenize' to fts3. fts3tokenize provides SQL access to FTS tokenizer implementations. 
FossilOrigin-Name: c5a4b21a15bd8a184380817ff41657acbccb866d
 2013-04-22 15:30:37 +00:00
mistachkin
73c4041b43 Correct minor typo in two regular expressions. 
FossilOrigin-Name: f1eed92b7b0ef4ee22a11d8bb4f9a572b56ce019
 2013-04-11 00:45:28 +00:00
mistachkin
f13394c0ad Experimental changes to support a Win32 VSIX package flavor. 
FossilOrigin-Name: abedd7cb454aab99b62b63ed4fdd70c31ef87b0b
 2013-04-11 00:13:46 +00:00
drh
eeeee7f55d Designate the beginning and the end of the sqlite3session.h file in the 
constructed sqlite3.h file.

FossilOrigin-Name: 53f5be74327162a2bd25a91eaf7c91b126294727
 2013-04-10 15:01:36 +00:00
drh
1ffe7c7fab Also export the sqlite3changeset interfaces in the amalgamated version of 
the sessions extension.

FossilOrigin-Name: 5b399f2bc43612c52ea2289001d852d7ba6f9750
 2013-03-19 17:10:10 +00:00
drh
339d6c6d17 Bring makefiles and build scripts into alignment with the sessions branch. 
No changes to code.

FossilOrigin-Name: d1f41089aba075eef45fd696599e5d3a74c84d0c
 2013-03-19 16:12:40 +00:00
drh
e191e2c6d0 Include the sqlite3session.h header file in with sqlite3.h. Make sure 
the session APIs are all public.

FossilOrigin-Name: ec490336bc6629d3910667ece1bbc4685a199546
 2013-03-19 15:23:18 +00:00
drh
498dcae0f0 Fix a compiler warning in sqlite3VdbePreUpdateHook(). 
Add sqlite3session.c to the amalgamation.
Fix the Makefile.in to work with sessions.

FossilOrigin-Name: e54b0225f226a163ec874df7d4b738efba12b3a7
 2013-03-13 11:42:00 +00:00
drh
edf9a17b47 Simplified error message on the showdb utility. 
FossilOrigin-Name: 8e0ced1af78d8c25a06423a8e7e337ac845155cc
 2013-03-05 01:46:26 +00:00
drh
344a97b4b0 Enhance the showdb tool with options to show PTRMAP usage and content. 
FossilOrigin-Name: 06bd91305ed6752315c5224be5f89e87cafa6687
 2013-02-19 22:26:51 +00:00
drh
103a70fa62 Fix the showdb utility so that it displays the correct secondary usage of 
a page when reporting on an error of a page being used more than once.

FossilOrigin-Name: 4507f0b3d409cd14bb2b9c29c92c76aa3ccb22b6
 2013-02-19 20:25:16 +00:00
drh
00e637f0f0 Enhance the pgidx of the showdb utility so that it provides better information 
even if the sqlite_master table is corrupt.

FossilOrigin-Name: d14263a719101d9c70054f2fc37e7788f73aab28
 2013-02-19 18:45:11 +00:00