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
29,798 Commits 1,570 Branches 184 Tags
tclsqlite-db-copy-fix
Commit Graph

5077 Commits

Author SHA1 Message Date
drh
65e6b0dd12 Add the sqlite3_rtree_query_callback() API to the RTree virtual table. 
(Cherrypick from the sessions branch.)

FossilOrigin-Name: af2cbe64adab5f9e3b0f3da00d06428088589d7f
 2014-04-28 17:56:19 +00:00
drh
c686929914 Enhance the sqlite3_rtree_query_info object to report on the number of 
elements in the priority queue at each level.

FossilOrigin-Name: f7dad408dd46a1e3612b6142a3afb1d0d4fcda00
 2014-04-25 16:29:03 +00:00
drh
98cf9d74f8 Fix the generation of sqlite3_rtree_query_info.iRowid and add test cases 
to verify that it is fixed.

FossilOrigin-Name: eba95ead49f8f8ce45d400186562ff0066537c5c
 2014-04-21 18:13:37 +00:00
drh
74188329ce Be sure to initialize the sqlite3_rtree_query_info.iRowid field for the 
leaves of the R-Tree when doing a query callback search.

FossilOrigin-Name: 4394693882c04c19ebe87ef7547c57e679554397
 2014-04-21 15:53:45 +00:00
drh
a6ca7f2c1b Fix an off-by-one error in setting the "iLevel" field of the 
sqlite3_rtree_query_info structure passed into the RTree query callback.

FossilOrigin-Name: d708f159abfb3b87e2844463088d4fb7f8da9c97
 2014-04-21 15:21:19 +00:00
drh
ec7c03a08b Further improvements to the RTREE_DECODE_COORD() method, to take advantage 
of known processor byte orders when available.  This makes the code 3% faster,
according to valgrind.  Also add test cases to make sure the on-disk
representation is correct.

FossilOrigin-Name: 6f3e94f4b1b403cd7bfc5e8e0ffbd61b5174d3a4
 2014-04-18 01:37:08 +00:00
drh
a5db90fc8e Performance optimization on byte-swapping in R-Tree. 
FossilOrigin-Name: 444084fd620fc3f45cfb87b83f532d76bd2744e7
 2014-04-17 23:23:29 +00:00
drh
1821cbacf1 More test cases with very long priority queues. 
FossilOrigin-Name: 71692aa97c78676f0ba80eaeec0ad9ac225f4427
 2014-04-17 15:34:58 +00:00
drh
b640595f97 Test cases and bug fixes for the sqlite3_rtree_query_callback() 
mechanism.

FossilOrigin-Name: 1ccaaed6b516ec2ce953c1b31025a82ba76d00e7
 2014-04-17 14:52:20 +00:00
drh
78b486ea12 Refactor the constraint checking logic in RTree. The new-style constraint 
callbacks created by sqlite3_rtree_query_callback() are now hooked up from
end to end, though still untested.

FossilOrigin-Name: 32a13870175a1dd1d33af3572dde09ff607a04b6
 2014-04-17 13:15:33 +00:00
drh
18b5142b29 Performance optimization on nodeGetCell() in R-Tree. 
FossilOrigin-Name: 5d20ff9ec837ad35bc44d6c25d13764b350e81dd
 2014-04-16 21:02:28 +00:00
drh
933a5ff2d4 TCL tests now all pass. 
FossilOrigin-Name: f864baccd3fe0ee939ac1ec20069792f649cddc0
 2014-04-16 17:15:14 +00:00
drh
ab908cfcb4 Fix a bug in rowid=? query handling. More problems remain. 
FossilOrigin-Name: 5b0e6ba4a5050cf81cf41b977b28d714163569e0
 2014-04-16 14:45:11 +00:00
drh
f247982e37 Bug fixes to the priority-queue implementation for R-Trees. Improved tracing 
capability.  Some queries work now, but still many problems.

FossilOrigin-Name: a439ddd629c6bb5ea2e7e274673fee4f5c207acf
 2014-04-16 13:00:08 +00:00
drh
96ce1b36aa Initial attempt at getting R-Tree queries to work using a priority queue. 
This check-in compiles, but R-Trees do not work well.  And there are
debugging printf()s left in the code.  This is an incremental check-in.

FossilOrigin-Name: 53688a25c23c394278a357829793889970aa4157
 2014-04-15 21:06:14 +00:00
drh
de8c279b28 Fix comments on the rtreenode() and rtreedepth() test function in the R-Tree 
module.

FossilOrigin-Name: ade5b986e8baab9df7bdaf7ccfaee2d6ba55fa3c
 2014-04-14 14:43:09 +00:00
drh
b6c3aeac90 Remove over 300 lines of unused code, code that implemented the older 
Guttman insertion algorithms that are no longer used.

FossilOrigin-Name: 3ba5f295c709faebf5505e61f6dc5266b811b086
 2014-04-14 12:18:17 +00:00
drh
8ae04b53c9 Continuing work on the new custom query mechanism for r-tree. 
FossilOrigin-Name: ca7357e66ca60f59477b1db000c2cdaeb8082ae1
 2014-04-13 16:10:09 +00:00
drh
0ccb6cdc87 Continuing clean-up of the R-Tree module in preparation for cutting in the 
new generalized query mechanism.

FossilOrigin-Name: 66c858f20586424e15d0bfa3d7b56643bde66226
 2014-04-12 17:44:00 +00:00
drh
c9cb207acf Add the new interfaces to rtree, though they do not yet work. Add the 
"show_speedtest1_rtree.tcl" script for showing the test data used for the
R-Tree tests of speedtest1.  Change speedtest1 to generate better R-Tree
test data.

FossilOrigin-Name: 0b70275972c7a6a533566c1e50bffbf3ac531e95
 2014-04-11 23:14:48 +00:00
drh
dcc5c7b2fc Update comments in the R-Tree module in preparation for some big changes. 
Add an "rtree" performance test to speedtest1.

FossilOrigin-Name: 20a73ec0b2f56609a4504052e198e32803d30207
 2014-04-11 16:14:54 +00:00
drh
24ed9d0445 Merge in fixes (including the corrupt-database crash fix) and 
performance enhancements from trunk.

FossilOrigin-Name: fc8ca1a87e7127bd28f32fd809aec3e24355fbfa
 2014-03-26 19:43:30 +00:00
dan
d88e521f59 Fix an obscure bug causing sqlite3_close() to fail if there are virtual tables on the disconnect list when it is called. 
FossilOrigin-Name: 6504aa47a8ebb13827be017c4cb4b2dc3c4c55f4
 2014-03-12 19:38:38 +00:00
dan
82d25da5b0 Changes to FTS to ensure that it does not access the database from within the xConnect method. 
FossilOrigin-Name: c67a52c356416cc200f51f9168d942e78db11d34
 2014-03-12 19:20:36 +00:00
dan
87af14a639 Prevent the rtree module from reading sqlite_stat1 data from the wrong database. 
FossilOrigin-Name: 7ce03c1b5552d830300575c5b41a874db7a2ec77
 2014-03-12 12:44:46 +00:00
drh
092378860d Bump the version number to 3.8.4.1., to conform with trunk. 
FossilOrigin-Name: 42c9d8fc5fe4f0250bfa1f977c7cc63e5741408f
 2014-03-12 10:03:13 +00:00
dan
3afca7d18c Add a test to see what happens if an rtree constructor encounters an SQLITE_BUSY error. No changes to code. 
FossilOrigin-Name: 5527e23636eee192030f6a3c41628030b6c50bb8
 2014-03-11 09:19:26 +00:00
drh
87778c7f96 Fix a harmless compiler warning in the sessions test harness. 
FossilOrigin-Name: d389e20ab07a76d0c4be3801265977fa977a4394
 2014-03-06 15:01:11 +00:00
drh
b7bc8c9849 Enhance the test harness for the sessions interface so that it does not 
use SQLite operations that can encounter an OOM error in places where it
is unable to report an OOM error back up to the test script.

FossilOrigin-Name: bc0e661033b78f27866932244e6204985ae39000
 2014-03-06 14:53:25 +00:00
drh
3bde1354ff Merge compiler-warning fixes from trunk. 
FossilOrigin-Name: a1f2b0428518ec18af74a0e01deb4e40cd95a78f
 2014-03-05 23:12:55 +00:00
drh
dc90d3d8af Always include the ctype.h header in the spellfix.c extension. 
FossilOrigin-Name: bfd75f471a607b442d8cd8a7070491a158e8fb1a
 2014-03-05 19:36:52 +00:00
drh
5671ef69ec Sync the latest trunk changes, and in particular the STAT4 IS NOT NULL fix. 
FossilOrigin-Name: b006792695d23980e1923b21915d5c1138ecf29d
 2014-02-11 04:30:29 +00:00
drh
0211d8bca4 Change the spellfix1 virtual table to deterministically names its shadow 
tables.

FossilOrigin-Name: 5219cdfc56ec3e1cd645ae6443ba72ce0df0339a
 2014-02-06 13:18:51 +00:00
drh
19913f4419 Bring in the latest updates from trunk. 
FossilOrigin-Name: 7b5f3773867ed0e4ed17bd473ba972d500035318
 2014-01-28 18:06:17 +00:00
drh
693e671936 Fixes for various clang warnings. 
FossilOrigin-Name: 87bf60637e5863c54c5e2d05aaaca0835b7aace8
 2014-01-24 22:58:00 +00:00
drh
c187698614 Bring in all the latest trunk changes, including the Common Table 
Expressions implementation.

FossilOrigin-Name: 9b43e559195680e558264c4c00d34dc9cf9d9146
 2014-01-24 14:05:18 +00:00
dan
a8a0617e06 Update the spellfix virtual table to optimize queries of the form "SELECT ... FROM tbl WHERE rowid=?". 
FossilOrigin-Name: a0ba55ff0596c5f15e9cdb254c68ef50df2dfaad
 2014-01-22 17:43:16 +00:00
dan
2e08486a08 Add the usual "fts3" prefix to new static method setEstimatedRows() in fts3.c. This fixes a problem when compiling the amalgamation, as the r-tree module also contains a static method named setEstimatedRows. 
FossilOrigin-Name: d6fcfc8890489b942e5b3f1bc271835d77c5ef96
 2014-01-04 19:58:29 +00:00
dan
69014393f8 Instead of having the planner ignore plans with unusable MATCH constraints, have FTS assign extremely high costs to such plans in order to discourage the planner from using them. 
FossilOrigin-Name: 24f84b38131866f7b435ffe641bb2f6991a70db2
 2014-01-04 14:42:14 +00:00
drh
d9e3c267b4 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: cfd110bf5db2c1993a5e2ca718648bd9c17ee22c
 2013-12-24 12:09:42 +00:00
drh
c73d0d9dec Fix harmless compiler warnings in FTS4. This involved corrupting 
Martin Porter's beautifully written and elegant stemmer code, making it
a little less beautiful and a little less elegant.  Today is a sad
day.  But the warnings from GCC grow increasingly verbose and irksome
with each new release and so something had to be done.

FossilOrigin-Name: df05679838b571c16a7ab7e135f9564cd2d9647c
 2013-12-21 16:06:47 +00:00
drh
1b2ee4fe1a Merge in performance enhancements from trunk. 
FossilOrigin-Name: fc9ae839569eb28eb734c52d95676c59b2e27494
 2013-11-26 18:00:29 +00:00
drh
707f1c560a Fix a harmless MSVC compiler warning. 
FossilOrigin-Name: 6cc023bb29be51847fbbfab95c24fc89993ccdba
 2013-11-19 18:17:20 +00:00
drh
2bea7cde6e Fix harmless compiler warnings from clang scan-build. 
FossilOrigin-Name: 8d002740bffca2a76d2dfbc1a67293d34f9de9ba
 2013-11-18 11:20:50 +00:00
drh
212c6be141 Merge the skip-scan optimization into the sessions branch. 
FossilOrigin-Name: 7596d1bf8040f7cefc7b22c5e609acc5d66820bf
 2013-11-14 19:18:39 +00:00
mistachkin
3aa4be39a9 Fix harmless compiler warning. 
FossilOrigin-Name: ddacd10105c6df2d3a9d707947e72c62e88212eb
 2013-11-12 21:10:02 +00:00
dan
85963f5474 When possible, have FTS use 32-bit operations to read varints from the database. 
FossilOrigin-Name: aa7ba302ed13aedde89b5bcbe9119799c0da8a42
 2013-11-12 17:46:44 +00:00
drh
cf1ef10b62 Import recent bug fixes from trunk. 
FossilOrigin-Name: 20eeee4cd34a9bffe6bf65962126ddf8ca04eb3e
 2013-11-12 15:39:01 +00:00
dan
ff4b23ba9e Fix for [4065ac8595]: Do not order CROSS or LEFT joins, even if the right-hand-side is a virtual table. 
FossilOrigin-Name: e2684ece455f53563ae6da7cbb5505d9a4a3076a
 2013-11-12 12:17:16 +00:00
drh
f8396b201c Fix an error message in the spellfix extension so that it conforms to the 
style of error messages in the core.

FossilOrigin-Name: b896ae3d2787c370be3ff5d09da7d631a16d3a2a
 2013-11-12 01:11:56 +00:00