/ Timeline
Login

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

50 most recent check-ins

2019-10-18
10:05
Get indexes working on virtual columns. Leaf 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]. Leaf 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
15:42
Version number to 3.30.1. check-in: 12e28cc7d9 user: drh tags: branch-3.30
15:17
Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. check-in: ccba7202b6 user: dan tags: trunk
2019-10-09
21:14
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: eb7ed90b8a user: dan tags: trunk
18:36
Do not allow users to effectively disable fts5 crisismerge operations by setting the crisismerge threshold to higher than the maximum allowable segment b-trees on a single level. Fix for [d392017c]. check-in: 86e4972092 user: dan tags: trunk
17:38
Merge recent fixes and enhancements from trunk. Leaf check-in: 553258c2ed user: drh tags: 2-size-lookaside
17:06
An alternative, experimental lookaside memory allocator that uses two different slot sizes. check-in: 5ba8cee8f7 user: sperry tags: 2-size-lookaside
15:37
An improved fix for the dbsqlfuzz-discovered ALWAYS() failure following OOM in sqlite3ExprCollSeq(). This time with a test case (engineered by Dan). check-in: 907f7965b3 user: drh tags: trunk
15:26
Disallow fts5 page sizes greater than 65536 bytes - as there are 16-bit offsets used in the page header. Fix for [81a7f7b9]. check-in: 75775c5ab4 user: dan tags: trunk
15:08
Remove the "fastfuzztest" makefile target. Use only "fuzztest". check-in: e17571c789 user: drh tags: trunk
15:03
New test cases added to test/fuzzdata8.db. check-in: b68d21e93a user: drh tags: trunk
15:00
Change sqlite3SelectDup() to always return NULL if an OOM has occurred. check-in: 01ba4641ab user: drh tags: trunk
13:52
Use the "fuzztest" target in place of "fastfuzztest". Closed-Leaf check-in: 7129e468fd user: drh tags: makefile-cleanup