database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-09-11 08:30:57 +03:00
Code Activity
30,276 Commits 1,582 Branches 184 Tags
create-index-error-retry-fix
Commit Graph

5185 Commits

Author SHA1 Message Date
drh
6c2d94f928 Fix a typo in the header comment of the "series.c" virtual table extension. 
FossilOrigin-Name: d637feb4e3032ee0067c204b56d2af5f7eab228e645f2e77b0b043c2b299724d
 2017-06-02 13:16:54 +00:00
dan
38d6985509 Add test code for LSM to the ext/lsm1/lsm-test directory. 
FossilOrigin-Name: bb7436e84a315baf05f00e6cab396017e3f287ea404d32e0cc4f389fa1194dec
 2017-06-01 16:13:57 +00:00
drh
2c2f392dca Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the 
extra prepFlags argument.  Add the SQLITE_PREPARE_PERSISTENT option as one
bit in that argument.

FossilOrigin-Name: 4a25c5883380fe5990d8180adb58c3bdc7a3d081bc4c69cd4de3cd57074fb251
 2017-06-01 00:54:35 +00:00
drh
3528f6b62b Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports 
the amount of heap memory used for a single prepared statement.

FossilOrigin-Name: b57d510465458dec5b5fc778fd6e8833392964201f9febebf526e60a543da0c2
 2017-05-31 16:21:54 +00:00
drh
6b37e0adc9 Add the experimental "stmts" virtual table for introspection of prepared 
statements.

FossilOrigin-Name: cb4c5c66aba757356da3b8ec3c66a5c8c40e180b3360638ac634f7787404a5b1
 2017-05-31 16:09:04 +00:00
mistachkin
831265f962 Fix harmless compiler warnings in FTS5. 
FossilOrigin-Name: 57a60e959c198b87ed29fab14356f89e0ea7cdb1dd99adbea45b40e8d0cb310a
 2017-05-24 15:32:44 +00:00
drh
92b71757f7 Do not use strcpy() in the (obsolete) amatch extension. 
In releasetest.tcl, run Apple tests using -Os instead of -O1

FossilOrigin-Name: 4440e42031b9cb0edf9a8621cd4f46f209392940ec5b9eefcf8c1e3fef5f7b76
 2017-05-23 19:35:20 +00:00
dan
07d0f15e93 Fix incompatibilities between the "sqldiff --changeset" command and the 
sessions module. Specifically, allow sessions to process changesets containing
tables with zero operations on them and have sqldiff output the expected
output for tables with multi-column primary keys.

FossilOrigin-Name: 0bb23c48064cc64134697469f3f4d2d3610b9e6c7a0dc54a3c47a00bd6c2a860
 2017-05-22 18:09:00 +00:00
dan
22025ef198 Fix some problems in fts5 code detected by -fsanitize=undefined. 
FossilOrigin-Name: 35f721045dfe3f82e016938ab1a668bfc37b6b57b8813cc963ef640ec82de58d
 2017-05-19 12:32:32 +00:00
drh
31976dacf1 Merge changes from trunk. 
FossilOrigin-Name: 6e0f64ab5eafda5d9e61e00c89af3c1ea2c5aa29821da1bdbcab040957b12403
 2017-05-15 17:56:48 +00:00
drh
9715f0e544 Enhance the json_extract() function to reuse parses of the same JSON when 
the function appears multiple times in the same query.

FossilOrigin-Name: 3ba9e7ab79e32090a71c7aa152da9bd5951940ae5e2cf433bceadeb6bfca193f
 2017-05-11 18:42:19 +00:00
dan
6b4fbabd6a Do not save the state of an fts5 merge operation mid-way through an input 
term, even if no previous entry for that term has caused any output. Doing so
may corrupt the FTS index.

FossilOrigin-Name: 9a2de4f05fabf7e725666fb8824ae1adad56834d7ae4f2e118375bb6f9c0ae77
 2017-05-11 18:14:06 +00:00
drh
3fb153cb29 Cache the JSON parse used by json_extract(). 
FossilOrigin-Name: 44ca6c2c4639f3c50ae9233ee299ff0fc4566462c31f28d8676f8de7ffdcd7f0
 2017-05-11 16:49:59 +00:00
drh
f8a2e8c2d2 Fix requirements marks and harmless compiler warnings. 
FossilOrigin-Name: 198ff4c01d86d193a54745764d69376cab8e94747a4daa444690f7e1ec87800b
 2017-05-06 17:12:52 +00:00
drh
bd0f1dbd06 Get sqlite3_expert building on Windows. 
FossilOrigin-Name: d8254047b30f7c1be486bf39d4420678604573b951b5cc83c19ebf74aba0864c
 2017-05-03 12:50:46 +00:00
drh
138bd6df41 In sqlite3expert.c, do not copy the schema for virtual tables. Updates to 
makefiles to make building easier.

FossilOrigin-Name: da15752dccf6090e40ec825db89048eca2b30185882225bf81f1891e914c2e7f
 2017-05-03 12:15:20 +00:00
drh
382bce037c In the sqlite3_expert command-line tool, allow two-dash options. Do not 
accept the database name if it begins with "-".

FossilOrigin-Name: af7d1596044980e0a18baa3ab6674779724dffbf18a152c72e53f11a08999e68
 2017-05-02 20:42:30 +00:00
drh
5034dc673d Merge the latest enhancements from trunk. 
FossilOrigin-Name: a7dcf6a79f7e1c5884baee2909a4bf3174ae06d561dae87b390856e573f81b49
 2017-05-02 19:45:14 +00:00
drh
e780764b4e Fix the fts3EvalAverageDocsize() routine so that it returns errors from 
sqlite3_reset() rather than always returning SQLITE_OK.

FossilOrigin-Name: 430f539cbb3f806fb89191e0b759a5f8b49d9e5b6c95fe9a4b55a1aa0875762a
 2017-05-02 18:00:31 +00:00
dan
6f92c34866 Update this branch with latest trunk changes. 
FossilOrigin-Name: 11f4761c3a84e2cc9df62f117a003af8c57f3d226eec5a40d6241b121e78d002
 2017-05-01 14:25:34 +00:00
dan
b9e6a73866 Replace <fts5.h> with "fts5.h" in test file fts5_test_tok.c. 
FossilOrigin-Name: 63d9ca5c7392e1efe3330689fe750310a952287e843b3242178724e8561fae0e
 2017-04-26 14:34:04 +00:00
dan
f3ac8ba569 Another minor formatting fix. 
FossilOrigin-Name: 9fa2ce3c2b75408594d387684984cd946765776d30bc622a1f4e64d6fe1856d5
 2017-04-21 19:58:35 +00:00
dan
6b0fa916f5 Fix formatting errors in the previous commit. 
FossilOrigin-Name: da9a2e5aa977f7e8e9e4365f7b34bb4f482029a3d44646100773cedc8ea9b959
 2017-04-21 19:56:53 +00:00
dan
5b9dbd1ed0 Update the README.md file in the ext/expert/ directory. 
FossilOrigin-Name: 3b2ff4e0692dfca395d4523b7d5cd0dfd5c319c1072a2a873631fa477cee0b79
 2017-04-21 19:53:39 +00:00
dan
0619838c55 Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a 
database that contains delete-markers to return extra, non-matching, rows.

FossilOrigin-Name: 840042cb2bed2924e2263f21887317f661e5a585c4466c3af25b91ed57a6b49b
 2017-04-21 16:04:18 +00:00
dan
c42a0056d7 Merge latest trunk changes into this branch. 
FossilOrigin-Name: b1533bc455f52f570c0f4b8aaa0da802757dc89b0e45b9a9b31aa591a44bf7bd
 2017-04-20 17:35:46 +00:00
dan
bc3f784cd2 Speed this branch up a bit by filtering before the virtual table layer when 
sampling user data.

FossilOrigin-Name: 8e57c31340dd9ffc457da63c5996fb1b573f8154f864ec2b52c15f399906ac8b
 2017-04-20 16:43:32 +00:00
dan
2ed99def5b Avoid creating a temp table in the user database in the sqlite3_expert code. 
Trouble is, this makes sampling for stat1 data much slower.

FossilOrigin-Name: c62e358243d96cb38a7ce2aa679fc640b62bf46080eab4bd5fc2acf5997d6cd5
 2017-04-20 16:08:33 +00:00
dan
e53b4f9774 Add an option to generate stat1 data based on a subset of the user database 
table contents to sqlite3_expert.

FossilOrigin-Name: c69c3e21db6e141f7e24226c6432f2ed31fe5f177bd23781915871f8600ee56a
 2017-04-20 09:54:04 +00:00
dan
dc62daca86 Further improvements to coverage of fts3 module. 
FossilOrigin-Name: 6b21d0fdebdccfaf63590d9ca9a279c22b8baec07c1a669b9f617f25bd857384
 2017-04-19 13:25:45 +00:00
dan
a059e99ca8 Further modifications and test cases to improve test coverage of fts3. 
FossilOrigin-Name: ea8a0d2ce0cb1ca3f4f18c72fb780d1c26792799acc87e6726f9eaccf2f178bf
 2017-04-19 07:33:52 +00:00
dan
a6ed5a4f39 Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running 
queries through the planner for the second time.

FossilOrigin-Name: a157fcfde5afc27ae38e7cf4669fcc8e60e23d9d301ffe2e541dd69f895b493b
 2017-04-18 20:10:16 +00:00
dan
0027e98b85 Use sqlite3_table_column_metadata() instead of a SELECT statement to check for 
the existence of a %_stat table in fts3. This leads to smaller and easier to
test code.

FossilOrigin-Name: dc2a48020a3c856a8b4cfa2309c290f0508b991e92cc0e4de680d19aae7872fc
 2017-04-18 13:50:00 +00:00
dan
7853002c71 Fix sqlite3_expert handling of triggers on views. 
FossilOrigin-Name: ff4976da667872614331d88e68fb67d347874f164a1c7950dd738c7c2320b954
 2017-04-18 09:04:48 +00:00
dan
bda00fbdb7 Refactor the fts3ColumnMethod() function so that all branches can be covered. 
FossilOrigin-Name: e47fdb493bd76d85f6f05771ee7a0b3ee31b1eb05839a60d2bdb47149ac692d8
 2017-04-18 05:49:23 +00:00
dan
280db65e2c Add support for analyzing trigger programs to the sqlite3_expert code. 
FossilOrigin-Name: 159e8022a9d6701532b8b60e0c41154bc434c1bbdb107c8c97a78fb1140fa745
 2017-04-17 17:03:08 +00:00
dan
624edacf6a Further improvements to test coverage in fts3. 
FossilOrigin-Name: 352413eed469802665e7d2c17b7fe6e3a0b0b2209ce45bdc85fd4243cec50ea6
 2017-04-17 16:07:25 +00:00
dan
ddf4747053 Improve coverage of code in fts3. 
FossilOrigin-Name: 1a08a836fa919524216a16faf5212eebc9ad788c9e15463b68b0576dfccd4387
 2017-04-17 13:38:09 +00:00
drh
b65b3e429a Add the anycollseq.c loadable extension in etc/misc 
FossilOrigin-Name: d7b9813cb17615c3d00afd6994a4309d6d48c8e924b6cd813c543e1fa65c7719
 2017-04-16 22:08:31 +00:00
dan
2abf90096f Fix problems with handling constraints on the rowid column in sqlite3expert.c. 
FossilOrigin-Name: 2e6308798ae2db30564deb35ba3896597448edabbcac6efc4ff084552e42de30
 2017-04-15 16:52:12 +00:00
dan
990b6ceccf Merge latest trunk changes into this branch. 
FossilOrigin-Name: 2d0c458e013cb2d02fbeabed8dabd66f55141aac194611f0e599b3c95af1964f
 2017-04-15 15:47:19 +00:00
dan
79610f5d09 Fix memory leaks in the code on this branch. Make use of the 
sqlite3_index_constraint.usage field. Do not try to handle ORDER BY terms with
explicit COLLATE clauses - they don't get passed to the vtab layer anyway.

FossilOrigin-Name: 0cd75a872c89958a7f418720a0e8c6f638f8284c488f666015c19136feae6be8
 2017-04-15 14:16:04 +00:00
dan
0824ccf29b Modify the code in ext/expert/ to use the vtab interface instead of 
sqlite3_whereinfo_hook(). Remove sqlite3_whereinfo_hook().

FossilOrigin-Name: 3bb6585004090dbf92dd5e9abdf0fd2c921e64b5b3121c4fb7446db764ab59e5
 2017-04-14 19:41:37 +00:00
mistachkin
b1ed717f18 Make USE_FULLWARN=1 the default for MSVC and fix harmless compiler warnings. 
FossilOrigin-Name: 6bf673767b8e5cedef1acff795cbe524fab8db2525c06424db4e038934a33936
 2017-04-14 14:50:34 +00:00
dan
81beb6d115 Update this branch with latest changes from trunk. 
FossilOrigin-Name: 5fcd840cf9b6a5c3ee4ef1e8f92f6c30f96a7899a3d774ee9be8a816916f2c3b
 2017-04-13 16:19:40 +00:00
dan
929b695111 Allow a user column name to be used on the LHS of a MATCH operator in FTS5. 
FossilOrigin-Name: 6f54ffd151b0eca6f9ef57ac54802584a839cfc7373f10c100fc18c855edcc0a
 2017-04-13 09:45:21 +00:00
drh
8671538cad Fix a regression caused by the fix for ticket [6c9b5514077fed34551f98e64c09a1] - 
control characters allowed in JSON.

FossilOrigin-Name: 8e7b611863247a3bf46a96ec4b47d24c0ae0d60c9cee968a1cfd1da157e7c9bb
 2017-04-13 00:12:32 +00:00
dan
03155f659f Update fts5 to support "<colset> : ( <expr> )" for column filtering, as well 
as "<colset> : NEAR(...)" and "<colset> : <phrase>".

FossilOrigin-Name: c847543f8bb1376fef52bca72b4191162a32eb7e6c5f0cd1aa0ab116b3183396
 2017-04-12 17:50:12 +00:00
drh
26849e14c2 Improved \n and \r escapes in the ext/misc/dbdump.c utility function. The 
implementation of dbdump.c now matches the implementation in the CLI.

FossilOrigin-Name: f2643315bb41a71eebd79f5d671f9163187e299a52ff8a481186f1e8fa7e5262
 2017-04-12 17:38:24 +00:00
dan
0e0f5edbb5 Update this branch with latest trunk changes. 
FossilOrigin-Name: 0f66a093935100efd731e14aa63b57360ddd517c1ac97edd1ea9a9de95e1f3cc
 2017-04-11 19:00:30 +00:00