/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 most recent check-ins that include changes to files matching 'ext/misc/*'

2019-01-21
14:55
Add the --memtrace option to the CLI. check-in: a1e12fa2 user: drh tags: trunk
2019-01-17
15:47
Sync up with the latest enhancements on trunk. Leaf check-in: 475a179a user: drh tags: apple-osx
2019-01-14
20:44
Add scalar function "prefix_length()" to ext/misc/prefixes.c. check-in: 0bf15505 user: dan tags: trunk
16:16
Add the "prefixes" table-valued function in the ext/misc folder. check-in: f0fd2163 user: drh tags: trunk
2019-01-11
23:08
Use 64-bit APIs in the fileio.c extension. check-in: b49d56a0 user: drh tags: trunk
17:20
Improved detection and reporting of errors in the readfile() extension SQL function. check-in: d2f0b5a4 user: drh tags: trunk
2019-01-08
20:02
Use 64-bit math to compute the sizes of memory allocations in extensions. check-in: ca67f2ec user: drh tags: trunk
2019-01-03
15:22
Fix a harmless compiler warning in the CSV extension. check-in: fbcd7256 user: drh tags: trunk
2019-01-02
19:46
Merge changes from begin-concurrent-wal2. Also modify the unix-excl shm-locks on this branch so that it is not an error to attempt to release an EXCLUSIVE lock that is not held. check-in: 86685679 user: dan tags: begin-concurrent-pnu-wal2
16:08
Merge latest trunk changes into this branch. check-in: 5bf212f1 user: dan tags: begin-concurrent
2018-12-28
21:40
Merge performance enhancements and other patches. Leaf check-in: 44e1b55a user: drh tags: factor-out-scalar-subselect
19:23
Merge patches and enhancements from trunk. check-in: da53f3d3 user: drh tags: reuse-subqueries
2018-12-27
17:11
Merge latest wal2 changes with this branch. check-in: ea96001e user: dan tags: begin-concurrent-wal2
2018-12-26
19:10
Merge latest trunk changes with this branch. check-in: 404f9d99 user: dan tags: wal2
12:50
Fix a problem with the CSV extension when it uses the "header" option on a real file. check-in: 7acaed08 user: drh tags: trunk
2018-12-18
18:01
Merge the wal2 feature into this branch. check-in: a2c618c0 user: dan tags: begin-concurrent-pnu-wal2
2018-12-03
20:49
Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. check-in: b7281a1c user: dan tags: begin-concurrent-wal2
2018-12-01
20:14
Sync this branch with the latest trunk. check-in: 7a44fa5a user: dan tags: wal2
2018-11-26
23:35
Merge recent enhancements from trunk. check-in: e8c20a88 user: drh tags: apple-osx
07:34
Merge latest begin-concurrent changes into this branch. check-in: 76608f75 user: dan tags: begin-concurrent-pnu
07:21
Merge latest trunk changes into this branch. check-in: 28a615a2 user: dan tags: begin-concurrent
2018-11-17
18:45
Merge latest trunk changes into this branch. check-in: 9fdd1868 user: dan tags: reuse-schema1
2018-11-16
20:18
Add SQLITE_CONSTRAINT support to the xBestIndex methods on dbstat, sqlite_dbpage, and zipfile. check-in: 5cd24e55 user: drh tags: trunk
19:19
Update the explain virtual table to make use of SQLITE_CONSTRAINT. check-in: b2d41ff7 user: drh tags: trunk
16:04
Fix the JSON table-valued functions to make use of SQLITE_CONSTRAINT. check-in: 3f34f4f5 user: drh tags: trunk
15:41
Add an assert() to the generate_series virtual table to verify assumptions about the design. check-in: cd13b499 user: drh tags: trunk
15:08
Update the generate_series() table-valued function to make use of the new SQLITE_CONSTRAINT return from xBestIndex. check-in: 4372ad64 user: drh tags: trunk
13:56
Enhance the xBestIndex interface of virtual table so that if the xBestIndex method returns SQLITE_CONSTRAINT then that particular combination of constraints is considered unusable and does not participate further in query planning. check-in: 684013ce user: drh tags: trunk
13:06
Fix comments and make magic numbers into #defines in the fsdir implementation. check-in: c537c9c3 user: drh tags: trunk
08:36
Fix a problem with virtual table "fsdir" and some join queries. check-in: 7fffcee0 user: dan tags: trunk
01:42
Improvements to the CSV virtual table. check-in: 0406ecbb user: drh tags: trunk
2018-11-10
20:07
Merge the read-only shadow table and defensive mode enhancments from trunk. check-in: 977fc44e user: drh tags: apple-osx
18:23
Add support for read-only shadow tables on virtual tables. Added the SQLITE_DEFAULT_DEFENSIVE compile-time option that can put SQLite in defensive mode by default. check-in: 9c685171 user: drh tags: trunk
2018-11-05
23:01
Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. check-in: 31942b3d user: drh tags: read-only-shadow
2018-10-09
22:58
Merge enhancements from trunk. check-in: 1b60e7a9 user: drh tags: apple-osx
22:50
Merge changes for the 3.25.0 release. check-in: ddf6a54e user: drh tags: apple-osx
2018-10-08
20:37
Merge fixes from trunk. check-in: 9c8255a1 user: drh tags: reuse-schema
20:04
Fix an issue with the new memstat.c extension. check-in: ce6e80b1 user: drh tags: trunk
18:58
Merge latest trunk changes into this branch. check-in: 2ac72114 user: dan tags: reuse-schema
2018-10-01
17:15
Bring the PRAGMA table_vinfo statement up to date with trunk. check-in: 6f606f99 user: drh tags: pragma-table-vinfo
2018-09-28
21:11
Merge latest begin-concurrent changes into this branch. check-in: 6f3dd980 user: dan tags: begin-concurrent-pnu
20:58
Merge latest trunk into this branch. check-in: 86750c92 user: dan tags: begin-concurrent
18:51
Fix a bug in the sqlite_memstat virtual table that was causing it to report the amount of memory used as zero bytes. check-in: 8a758a87 user: drh tags: trunk
2018-09-27
17:33
Another minor tweak to memstat.c so that it may be built against older versions of SQLite. check-in: 4c1fed60 user: dan tags: trunk
17:15
Modify the memstat virtual table so that it works with SQLite version 3.9.2. check-in: 7171d8ae user: drh tags: trunk
17:03
Add the sqlite_memstat extension - an eponymous virtual table that shows memory usages statistics for SQLite. check-in: 954ef61f user: drh tags: trunk
16:57
Enhancements to sqlite_memstat: (1) Add an extra "schema" column to show the schema name for ZIPVFS stats. (2) Only show ZIPVFS stats to schema that use ZIPVFS (3) Put a NULL in unused columns of the output. Closed-Leaf check-in: 9351135b user: drh tags: memstat-vtab
15:45
Add initial ZIPVFS support for the "main" database to the sqlite_memstat virtual table. check-in: 9cd27350 user: drh tags: memstat-vtab
15:21
Initial prototype of a eponymous virtual table that accesses sqlite3_status64() and sqlite3_db_status(). check-in: 0b44e1f6 user: drh tags: memstat-vtab
2018-09-26
16:05
Tweak spellfix.c so that if SQLITE_SPELLFIX_5BYTE_MAPPINGS is defined at compile time the Transliteration structure has space for 5 byte (instead of 4 byte) mappings. check-in: cbaf5b6c user: dan tags: trunk
03:43
Fix typos in the header comment for the sha1 and sha3 hash extensions in the ext/misc folder. check-in: 4ed9d83a user: drh tags: trunk
2018-09-18
18:08
Merge all recent trunk enhancements. check-in: 655f0654 user: drh tags: expr-simplify
2018-09-16
16:34
Fix a memory leak in the explain extension. check-in: d0c92b04 user: drh tags: trunk
16:18
Add the new "explain" virtual table in ext/misc. Use this virtual table for additional test cases for the optimization that avoids updating indexes on expressions when none of the columns changed by the UPDATE are in the expression. check-in: 2404304c user: drh tags: trunk
2018-09-12
01:05
Fix some harmless compiler warnings seen with MSVC. check-in: 78862252 user: mistachkin tags: trunk
2018-09-08
16:53
Fix typo in the Win32-specific code for the fileio extension. check-in: e812e5d5 user: mistachkin tags: trunk
2018-09-01
16:13
Merge alter-table-rename-table back into this branch. check-in: ad704a7c user: dan tags: alter-table-rename-column
15:49
Merge fixes and enhancements from trunk. check-in: 589186c0 user: drh tags: alter-table-rename-table
2018-08-30
01:52
Improved JSON parser caching. check-in: 58078c0d user: drh tags: trunk
2018-08-23
14:54
Merge enhancements from trunk. check-in: c446c884 user: drh tags: rtree-geopoly
2018-08-21
12:16
Fix various harmless warnings generated by static analysis tools. check-in: a04a0ea9 user: drh tags: trunk
2018-07-24
13:57
Add missing SQLITE_OMIT_WINDOWFUNC check to the json1 extension. check-in: fe19f823 user: mistachkin tags: trunk
2018-07-10
15:48
Merge begin-concurrent changes into this branch. check-in: af17432e user: dan tags: begin-concurrent-pnu
15:45
Merge latest trunk changes into this branch. check-in: e9a3e864 user: dan tags: begin-concurrent
2018-07-09
22:49
Fixes for various harmless compiler warnings. check-in: 5023b1b8 user: drh tags: trunk
2018-07-07
20:23
Fix the JSON extension so that it can be compiled separately from the amalgamation. check-in: 4b8cfe7b user: drh tags: trunk
19:47
Add ALWAYS() macros on results of sqlite3_aggregate_context() calls in xInverse() implements, since they can never fail. check-in: fdef2a92 user: drh tags: trunk
2018-07-05
20:05
Get the json_group_array() and json_group_object() SQL functions working as window functions. check-in: 916cdc83 user: drh tags: trunk
2018-06-19
21:15
Make the ieee754() a built-in function. Add the --ieee754 option to the ".dump" command in the shell to cause it to output floating-point values as ieee754() calls, so that the floating point number will be reproduced exactly. Not sure yet that we want to go this way, but it is one option. check-in: 7fa8f16e user: drh tags: ieee754
19:15
Merge latest trunk changes with this branch. check-in: 6ad0e64b user: dan tags: exp-window-functions
2018-06-18
19:09
Fix typo in the 'normalize' extension. check-in: 0c9163ea user: mistachkin tags: trunk
2018-06-14
14:30
Merge latest trunk changes into this branch. check-in: 5cf5f180 user: dan tags: exp-window-functions
2018-06-13
17:19
Output infinity as 1e999 in the ".dump" command of the command-line shell. check-in: ee431d55 user: drh tags: trunk
2018-06-06
17:12
Merge the 3.24.0 changes plus a few subsequent enhancements. check-in: be7004a9 user: drh tags: begin-concurrent-pnu
17:03
Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. check-in: d7299bfe user: drh tags: begin-concurrent
2018-06-04
14:10
Merge changes from trunk. check-in: 95fbac39 user: drh tags: apple-osx
13:27
Merge recent changes from trunk. check-in: f8df2a8e user: drh tags: multikey-opt-idea
08:28
Merge latest trunk changes into this branch. check-in: 83d6416a user: dan tags: exp-window-functions
2018-06-02
12:05
Fix the CSV extension so that it works with single-column CSV files. check-in: e336cf00 user: drh tags: trunk
2018-05-16
12:19
Correct output for the fullkey column of json_each() when the total JSON input is a simple value, not an array or object. check-in: b45b1885 user: drh tags: trunk
2018-05-15
11:55
Merge latest trunk changes into this branch. check-in: 72f39efa user: dan tags: begin-concurrent-pnu
11:45
Merge latest trunk changes with this branch. check-in: ae86cf60 user: dan tags: begin-concurrent
2018-05-12
23:59
Add test cases for geopoly_overlap(). (Later:) This branch is closed and the development of the geopoly logic is moved to the rtree-geopoly branch. Closed-Leaf check-in: 39209251 user: drh tags: geojson
23:31
Resolve issues with floating-point round-off error in the geopoly_overlap() routine. check-in: a3c6696f user: drh tags: geojson
21:09
Add the geopoly_svg() SQL function. check-in: 318ba5f0 user: drh tags: geojson
20:28
Preliminary tests show geopoly_overlap() is working. check-in: 77bb7b7d user: drh tags: geojson
16:05
An initial attempt at an overlap function in the geopoly extension. check-in: c857976e user: drh tags: geojson
2018-05-11
16:50
Add the geopoly_within() SQL function. check-in: 927d52a9 user: drh tags: geojson
15:38
Add the geopoly_read() SQL function to the geopoly.c extension. check-in: b37625e8 user: drh tags: geojson
2018-05-09
15:27
The translation in and out of GeoJSON automatically adds or removes the redundant last vertex, as necessary. check-in: 2653bedd user: drh tags: geojson
15:20
Fix the geopoly_json() SQL function so that it works. check-in: 236588d5 user: drh tags: geojson
15:00
Add the geopoly_json() interface. Untested. check-in: 25695c80 user: drh tags: geojson
2018-05-08
22:47
Experiments with routines for processing GeoJSON. check-in: d22fbff2 user: drh tags: geojson
2018-05-04
19:33
Merge recent enhancements from trunk. check-in: e17bca2c user: drh tags: apple-osx
2018-05-02
08:12
Fix a problem in the xBestIndex method of the closure extension causing it to allocate non-contiguous argvIndex values in some cases (an "xBestIndex malfunction" error). check-in: 0c671507 user: dan tags: trunk
2018-04-27
20:49
Better comments on the bindvtab.c implementation. All the two-argument version of the .set command. All bindings from .set and -D are still string. Leaf check-in: 7b2a65a6 user: drh tags: shell-bindings
17:39
Add the ability to use bind parameters in the CLI. The new ".set KEY=VALUE" dot-command works to set bindings. Or use the "-Dkey=value" command-line option. Or use the built-in shell_bindings(k,v) virtual table to set, delete, or changing bindings. check-in: 1f2944d1 user: drh tags: shell-bindings
15:17
Enhance the comments in the templatevtab.c implementation. check-in: 05f6278a user: drh tags: trunk
2018-04-26
18:01
Merge latest changes from trunk. Including the "ORDER BY ... LIMIT" optimization. check-in: 83a4c9f0 user: dan tags: begin-concurrent-pnu
17:54
Merge latest changes from trunk. Including the "ORDER BY ... LIMIT" optimization. check-in: d8ae7ba0 user: dan tags: begin-concurrent