/ Timeline
Login

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

50 most recent check-ins

2019-10-21
16:15
Try to fix a harmless compiler warning reported by ICC. Leaf check-in: 7f41b44ca2 user: drh tags: trunk
01:04
Changes to the INSERT logic to make it simpler and faster and so that it works with generated columns and BEFORE triggers. Leaf check-in: bc368cb090 user: drh tags: generated-columns
2019-10-20
08:26
Fix a resource leak in fts5 that could occur if an auxiliary function is called from within a query that does not use the full-text index. check-in: b528bdcd45 user: dan tags: trunk
2019-10-19
18:47
Work toward getting generated columns to work with triggers. Still more work to do in this area. check-in: 932a37275d user: drh tags: generated-columns
15:01
Add testcase macros. check-in: fb9c9bb284 user: drh tags: generated-columns
13:29
Refactor names of column index transformation functions, for clarity. Get generated columns working with ALTER TABLE RENAME COLUMN. check-in: 27ab41c910 user: drh tags: generated-columns
2019-10-18
18:33
Fixes for WITHOUT ROWID tables with VIRTUAL columns and an INTEGER PRIMARY KEY. check-in: 86074da0fd user: drh tags: generated-columns
17:47
Merge trunk enhancements into the generated-columns branch. check-in: 85bc4524d7 user: drh tags: generated-columns
17:42
Get generated columns working for WITHOUT ROWID tables. check-in: 9f409649ec user: drh tags: generated-columns
15:58
Enhance the ".imposter" command in the CLI so that the first argument can be an existing WITHOUT ROWID table instead of an index. The resulting imposter is the same table, but with columns in storage order and with all constraints removed. check-in: 9dc0d34586 user: drh tags: trunk
12:52
Claw back some performance from the sqlite3ExprGetColumnOfTable() routine. check-in: e8426acb94 user: drh tags: generated-columns
12:14
Fix sqlite3ColumnOfIndex() to account for virtual columns. check-in: 447271123e user: drh tags: generated-columns
10:05
Get indexes working on virtual columns. check-in: 450c48766c user: drh tags: generated-columns
02:19
STORED columns can now reference other STORED columns, in any order, as long as there are not loops. check-in: 0d236698e6 user: drh tags: generated-columns
2019-10-17
18:35
In the Table object, change the nVCol field to nNVCol - the number of non-virtual columns, as that is the quantity that we need most. check-in: 4ad66af04a user: drh tags: generated-columns
18:07
Bug fix with INSERT using an explicit column list on a table with a non-final STORED column. check-in: 61b4459ae6 user: drh tags: generated-columns
17:54
Some (but not all) INSERT and UPDATE statements now work for STORED columns. check-in: fe7517bf4d user: drh tags: generated-columns
16:16
Fix the xfer optimization for generated columns, so that VACUUM works again. check-in: 8f67b89b04 user: drh tags: generated-columns
15:59
Basic UPDATE functionality working for VIRTUAL columns. check-in: c21959d4eb user: drh tags: generated-columns
15:41
Avoid an infinite loop in fts3/4 incremental-merge in the case where the lowest level in the database contains segments but no data (because there is a delete-marker for each valid entry). Fix for [bf1aab89]. check-in: 35beaee059 user: dan tags: trunk
14:21
Bug fixes so that "make test" once against runs with no errors. check-in: 7bfe0f679d user: drh tags: generated-columns
13:15
Fix the table_info and table_xinfo pragmas so that they work with virtual columns. Table_info omits virtual columns. Table_xinfo gives them a "hidden" flag of 2, and 3 for STORED columns. check-in: 069351b85f user: drh tags: generated-columns
2019-10-16
22:01
INSERT with named columns for a table with generated columns. check-in: 64db39f92d user: drh tags: generated-columns
20:05
ALTER TABLE is able to add a VIRTUAL column. check-in: 120c6b78cb user: drh tags: generated-columns
19:31
Simple INSERT and SELECT operations working with VIRTUAL columns. check-in: 7f9f90b1b8 user: drh tags: generated-columns
17:46
Enhancements to SQL query normalization for UPDATE statements. check-in: bba975c7af user: mistachkin tags: trunk
14:56
If an AFTER DELETE trigger fires when a conflict row is deleted by REPLACE conflict resolution, make sure the conflict really has been resolved and that the trigger did not recreate the row before continuing. Ticket [a8a4847a2d96f5de] check-in: eea1e7aa57 user: drh tags: trunk
12:18
Initial experimental code for generated column support. Non-functional. check-in: 11d472c1df user: drh tags: generated-columns
2019-10-15
19:01
Formatting change on a multi-line conditional, for improved clarity. No logic changes. check-in: 7248e34765 user: drh tags: trunk
2019-10-14
20:32
Futher improvements to the IN operator for row-values on virtual tables. check-in: bc751fb64d user: drh tags: trunk
15:24
New test cases in test/fuzzdata8.db. check-in: 344d9cb0c7 user: drh tags: trunk
15:15
Fix a problem with row-value IN(...) operators and virtual tables. check-in: aa57d7abac user: dan tags: trunk
2019-10-12
23:38
When Select-Trace is enabled (in debugging builds only) do not show the result of Window function tree rewrites if there are no window functions. check-in: d1acf72ae1 user: drh tags: trunk
2019-10-11
18:55
Update the zipfile extension to use deflateBound(), instead of compressBound(), to learn the maximum possible size of a deflate()d buffer. check-in: f5ee30426e user: dan tags: trunk
17:14
Futher improvements to LEFT JOIN strength reduction. check-in: 8a39167bd2 user: drh tags: trunk
16:01
Improvements to the LEFT JOIN strength reduction optimization. check-in: 548082dfab user: drh tags: trunk
15:33
Ensure fts3/4 prefix indexes are flushed to disk before an 'optimize' command. Fix for [745f1abc]. check-in: 4ed905b188 user: dan tags: trunk
14:27
Fix the fts3/4 integrity-check command so that it works with "ORDER=DESC" tables. Fix for [8a6fa2bb]. check-in: 5863546df9 user: dan tags: trunk
14:25
Increase the version number to 3.31.0 for the next release cycle. check-in: ffd4c30620 user: drh tags: trunk
14:21
Faster response to sqlite3_interrupt() in the OP_IntegrityCk and OP_Count opcodes. check-in: bf875dc599 user: drh tags: trunk
11:21
Merge the 3.30.1 changes into reuse-schema. Leaf check-in: eff7cd7f12 user: drh tags: reuse-schema-3.30
2019-10-10
23:58
Update the autoconf makefile for MSVC. check-in: 9455643eec user: mistachkin tags: trunk
23:58
Fix harmless compiler warning seen with MSVC. check-in: 73a8211473 user: mistachkin tags: trunk
20:19
Version 3.30.1 Leaf check-in: 18db032d05 user: drh tags: release, branch-3.30, version-3.30.1
17:09
Prevent SQLite from assuming that if ((? IS NOT NULL) IS NOT NULL) is true, ? may not be NULL. Fix for [c31034044bb72c89]. check-in: 7833feecfe user: dan tags: trunk
16:41
Fix a problem in the fts3 integrity-check routine causing it to report as corrupt tables that contain values with embedded 0x00 bytes. Ticket [278ac142625e3dcd] check-in: 629e20c988 user: dan tags: trunk
16:21
Avoid assuming that an expression that contains the sub-expression (? IS FALSE) or (? IS TRUE) may only be true if ? is non-null. Fix for [a976c487]. check-in: c6cc2390e9 user: drh tags: branch-3.30
16:10
Fix a problem with running ALTER TABLE ADD COLUMN statements within a transaction that writes to one or more virtual tables. Fix for [8fe768e9]. check-in: a4974a0f95 user: drh tags: branch-3.30
15:57
Fix the OP_SeekRowid opcode so that it works correctly with a Real argument without damaging the value in the register that is the argument. Ticket [b2d4edaffdc156cc]. Test cases in TH3. check-in: b02630fe6e user: drh tags: branch-3.30
15:48
Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. check-in: df2060f34f user: drh tags: branch-3.30