Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around 8487f84af00a8afd.
|
2018-09-24
| ||
| 20:50 | Fix missing space in 'configure.ac' reported on the mailing list. check-in: 4407e15ac9 user: drh tags: branch-3.25 | |
| 20:48 | Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 behavior of ALTER TABLE that does not modify the bodies of triggers or views or the WHERE clause of a partial index. Enable the legacy behavior by default when running the xRename method of virtual tables. check-in: 31dc8b191c user: drh tags: branch-3.25 | |
| 19:41 | 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: 3139af9910 user: drh tags: branch-3.25 | |
| 19:32 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. check-in: 8694c3d565 user: drh tags: branch-3.25 | |
| 19:21 | Fix the "sqlite3" command in the TCL interface so that it correctly returns an error if invoked with no arguments. check-in: 8a82fcf05f user: drh tags: branch-3.25 | |
| 18:29 | Fix a problem with views that use window functions as part of complex expressions. check-in: 1c0ecbbdf1 user: drh tags: branch-3.25 | |
| 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 | |
| 20:15 | Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 behavior of ALTER TABLE that does not modify the bodies of triggers or views or the WHERE clause of a partial index. Enable the legacy behavior by default when running the xRename method of virtual tables. check-in: 7edd26ed27 user: drh tags: trunk | |
| 19:02 | Combine the Expr.pTab and Expr.pWin fields into a union named "y". Add a new EP_WinFunc property that is only true if Expr.y.pWin is a valid pointer. This reduces the size of the Expr object by 8 bytes, reduces the overall amount of code, and shaves over 1 million cycles off of the speed test. check-in: ad130bb86e user: drh tags: trunk | |
| 17:21 | By default, make all "ALTER TABLE RENAME" statements executed within a virtual table xRename() method exhibit the legacy behaviour. Closed-Leaf check-in: 71947337e9 user: dan tags: legacy-alter-table | |
| 08:28 | Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour. check-in: 5acad2e92c user: dan tags: legacy-alter-table | |
|
2018-09-19
| ||
| 20:14 | Reduce the size of Expr to 64-bytes. This works somewhat, but there are test failures. More importantly, the size reduction from 80- to 64-bytes has not lowered the schema memory usage, but it has made the code a little bigger and a little slower. So the initial evidence is that this Expr refactoring experiment is not working... Leaf check-in: 24b0f66ac6 user: drh tags: expr-simplify | |
| 18:17 | A minor code simplification, saved in a branch for future reference. Leaf check-in: 5e458f4a92 user: drh tags: minor-altertab-simplification | |
| 17:24 | Fix an issue in virtual table handling associated with the new Expr.x.pRight field. check-in: 8487f84af0 user: drh tags: expr-simplify | |
| 17:09 | Fix a compilation issue in the "userauth" extension. Also fix a few test script errors that occur with SQLITE_USER_AUTHENTICATION=1 builds. check-in: 221f3f572e user: dan tags: trunk | |
| 16:35 | Make sure Expr.eX changes back to EX_None after Expr.x.pRight is set to NULL due to an OOM. check-in: e4129cd3a0 user: drh tags: expr-simplify | |
| 15:08 | Fix the "sqlite3" command in the TCL interface so that it correctly returns an error if invoked with no arguments. check-in: 2034fa8089 user: drh tags: trunk | |
| 14:54 | Reduce the size of Expr from 80 to 72 bytes moving the pRight field inside the "x" union. This is an incremental check-in that still has issues. check-in: 147c61a6d4 user: drh tags: expr-simplify | |
| 11:59 | Make sure temporary Expr objects are fully initialized prior to sending them into sqlite3ExprCodeTemp(). check-in: de02a1d97a user: drh tags: expr-simplify | |
|
2018-09-18
| ||
| 21:35 | In the Expr object, the Expr.eX field determines what value is stored in the Expr.x union. This mostly works, but there are issues identified by valgrind. check-in: 8849a463d6 user: drh tags: expr-simplify | |
| 20:20 | Version 3.25.1 check-in: 2ac9003de4 user: drh tags: release, version-3.25.1, branch-3.25 | |
| 19:40 | Fix a problem building on Android with SQLITE_ENABLE_BATCH_ATOMIC_WRITE set. check-in: e41e50fe74 user: dan tags: trunk | |
| 18:08 | Merge all recent trunk enhancements. check-in: 655f065404 user: drh tags: expr-simplify | |
| 17:50 | Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open() returns. Fix test script problem in lookaside.test. check-in: e461cb2819 user: dan tags: trunk | |
| 17:00 | Enhance tester.tcl so that when "--malloctrace=1" is specified, the test generates self-contained Tcl scripts that present GUIs instead of *.sql files that require a separate program to interpret. check-in: de2e3cbd08 user: dan tags: trunk | |
| 16:06 | Minor improvements to the permutations.test script. Most notably, a command like "permutations.test alter%" now runs all test scripts with names that match the LIKE pattern "alter%". Or, say, "permutations wal alter%" to run all alter% tests in wal mode. check-in: 3e1a2f6614 user: dan tags: trunk | |
|
2018-09-17
| ||
| 20:47 | Further optimizations to the UPDATE logic to avoid making changes to partial indexes if none of the columns mentioned in the WHERE clause are modified by the UPDATE. check-in: d1365a5bf0 user: drh tags: trunk | |
| 15:25 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. check-in: 36c75fd5b7 user: drh tags: branch-3.25 | |
| 15:19 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. check-in: c6c9585f29 user: drh tags: trunk | |
| 14:18 | Fix a false-positive in the post-ALTER-TABLE schema verification logic that prevents ALTER TABLE from working if the table being altered has a trigger that references any column of a virtual table. Ticket [b41031ea2b537237]. check-in: 5ce568c0e7 user: drh tags: branch-3.25 | |
| 14:13 | Fix a false-positive in the post-ALTER-TABLE schema verification logic that prevents ALTER TABLE from working if the table being altered has a trigger that references any column of a virtual table. Ticket [b41031ea2b537237]. check-in: 84105ea4af user: drh tags: trunk | |
| 13:55 | Restore an assert() that was present on trunk. Closed-Leaf check-in: a7b572ca78 user: drh tags: tkt-b41031ea | |
| 13:38 | Minor modification to the fix on this branch to avoid adding extra conditional compilation macros. check-in: 4d8be404da user: dan tags: tkt-b41031ea | |
| 12:49 | Fix missing space in 'configure.ac' reported on the mailing list. check-in: 96b00a3cd2 user: mistachkin tags: trunk | |
| 11:36 | Increase the version number to 3.25.1. check-in: f3c8cfdb35 user: drh tags: branch-3.25 | |
| 08:27 | Add extra test for the fix on this branch. Also fix a pointer-compare-after-free problem that occurs in similar cases. check-in: 1856ea63b3 user: dan tags: tkt-b41031ea | |
| 00:15 | Add assert()s to the new code in the previous check-in. check-in: b12f23a5c4 user: drh tags: tkt-b41031ea | |
|
2018-09-16
| ||
| 23:27 | First proposed fix for the ALTER TABLE problem described by ticket [b41031ea2b5372378cb3d2d] check-in: 05a9d12925 user: drh tags: tkt-b41031ea | |
| 18:23 | Remove an unreachable branch from the index-on-expression optimization. check-in: 2df2cf4f17 user: drh tags: trunk | |