/ Timeline
Login

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

50 check-ins occurring around 2fd62fccd13e326d.

2018-09-27
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
19:08
Version 3.25.2 check-in: fb90e7189a user: drh tags: release, version-3.25.2, branch-3.25
13:52
Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. check-in: 32ac001426 user: dan tags: branch-3.25
13:51
Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. check-in: 42e04fefbc user: dan tags: trunk
01:38
Bump the version number to 3.25.2. check-in: 996d74f501 user: drh tags: branch-3.25
01:35
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: e7db5f59ee user: drh tags: branch-3.25
01:17
Fix a problem building on Android with SQLITE_ENABLE_BATCH_ATOMIC_WRITE set. check-in: b9ffa77c92 user: drh tags: branch-3.25
2018-09-24
21:07
Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open() returns. Fix test script problem in lookaside.test. check-in: 3bd94e4317 user: drh tags: branch-3.25
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