/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

73 descendants and 100 ancestors of [ae88f8e1]

2019-10-11
11:21
Merge the 3.30.1 changes into reuse-schema. Leaf check-in: eff7cd7f user: drh tags: reuse-schema-3.30
2019-10-04
15:31
Bring the reuse-schema branch up-to-date with version 3.30.0. Leaf check-in: 6e09afec user: drh tags: reuse-schema
2019-09-30
16:57
Merge in the 3.30.0 beta 1 changes. check-in: 06796124 user: drh tags: reuse-schema
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. check-in: 27eb2236 user: drh tags: reuse-schema
2019-08-13
15:22
Merge latest trunk changes with this branch. check-in: 5b4689d8 user: dan tags: reuse-schema
2019-08-09
14:54
In shared-schema mode, handle the case where a connection has created a virtual-table object, but is later assigned a different shared-schema object for which the virtual-table schema has not yet been initialized. check-in: e30c7414 user: dan tags: reuse-schema
2019-08-08
15:47
Fix spurious "no such table: x1" errors in shared-schema mode that could occur when a query that is a join across two or more databases needs to call the xConnect() methods of a virtual table. check-in: edf45cd7 user: dan tags: reuse-schema
11:44
Fix a bug causing "no such table" and other similar sqlite3_prepare*() errors to return SQLITE_SCHEMA instead of SQLITE_ERROR in shared-schema mode when there is an attached database for which the schema has never been loaded. check-in: 111e2c73 user: dan tags: reuse-schema
2019-08-06
15:02
Add a multi-threaded test to threadtest3.c for the feature on this branch. check-in: 62557fab user: dan tags: reuse-schema
11:45
Add an assert() to the code on this branch. check-in: fdd44bbb user: dan tags: reuse-schema
2019-07-26
20:54
Merge latest changes from trunk into this branch. check-in: 7f1e4e4b user: dan tags: reuse-schema
2019-07-18
19:50
Add a ctime.c entry for SQLITE_ENABLE_SHARED_SCHEMA. check-in: 892ac945 user: drh tags: reuse-schema
13:33
Modify the bits used for special flags on this branch to account for the fact that some of them are now used for other purposes. check-in: 5a8d0f50 user: dan tags: reuse-schema
2019-07-10
18:45
Merge the version 3.29.0 release enhancements into the reuse-schema branch. check-in: 9819ead0 user: drh tags: reuse-schema
2019-07-08
21:32
Merge recent trunk enhancements into the reuse-schema branch. check-in: fae92fee user: drh tags: reuse-schema
2019-06-03
14:02
Updates to the shared_schema.md notes document. check-in: 51af2ade user: drh tags: reuse-schema
13:46
In the CLI, add ".help" text for the .shared-schema command. check-in: 3ba6f790 user: drh tags: reuse-schema
2019-05-24
13:15
The ".shared-schema" command in the CLI requires the sqlite_dbpage table, so disable it if the build does not include that extension. check-in: 0913ff4d user: drh tags: reuse-schema
13:04
Merge recent enhancements from trunk. check-in: ff9f3e09 user: drh tags: reuse-schema
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. check-in: 018f3199 user: drh tags: reuse-schema
2019-04-15
15:35
Merge recent changes from trunk into reuse-schema check-in: 5c6c9e7f user: drh tags: reuse-schema
2019-03-26
19:14
Remove a "puts" statement accidentally left in a test script. check-in: 9f591ac0 user: dan tags: reuse-schema
18:40
Add a few extra tests for SQLITE_STATUS_SCHEMA_USED with shared-schema databases. check-in: e399fede user: dan tags: reuse-schema
11:57
Merge recent trunk enhancements. check-in: db4e2cc3 user: drh tags: reuse-schema
2019-03-21
17:22
Merge latest trunk changes with this branch. check-in: 3196f5f4 user: dan tags: reuse-schema
17:13
Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. check-in: b8e53608 user: dan tags: reuse-schema
2019-03-20
20:02
Use the IsReuseSchema() macro more consistently. Also, rename it to IsSharedSchema(). check-in: c1be211c user: dan tags: reuse-schema
19:17
Fix an error message. check-in: a70fdaa3 user: dan tags: reuse-schema
16:03
Merge latest trunk changes into this branch. check-in: 4cd20ca6 user: dan tags: reuse-schema
2019-03-04
07:25
Merge latest trunk changes into this branch. check-in: 97a9604d user: dan tags: reuse-schema
2019-02-26
16:36
Update doc/shared_schema.md to describe the shell tool ".shared-schema" dot-command. check-in: 0ce2092a user: dan tags: reuse-schema
16:13
Add new test file reuse5.test. For testing the shell tool ".shared-schema" command. check-in: fa6008d5 user: dan tags: reuse-schema
15:43
Add the ".shared-schema check|fix DB1 DB2..." command to the shell tool. For checking if a database is eligible to share an in-memory with the main database, and for fixing small problems that prevent it from being so. check-in: 7d8e8a95 user: dan tags: reuse-schema
2019-02-25
19:23
Fix a comment in build.c. check-in: d6a9bff6 user: dan tags: reuse-schema
18:07
Merge latest trunk changes into this branch. check-in: 5c1cf308 user: dan tags: reuse-schema
17:54
Where possible, avoid loading all schemas into memory for PRAGMA statements. check-in: 64f97530 user: dan tags: reuse-schema
2019-02-22
17:44
Merge latest trunk changes into this branch. check-in: 001771af user: dan tags: reuse-schema
2019-02-20
18:44
Further test cases and fixes for SQLITE_OPEN_SHARED_SCHEMA. check-in: ba0ab042 user: dan tags: reuse-schema
17:36
Add test and fixes for SQLITE_OPEN_SHARED_SCHEMA mode. check-in: 9a78d89c user: dan tags: reuse-schema
2019-02-19
18:00
Improve error messages caused by corrupt database schemas in OPEN_SHARED_SCHEMA mode. check-in: 8ac75b8a user: dan tags: reuse-schema
2019-02-18
18:16
Ensure that creating temp schema items does not cause an OPEN_SHARABLE_SCHEMA connection to load all schemas into memory. check-in: 88cbf54e user: dan tags: reuse-schema
2019-02-15
19:36
Enhance the virtual table in test_schemapool.c so that it can be used to check that SHARED_SCHEMA connections are not allocating and freeing schemas when they should not be. check-in: cb236cb9 user: dan tags: reuse-schema
19:00
Fix a problem with eponymous virtual tables and SHARED_SCHEMA databases. Also, after preparing statements that require all database schemas (REINDEX, ANALYZE, CREATE, DROP and some PRAGMA statements), do not allow the database connection to return more than one schema to each schema-pool. check-in: ecf6251e user: dan tags: reuse-schema
11:54
Revert the rearrangement of VDBE code in [219b39e14] so that vdbe.c matches trunk. Since the new call to sqlite3Init() in OP_ParseSchema was removed, the rearrangement no longer provides any performance advantage. check-in: 03c4f003 user: dan tags: reuse-schema
2019-02-14
21:04
Fix SQLITE_DBSTATUS_SCHEMA_USED so that it works with SQLITE_OPEN_SHARED_SCHEMA connections. check-in: d43b3c05 user: dan tags: reuse-schema
18:38
Change the name of the SQLITE_OPEN_REUSE_SCHEMA flag to SQLITE_OPEN_SHARED_SCHEMA. check-in: 7257fcc8 user: dan tags: reuse-schema
17:59
Fix a typo in shared_schema.md. check-in: e47a5aea user: dan tags: reuse-schema
17:51
Add documentation file doc/shared_schema.md to describe the change on this branch. check-in: a5f8067d user: dan tags: reuse-schema
15:56
Merge latest trunk into this branch. check-in: 577d1638 user: dan tags: reuse-schema
15:47
Add missing comments and fix other code issues in the new functions in callback.c. check-in: 441cabb6 user: dan tags: reuse-schema
2019-02-13
19:17
Fix for sqlite3_table_column_metadata() on REUSE_SCHEMA databases. check-in: 53220ad7 user: dan tags: reuse-schema
18:29
Avoid crashing after parsing a corrupt schema with a REUSE_SCHEMA connection. check-in: b102148e user: dan tags: reuse-schema
15:51
Fix a problem with the incrblob API and reusable schemas. check-in: 34f0f96f user: dan tags: reuse-schema
14:06
Rearrange the code in the VDBE to help out the C-compiler optimizer. And fix a harmless compiler warning. check-in: 219b39e1 user: drh tags: reuse-schema
13:48
Performance optimization in the VDBE, and a fix for a harmless compiler warning. Closed-Leaf check-in: e002666a user: drh tags: reuse-schema-vdbe-opt
08:40
Fix a problem with OPEN_REUSE_SCHEMA connections reloading the temp schema. check-in: 7c2ec2d4 user: dan tags: reuse-schema
2019-02-12
20:58
Add tests for creating temp schema objects with SQLITE_OPEN_REUSE_SCHEMA connections. check-in: 8c07b609 user: dan tags: reuse-schema
19:20
Share schemas between databases attached to the same database handle. check-in: ea611d7c user: dan tags: reuse-schema
2019-02-11
20:13
Merge latest trunk changes into this branch. check-in: dbedd81b user: dan tags: reuse-schema
19:34
Add eponymous virtual table "schemapool". For inspecting the current contents of the schema-pool. check-in: 2ebeb747 user: dan tags: reuse-schema
2019-02-09
17:47
Fix virtual table support for SQLITE_OPEN_REUSABLE_SCHEMA connections. check-in: 3ca8856a user: dan tags: reuse-schema
2019-02-08
19:30
Add test cases and fix problems on this branch. check-in: 2b2e9f81 user: dan tags: reuse-schema
2019-02-05
19:51
Merge latest trunk into this branch. check-in: c089cc4f user: dan tags: reuse-schema
19:15
Fix memory leaks on this branch. check-in: e9c5e189 user: dan tags: reuse-schema
2019-02-04
21:02
Fix a problem with reloading the schema on this branch. check-in: 5dfbef83 user: dan tags: reuse-schema
2019-02-02
21:02
Try new approach ensuring that each Schema object is only used by one connection/database at any one time. check-in: 9e8e5f52 user: dan tags: reuse-schema
2018-11-20
16:02
Consolidate the two sqlite3SchemaToIndex() routines. Leaf check-in: dfab7170 user: dan tags: reuse-schema1
2018-11-19
20:41
Fix a problem with virtual tables in shared schemas. check-in: 84be9220 user: dan tags: reuse-schema1
2018-11-17
19:15
Fix another name resolution problem occurring when two or more attached databases use the same Schema object. check-in: 5328f899 user: dan tags: reuse-schema1
18:45
Merge latest trunk changes into this branch. check-in: 9fdd1868 user: dan tags: reuse-schema1
18:11
Fix further problems with the feature on this branch. check-in: 6d7a7e5f user: dan tags: reuse-schema1
2018-11-16
17:04
Fix further REUSE_SCHEMA issues. check-in: 9780829a user: dan tags: reuse-schema1
2018-11-15
21:20
Fix some problems with the feature on this branch. Many problems remain. check-in: 31b6aee7 user: dan tags: reuse-schema1
2018-11-09
18:44
Merge latest trunk changes with this branch. check-in: ae88f8e1 user: dan tags: reuse-schema
14:17
Fix for ticket [787fa716be3a7f650cac] check-in: 531eca61 user: drh tags: trunk
2018-11-08
22:53
In the treeview.c module, break out the display of SrcList into a separate subroutine, so that it can be invoked while debugging. check-in: 8c74065f user: drh tags: trunk
2018-11-07
14:39
Fix a problem with the handling of SQLITE_FCNTL_PRAGMA in the test_onefile.c demo. check-in: 13e21b7d user: dan tags: trunk
11:56
Partially revert [3e1a2f661], as some test scripts require separate $presql and $dbconfig variables. check-in: cbf85284 user: dan tags: trunk
2018-11-05
19:37
Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: 11d98414 user: drh tags: trunk
16:38
Eponymous virtual tables appear to exist in all schemas. This is an alternative and improved fix to the eponymous virtual table in trigger problem that was previously addressed by checkin [1fa74930ab56171e]. check-in: b8d35c4a user: drh tags: trunk
07:53
Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. check-in: af39661e user: drh tags: trunk
2018-11-03
17:31
Correct the internal logic for SQLITE_DBCONFIG_DEFENSIVE. Closed-Leaf check-in: 76094345 user: drh tags: dbconfig-defensive
16:51
Add extra defenses against strategically corrupt databases to fts3/4. check-in: d44318f5 user: dan tags: trunk
16:09
Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: af3f29d4 user: drh tags: dbconfig-defensive
13:11
Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. check-in: dcb8c735 user: drh tags: trunk
2018-11-02
17:38
Enhance triggers so that they can use table-valued-functions that exist in schemas outside of the schema in which the trigger is defined. check-in: 1fa74930 user: drh tags: trunk
2018-10-31
20:52
Deploy the sqlite3Strlen30NN() function (argument guaranteed to be non-NULL) for a small performance improvement. check-in: 4a6ad519 user: drh tags: trunk
19:01
Add support for the SQLITE_PREPARE_NORMALIZED flag and the sqlite3_normalized_sql() when compiling with SQLITE_ENABLE_NORMALIZE. Also remove unnecessary whitespace from Makefiles. check-in: 790ea39a user: drh tags: trunk
18:24
Tweaks to the test_intarray documentation and tests. check-in: 7107f0da user: drh tags: trunk
01:12
Merge fuzz test cases computed by dbfuzz2. check-in: e0d30c18 user: drh tags: trunk
01:04
Improved corrupt database detection in the relocatePage() routine of the b-tree module. check-in: d5787333 user: drh tags: trunk
2018-10-30
23:45
Add new fuzzer cases generated by dbfuzz2. Closed-Leaf check-in: 79fdad8b user: drh tags: dbfuzz2-cases
19:14
Update comments in sqlite3session.c to describe the format of "rebase blobs", as well as changesets and patchsets. check-in: bf93f7b5 user: dan tags: trunk
16:25
Split the SQLITE_WriteSchema flag in two flags, WriteSchema and SQLITE_NoSchemaError. Set only WriteSchema on a VACUUM to avoid problems when trying to vacuum a corrupt database. With this change, the size of the flags field on sqlite3 must grow from 32 to 64 bytes. check-in: 4f987810 user: drh tags: trunk
15:31
Modify the CLI so that the --deserialize option is only available if it is compiled with SQLITE_ENABLE_DESERIALIZE. DESERIALIZE is now off by default for the main.mk makefile, but on for Makefile.in and Makefile.msc. check-in: 90b2a684 user: drh tags: trunk
15:20
Improvements to the -fsanitize=fuzzer based database file fuzzer. (Cherrypick from the rubust-against-damaged-db branch.) check-in: 3cc01a0e user: drh tags: trunk
14:36
In the CLI, when opening a file that begins with the normal SQLite prefix, open the file as a normal database even if it has a ZIP for AppendVFS record at the end. check-in: 7989bbda user: drh tags: trunk
13:19
Enable sqlite3_deserialize() in the CLI. The --deserialize option associated with opening a new database cause the database file to be read into memory and accessed using the sqlite3_deserialize() API. This simplifies running tests on a database without risk of modifying the file on disk. check-in: 5e0129ee user: drh tags: trunk
2018-10-29
21:01
Fix a potential assertion fault that can occur while trying to DROP a table from a corrupted database file. check-in: 147a9429 user: drh tags: trunk
18:33
Fix minor memory leak in the dbstat extension that can occur following an attempt to analyze a corrupt database file. check-in: cb874fd8 user: drh tags: trunk
17:53
Add the sqlite3_normalized_sql() API. Closed-Leaf check-in: 592b66e8 user: mistachkin tags: normalized_sql
17:08
In the sessions module, avoid collecting rebase data if the user has not requested it. check-in: de72a773 user: dan tags: trunk
16:07
Harden the dbstat extension against corrupt database files. check-in: a0d47f25 user: drh tags: trunk
2018-10-27
21:06
Improvements to the dbfuzz2.c test module. check-in: d60eff49 user: drh tags: trunk
16:02
Add an entry in Makefile.in to build dbfuzz2 using clang-6.0 with -fsanitize=fuzzer,undefined. check-in: a4a083ed user: drh tags: trunk
00:47
Initial code for a fuzzing tool on database file that works with the -fsanitize=fuzzer option of clang. check-in: 90d12094 user: drh tags: trunk
2018-10-26
17:05
Add the sqlite3session_config() interface. For configuring global parameters belonging to the sessions module. check-in: 1e69f3ff user: dan tags: trunk
15:36
Prevent an == constraint specified using the table-valued-function argument syntax from being used to optimize any scan not related to the virtual table for which it was specified as an argument. check-in: 4d46685f user: dan tags: trunk
2018-10-25
14:15
In the WHERE-constraint propagation optimization, if there are duplicate constraint, make sure only one of them propagates. Proposed fix for ticket [cf5ed20fc8621b165]. check-in: 5d5b596f user: drh tags: trunk
2018-10-24
23:55
Add the ENABLE_GEOPOLY case to the compile_options pragma. check-in: de940296 user: drh tags: trunk
2018-10-23
13:48
Fix a problem with using window functions in compound (UNION, INTERSECT etc.) queries. check-in: 059ff53a user: dan tags: trunk
2018-10-20
13:48
Add the sqlite3changeset_start_v2() - a new version of _start() that accepts a flags parameter - and a streaming equivalent to the sessions module. Also add the SQLITE_CHANGESETSTART_INVERT flag, used with start_v2() to invert a changeset while iterating through it. check-in: cbedcb9a user: dan tags: trunk
2018-10-18
15:17
Take steps to avoid a potential integer overflow in sessionBufferGrow(). check-in: f7affa2e user: dan tags: trunk
14:59
Add the SQLITE_CHANGESETAPPLY_INVERT flag to sessions. For inverting and applying a changeset in a single step. check-in: d4b6406e user: dan tags: trunk
2018-10-12
15:01
Test case modifications to support SEE. check-in: 02b6f8f2 user: drh tags: trunk
2018-10-11
18:41
Add the textkey and textrekey pragmas. check-in: f03164d4 user: drh tags: trunk
16:53
Fix harmless compiler warnings in the CLI. check-in: 1916d291 user: drh tags: trunk
16:38
Always reset the pager before changing the codec. check-in: 0bf0fd24 user: drh tags: trunk
13:51
On the first connection to a WAL-mode database that was not cleanly shut down and contains a left-over -shm file, truncate the -shm file to 3 bytes instead of to 0 bytes. Avoiding a truncation to 0 means that system monitoring tools can better detect if a process illegitimately tries to truncate a -shm file. Such a rogue process might think it is being helpful by cleaning up old files, but there is a race condition that can cause damage to the database. check-in: 90cf32cd user: drh tags: trunk
10:37
In the CLI, fix a file descriptor leak following OOM and a missing va_end() call. check-in: ec36d15a user: drh tags: trunk
02:39
In the unix VFS, fix the heap shm allocator (used for unix-excl) so that it works even on systems where the page size is larger than 32KB. check-in: 7fbb083c user: drh tags: trunk
2018-10-10
18:56
In the CLI, allow the SQLITE_HISTORY environment variable, if it exists, to specify an alternative file in which to store the shell edit history. check-in: 696e82f7 user: drh tags: trunk
2018-10-08
23:29
Add the ability to open a database connection in -reuseschema mode in the CLI. Adjust memory allocation accounting so that a shared schema is allocated across each database sharing it. check-in: 3869b210 user: drh tags: reuse-schema
20:57
Fix a problem with using virtual tables via reuse-schema connections. check-in: e5897daf user: dan tags: reuse-schema
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
18:55
Replace the new geopoly_reverse() function with geopoly_ccw(). The geopoly_ccw() function only reverses the vertex order if doing so is necessary to get the correct right-hand winding rule on the polygon. check-in: 07506694 user: drh tags: trunk
12:58
Add the geopoly_reverse() function to the GeoPoly extension. check-in: 690dd18a user: drh tags: trunk
2018-10-06
14:38
Fix the ".help -all" option in the command-line shell. check-in: aac8f1df user: drh tags: trunk
13:46
Add test cases and assert() statements to ensure that the authorizer is being called as expected from within ALTER TABLE. check-in: ff10d2c7 user: dan tags: trunk
2018-10-05
15:10
Changes to geopoly to silience false-positive warnings coming out of clang. check-in: 11d9015f user: drh tags: trunk
2018-10-03
18:05
Add an ALWAYS on an unreachable branch in the ALTER TABLE logic. check-in: ebcd4523 user: drh tags: trunk
11:13
Change a type in shell.c.in from "int" to "sqlite3_int64" in order to avoid a compiler warning and possible integer overflow. check-in: bf0a6634 user: dan tags: trunk
2018-10-02
20:16
Add an additional assert() verifying mutex invariants on the unixShmSystemLock() routine in the unix VFS. check-in: cb151106 user: drh tags: trunk
19:58
Additional field name changes and commit fixes associated with shared-memory locking in the unix VFS, to improve maintainability. No logic changes. check-in: 9280774a user: drh tags: trunk
19:36
Fix comments and refactor some names associated with shared-memory locking in the Unix VFS. No logical changes. check-in: 3e9f1635 user: drh tags: trunk
2018-10-01
21:41
Add the "PRAGMA table_xinfo" command that works like table_info but also shows hidden columns in virtual tables and adds the "hidden" boolean column. check-in: defa0515 user: drh tags: trunk
21:36
Test case for PRAGMA table_xinfo. Closed-Leaf check-in: 7694b9bc user: drh tags: pragma-table-vinfo
21:26
Change the name of the pragma to PRAGMA table_xinfo. Improve the mkpragmatab.tcl script to reuse column names where appropriate. check-in: 2fdd0689 user: drh tags: pragma-table-vinfo
18:28
Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. check-in: cf1b7613 user: drh tags: pragma-table-vinfo
17:33
Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. check-in: 310b4b65 user: dan tags: trunk
17:15
Bring the PRAGMA table_vinfo statement up to date with trunk. check-in: 6f606f99 user: drh tags: pragma-table-vinfo
13:54
Fix a potential crash that can occur while reading an index from a corrupt database file. The corruption is a record-header-size that is larger than 0x7fffffff. Problem detected by OSSFuzz against GDAL and reported to us (with a suggested fix) by Even Rouault. The test case is in TH3. check-in: 8ac2cdda user: drh tags: trunk
07:04
Fix a problem with ALTER TABLE commands when the schema features an INSTEAD of trigger that uses NEW.* or OLD.*. check-in: c52f457e user: dan tags: trunk
2018-09-29
19:38
Add the PRAGMA table_vinfo command (with an extra "v" before "info") that works like PRAGMA table_info (without the "v") except that it also shows hidden columns on virtual tables. check-in: 8bcd1a59 user: drh tags: pragma-table-vinfo
2018-09-28
23:53
Fix test cases so that they work with ICU. check-in: d04b2013 user: drh tags: trunk
20:46
Have sqlite3changegroup_output_strm() call its output function more regularly. check-in: 8467c31a user: dan tags: trunk
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
14:01
Add the geopoly_regular(X,Y,R,N) function to the geopoly extension. check-in: 4505bbae user: drh tags: trunk
13:18
Make most geopoly functions pure. check-in: 944e167a user: drh tags: trunk
00:16
Rig geopoly to use sqlite3AtoF() if it is available, as that routine is much faster than atof(). check-in: 470c6c07 user: drh tags: trunk
2018-09-27
23:57
Small performance optimization in the JSON parser of Geopoly. check-in: fb520e71 user: drh tags: trunk
20:37
Enhance the GeoPOLY extension so that it always stores its polygons in the binary format, which is faster and more compact. check-in: dc35f7b1 user: drh tags: trunk
20:20
Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless the OPFLAG_NOCHNG bit is set in P5. Fix for ticket [69d642332d25aa3b7315a6d385] check-in: 322ab1fc user: drh tags: trunk
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
12:14
Disallow the use of window functions in the recursive part of a recursive CTE. Fix for ticket [e8275b415a2f03bee]. check-in: 7fc29944 user: dan tags: trunk
00:04
Minor simplification: In OP_ParseSchema, read the p1 register once. check-in: bd250533 user: mistachkin tags: trunk
2018-09-26
18:02
Further improvements to the ".help" command in the CLI. check-in: edc3d18e user: drh tags: trunk
16:53
Begin revamping the ".help" command in the command-line shell so that it can accept an argument and will do a search for commands that match that argument. check-in: 209afb8d user: drh tags: trunk
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-25
13:51
Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. check-in: 42e04fef user: dan tags: trunk
2018-09-24
15:39
Slightly smaller and faster alternative to [507d892c3a40a0bacbd47] that fixes a problem with views that use window function as part of complex expressions. check-in: d7c816ae user: drh tags: trunk
14:51
Fix a problem with views that use window functions as part of complex expressions. check-in: 507d892c user: dan tags: trunk
14:10
Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. check-in: 5a38d928 user: drh tags: trunk
12:37
Use compile-time options SQLITE_QUERY_PLANNER_LIMIT and SQLITE_QUERY_PLANNER_LIMIT_INCR to control the value for WhereLoopBuilder.iPlanLimit, rather than embedding magic numbers in the code. check-in: 903e5018 user: drh tags: trunk
10:47
Increase the initial value of WhereLoopBuilder.iPlanLimit to 20K. Issue a warning if the iPlanLimit reaches zero. check-in: 3dd35f51 user: drh tags: trunk
2018-09-23
02:01
Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. check-in: 2fd62fcc user: drh tags: trunk