/ Timeline
Login

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

50 descendants of [22ae8a52dd]

2018-10-04
18:17
The 0x8000 optimization flag associated with SQLITE_TESTCTRL_OPTIMIZATIONS causes a large penalty (200) to be added to all sorting costs, which encourages the query planner avoid using the sorter. This flag can be used in experiments to help come up with a more accurate estimate of the true cost of sorting. Leaf check-in: 857a1b01df user: drh tags: query-planner-debug
2018-10-03
18:05
Add an ALWAYS on an unreachable branch in the ALTER TABLE logic. check-in: ebcd452317 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: bf0a6634cd 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: cb1511065d 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: 9280774a4b 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: 3e9f163527 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: defa0515b8 user: drh tags: trunk
21:36
Test case for PRAGMA table_xinfo. Closed-Leaf check-in: 7694b9bc30 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: 2fdd068987 user: drh tags: pragma-table-vinfo
18:28
Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. check-in: cf1b76135f 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: 310b4b65b8 user: dan tags: trunk
17:15
Bring the PRAGMA table_vinfo statement up to date with trunk. check-in: 6f606f9923 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: 8ac2cdda68 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: c52f457e56 user: dan tags: trunk
2018-09-28
23:53
Fix test cases so that they work with ICU. check-in: d04b2013b5 user: drh tags: trunk
21:11
Merge latest begin-concurrent changes into this branch. check-in: 6f3dd9809f user: dan tags: begin-concurrent-pnu
20:58
Merge latest trunk into this branch. check-in: 86750c927c user: dan tags: begin-concurrent
20:46
Have sqlite3changegroup_output_strm() call its output function more regularly. check-in: 8467c31aa0 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: 8a758a8721 user: drh tags: trunk
14:01
Add the geopoly_regular(X,Y,R,N) function to the geopoly extension. check-in: 4505bbae58 user: drh tags: trunk
13:18
Make most geopoly functions pure. check-in: 944e167a98 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: 470c6c07d0 user: drh tags: trunk
2018-09-27
23:57
Small performance optimization in the JSON parser of Geopoly. check-in: fb520e7103 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: dc35f7b175 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: 322ab1fc61 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: 4c1fed60b9 user: dan tags: trunk
17:15
Modify the memstat virtual table so that it works with SQLite version 3.9.2. check-in: 7171d8ae6b user: drh tags: trunk
17:03
Add the sqlite_memstat extension - an eponymous virtual table that shows memory usages statistics for SQLite. check-in: 954ef61f6a 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: 9351135b43 user: drh tags: memstat-vtab
15:45
Add initial ZIPVFS support for the "main" database to the sqlite_memstat virtual table. check-in: 9cd27350b0 user: drh tags: memstat-vtab
15:21
Initial prototype of a eponymous virtual table that accesses sqlite3_status64() and sqlite3_db_status(). check-in: 0b44e1f68e user: drh tags: memstat-vtab
14:24
Minor enhancement to the pager so that it remembers if the underlying database files is immutable. Leaf check-in: 64db614edd user: drh tags: immutable-pager
12:14
Disallow the use of window functions in the recursive part of a recursive CTE. Fix for ticket [e8275b415a2f03bee]. check-in: 7fc2994434 user: dan tags: trunk
00:04
Minor simplification: In OP_ParseSchema, read the p1 register once. check-in: bd250533a0 user: mistachkin tags: trunk
2018-09-26
18:02
Further improvements to the ".help" command in the CLI. check-in: edc3d18ecb 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: 209afb8d06 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: cbaf5b6c1b 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: 4ed9d83a0b user: drh tags: trunk
2018-09-25
13:51
Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. check-in: 42e04fefbc 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: d7c816ae15 user: drh tags: trunk
14:51
Fix a problem with views that use window functions as part of complex expressions. check-in: 507d892c3a 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: 5a38d9281b 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: 903e501894 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: 3dd35f5118 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: 2fd62fccd1 user: drh tags: trunk
2018-09-22
15:05
Enhance WhereLoopBuilder.iPlanLimit to handle a case involving the OR optimization discovered overnight by OSSFuzz. check-in: 7b59930a1d user: drh tags: trunk
2018-09-21
23:41
Fix harmless compiler warning when compiled with SQLITE_OMIT_AUTHORIZATION. check-in: 50f2fa1953 user: mistachkin tags: trunk
19:06
Comment typo fixed. No code changes. check-in: 7e68cdab20 user: drh tags: trunk
18:43
Put a limit counter on the query planner that restricts the number of index+constraint options that can be considered for each table in a join. This prevents certain pathological queries from taking up too much time in the query planner. check-in: 8690b5a0cc user: drh tags: trunk
13:07
Optimization to the OP_MakeRecord opcode makes speed-check.sh run about 1.1 million cycles faster, and results in a slightly smaller library. check-in: d10e636291 user: drh tags: trunk
2018-09-20
20:43
Minor code simplification. check-in: 22ae8a52dd user: drh tags: trunk