database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-26 09:41:10 +03:00
Code Activity
30,154 Commits 1,567 Branches 182 Tags
empty-table-optimizations
Commit Graph

9780 Commits

Author SHA1 Message Date
drh
fb7e7651ca Change the TCL interface so that it can cache VMs and reuse them without 
recompiling.  But for now leave the cache turned off by default. (CVS 2269)

FossilOrigin-Name: 8db6bfef52c1f35afdb8b60cba34f6807a5917f4
 2005-01-24 00:28:42 +00:00
drh
178286b5df ATTACH and DETACH cause prepared statements to expire. 
sqlite3_finalize() can now be called right after sqlite3_reset(). (CVS 2265)

FossilOrigin-Name: 6c631b86e5e166f650d3f7d53c773aa859391c2b
 2005-01-23 13:14:55 +00:00
danielk1977
32554c10d0 Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264) 
FossilOrigin-Name: 764b55adb5dff944db36d0d19ce5e7cc758b3a9e
 2005-01-22 03:39:39 +00:00
drh
d89bd007ba Add the experimental sqlite3_expired() API. (CVS 2263) 
FossilOrigin-Name: df648d50c0696cf7ada2fe5973d285b494891964
 2005-01-22 03:03:54 +00:00
drh
7bf5661068 Final preparations for the 3.1.0 alpha release. (CVS 2255) 
FossilOrigin-Name: 17122c7e8e9cae36f1ffa7b42bd69d702980ac6a
 2005-01-21 15:52:32 +00:00
danielk1977
576ec6b32a Improve test coverage for minimum feature builds. (CVS 2254) 
FossilOrigin-Name: 9c4d0e13e8c5f3fc4d7fd8f495898372293f7fad
 2005-01-21 11:55:25 +00:00
danielk1977
e61b9f4f3c Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) 
FossilOrigin-Name: d4e19efcef68d834c55c7d496cdb3696d63a31a2
 2005-01-21 04:25:47 +00:00
danielk1977
3e8c37e7f8 Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) 
FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
 2005-01-21 03:12:14 +00:00
drh
801845fb2d Add a new test file for subqueries. (CVS 2250) 
FossilOrigin-Name: de8ee3a29e1aafcfa05841cb44da0a05f0579596
 2005-01-21 02:34:44 +00:00
drh
fe2093d73e Bug fixes and enhancements entered while on jury recess. (CVS 2246) 
FossilOrigin-Name: 38401dfbd5e3b50dd4e7a11562a7770347cebdf4
 2005-01-20 22:48:47 +00:00
danielk1977
1ad7f64aac Changes so that crash.test works when SQLITE_OMIT_PAGER_PRAGMAS is defined. (CVS 2242) 
FossilOrigin-Name: f0add0a60e0afb833202e42cdba97bafe6a59dfc
 2005-01-20 05:24:32 +00:00
danielk1977
4489f9bdec Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) 
FossilOrigin-Name: d267fb3ca3f31ee138c9613cb84e873ede7f141a
 2005-01-20 02:17:01 +00:00
danielk1977
600dd0ba33 Add the experimental sqlite3_sleep() and sqlite3_clear_bindings() APIs. (CVS 2237) 
FossilOrigin-Name: 9480209e8600bf411975b3950c407d60c800e5c6
 2005-01-20 01:14:23 +00:00
drh
1398ad3639 Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) 
FossilOrigin-Name: d8b2a7e09187564fe66a2b4bf0992c6a017146cf
 2005-01-19 23:24:50 +00:00
danielk1977
76b047d957 Another fix along the same lines as (2234) (CVS 2235) 
FossilOrigin-Name: 27cf83224c69e661c19f9a09f39bfdae75e3b0a4
 2005-01-19 03:52:54 +00:00
danielk1977
ca6707145d A few test cases were failing on windows due to mandatory locking. Omit them on that platform. (CVS 2234) 
FossilOrigin-Name: 441316f1af076fef42055d6abe524f2a8c5ced63
 2005-01-19 03:47:15 +00:00
drh
030530de9b Make sure USING and NATURAL work on joins even if the columns are renamed 
using an AS phrase.  Ticket #523. (CVS 2233)

FossilOrigin-Name: c06add57bf0ce17503181b584ea4197b39b9e538
 2005-01-18 17:40:04 +00:00
drh
79d5f63fa2 CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) 
FossilOrigin-Name: b1d4c42d2be07adda68d31c570ba7cf8b115c3ad
 2005-01-18 17:20:10 +00:00
drh
47a6db2bfd Column names coming back from a SELECT are now just the name of the 
source column without the "table." prefix. In other words,
"PRAGMA short_column_names=ON" is now the default.
This makes the names of columns behave more like other SQL engines.
The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231)

FossilOrigin-Name: 9295050af1bf2d9d4dc63adc225a2848d67cbe17
 2005-01-18 16:02:40 +00:00
drh
9b3187e113 Continue refactoring name resolution. Fix for ticket #1047. (CVS 2230) 
FossilOrigin-Name: 88d4834fec7583a9b6400a1ce5b928c1f8a390dd
 2005-01-18 14:45:47 +00:00
danielk1977
3719d7f9c4 Fix a bug reported on the mailing list concerning a conflict between "INSERT INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227) 
FossilOrigin-Name: 5a9da62ae303800ded99942aed30eadeb3863da3
 2005-01-17 08:57:09 +00:00
danielk1977
5558a8a697 Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) 
FossilOrigin-Name: 6244252915fa312a6c4d192464023d95aaef4661
 2005-01-17 07:53:44 +00:00
danielk1977
2683665406 Have sqlite3pager_get() return SQLITE_CORRUPT for a page number greater than 2^31. (CVS 2222) 
FossilOrigin-Name: feb49d10e83ecc186024d4e96b64ef92cf876715
 2005-01-17 01:33:13 +00:00
drh
615ae553fc Turn on quick-balance by default. (CVS 2221) 
FossilOrigin-Name: d0356dee55bd43f361ede1344e90d1ba6b5cde1e
 2005-01-16 23:21:00 +00:00
danielk1977
aac0a38d1f Changes to make sure tests work when SQLITE_DEFAULT_AUTOVACUUM is defined. (CVS 2219) 
FossilOrigin-Name: 6237c294d1211d5848bafb1310574e2486a43757
 2005-01-16 11:07:06 +00:00
danielk1977
4e17d14c63 Fixes so that compiling and testing works when SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2218) 
FossilOrigin-Name: fe548561a0e7a696fd453372f4427cf3e3f19d20
 2005-01-16 09:06:33 +00:00
danielk1977
ac11ee6766 Enhance the performance of auto-vacuum databases by reducing the number of pointer-map entries written during tree balancing. Also fix bugs in balance_quick(). (CVS 2216) 
FossilOrigin-Name: 0ae29538ccccfc237904cbcfb4507074db0f5905
 2005-01-15 12:45:51 +00:00
drh
018d1a4929 Test coverage improvements. (CVS 2215) 
FossilOrigin-Name: 92f9d2b2f480fccfa6e8b70a1d19058b92a4ea8f
 2005-01-15 01:52:31 +00:00
drh
8b07c7178a Improved test coverage for update.c. (CVS 2214) 
FossilOrigin-Name: 3ef95d5fe98e7451f8b87b3f5259163f3e7d0289
 2005-01-15 00:40:42 +00:00
drh
39df51b269 Improved coverage for insert.c. (CVS 2213) 
FossilOrigin-Name: 997d8afff9b316aef4c5e2127c2207758ff4a703
 2005-01-15 00:36:36 +00:00
danielk1977
ac245ec5af Experimental patch to balance() (use -DSQLITE_BALANCE_QUICK). (CVS 2211) 
FossilOrigin-Name: c550d80c25ec88fceb20acabd00c21faa2d552f5
 2005-01-14 13:50:11 +00:00
drh
d6fe961ef4 Improved test coverage on insert.c. (CVS 2210) 
FossilOrigin-Name: c772f75166d55192132e732e8a0ddda5926f00f2
 2005-01-14 01:22:00 +00:00
danielk1977
c08d405d2e Tidy up malloc.test a bit. (CVS 2207) 
FossilOrigin-Name: 94cf91cc5dc0d656636211d23350a1ec29aced8a
 2005-01-13 13:35:57 +00:00
danielk1977
aca790ace3 Test cases to improve coverage of pager.c. (CVS 2205) 
FossilOrigin-Name: 0428a1480126f7e73dc1e24b6fbfa185d2d83dd3
 2005-01-13 11:07:52 +00:00
danielk1977
2c3365493b Fixes to 'configure' build system. Also extra coverage for main.c. (CVS 2204) 
FossilOrigin-Name: 8378455f32c3010ccc28181048c746ecb8a9fa67
 2005-01-13 02:14:23 +00:00
danielk1977
656152c2e3 Fix a test bug introduce with the previous commit. (CVS 2203) 
FossilOrigin-Name: 1c19e8bdca24484fcb9f068b38ebfbce3e24ada5
 2005-01-12 13:04:54 +00:00
danielk1977
4397de57ce Tests to improve coverage of main.c. (CVS 2202) 
FossilOrigin-Name: 4e28c82adabb58ad9f79ed829734a2ff569a7c05
 2005-01-12 12:44:03 +00:00
danielk1977
8b60e0f142 Tests to improve coverage of vdbeaux.c. (CVS 2201) 
FossilOrigin-Name: 2b3e21ce2e8126ec2851751546094c3a2c831942
 2005-01-12 09:10:39 +00:00
danielk1977
b5402fbf05 Tests to improve coverage of vdbemem.c. (CVS 2200) 
FossilOrigin-Name: 319bb4a9064deb062a888fdc31067619c9b749bb
 2005-01-12 07:15:04 +00:00
drh
c8f9079c61 Fix a bug in tclsqlite.c. (CVS 2199) 
FossilOrigin-Name: 50f1e229652610b386745bb39fed45549cc74aa7
 2005-01-12 00:08:24 +00:00
drh
ac931eb93b Fix for ticket #1062: Correctly handle redundant terms in a WHERE clause. (CVS 2198) 
FossilOrigin-Name: 1bee1bb91d39ff8a33efe662b6cab6dbd2d50e3c
 2005-01-11 18:13:56 +00:00
drh
48e5aa2769 Test coverage improvements on tokenize.c. (CVS 2196) 
FossilOrigin-Name: 5767850ccadb3b53d14bca547e50f65de1d3092e
 2005-01-11 17:46:41 +00:00
drh
c5cdca613a Improved test coverage for vdbeaux.c. (CVS 2195) 
FossilOrigin-Name: 3f46cd7767cf7c48dd1de7ae1c4104d6d1a609be
 2005-01-11 16:54:14 +00:00
drh
cacb208e4e Improved test coverage for util.c. (CVS 2194) 
FossilOrigin-Name: ad451a2ddc7993035768f2801d590311807f4397
 2005-01-11 15:28:33 +00:00
danielk1977
01427a6214 Test cases to improve coverage of vdbe.c. (CVS 2193) 
FossilOrigin-Name: a6b45722071bde543c4ea28a432339d8708a5cac
 2005-01-11 13:02:33 +00:00
danielk1977
2812956b18 Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) 
FossilOrigin-Name: 8ced491588764b1e1066787d0abf3cde8b60970b
 2005-01-11 10:25:06 +00:00
danielk1977
7701e817ba Extra test cases to improve coverage of btree.c (CVS 2189) 
FossilOrigin-Name: a461988661368bce799ef3d498a18e88559e14c7
 2005-01-10 12:59:51 +00:00
danielk1977
cc6bd38380 Fix an assertion failure due to interaction between the count_changes pragma and triggers. (CVS 2187) 
FossilOrigin-Name: 6c7bec1b3aee0287e30f43c1d6a7b67b1c47e774
 2005-01-10 02:48:49 +00:00
drh
268283bc7f Fixes to the temp_store_directory pragma. (CVS 2185) 
FossilOrigin-Name: 0a90eaf398aa4a689cd8326cd017951513ca748a
 2005-01-08 15:44:25 +00:00
danielk1977
59adfaa6ce Minor test script changes to allow all.test to run when SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (CVS 2182) 
FossilOrigin-Name: 5023b1dba2e61bb10d1b488874e3d3eea3973145
 2005-01-08 02:35:44 +00:00