/ Timeline
Login

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

2016-09-07
19:54
Add support for row-value comparisons, including IN operators, and row-value updates in the UPDATE statement. check-in: ddb5f0558c user: drh tags: trunk
19:37
Fix a problem handling expressions like "(a, b) IN (SELECT ... ORDER BY 1, 2)" when there is an index on "a" but not "b". Closed-Leaf check-in: 7f2c5c9ee3 user: dan tags: rowvalue
13:30
Simplify the affinity handling logic in codeAllEqualityTerms(). Logically the same, just a little easier to read and understand. check-in: bbab9621f5 user: drh tags: rowvalue
13:12
Merge fixes from trunk. check-in: 193f036c87 user: drh tags: rowvalue
10:10
Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. check-in: d8451fe84d user: drh tags: trunk
2016-09-06
19:08
Remove obsolete vector-IN test cases. Fix a bad testcase() macro. check-in: ab3f8f193a user: drh tags: rowvalue
18:51
Fix corer cases of vector IN operators where the RHS is a compound SELECT that includes an ORDER BY clause. check-in: 8329ac6f8d user: drh tags: rowvalue
17:21
Remove an unnecessary branch from expr.c. check-in: 7cc9746c54 user: dan tags: rowvalue
17:13
Avoid unnecessary memory allocations for aiMap in codeEqualityTerm(). check-in: 70319c3d76 user: drh tags: rowvalue
16:53
Avoid a NULL pointer deref in codeAllEqualityConstraints() following an OOM. check-in: c6e528c1c0 user: drh tags: rowvalue
16:33
Simplify the fix in commit [7d9bd22c]. check-in: bd5a342008 user: dan tags: rowvalue
15:25
Fix the header comment on codeEqualityTerm(). check-in: b7e710e406 user: drh tags: rowvalue
14:58
Fix a problem handling (a, b) IN (SELECT ...) expressions when there is an index on just one of "a" or "b". check-in: 231c72d9f6 user: dan tags: rowvalue
14:37
Enhance the sqlite3GetTempRange() and sqlite3ReleaseTempRange() internal routines so that they use sqlite3GetTempReg() and sqlite3ReleaseTempReg() when nReg==1. check-in: 4071da2f87 user: drh tags: rowvalue
12:04
Fix a typo in a comment in expr.c. check-in: 288e934f35 user: dan tags: rowvalue
2016-09-05
22:50
Simplified logic to extract a column from a row value. check-in: e8f105c300 user: drh tags: rowvalue
19:57
Fix an assert() so that it does C-compiler does not combine an assert() conditional with a production code conditional and thereby confuse the mutation testing script. check-in: 2fa5288a7e user: drh tags: rowvalue
15:02
Simplifications to the SQLITE_KEEPNULL flag on VDBE comparison operators. check-in: 96269f0179 user: drh tags: rowvalue
12:12
Do vector comparison size checking early - at name resolution time - to forestall future problems. check-in: ae127bcc0a user: drh tags: rowvalue
12:02
Catch vector size mismatch problems during name resolution to avoid later problems. Closed-Leaf check-in: 56562a0346 user: drh tags: early-vector-size-check
09:44
Fix a crash that could occur under certain circumstances if the vectors on either side of a comparison operator were of a different size. check-in: 42670935ab user: dan tags: rowvalue
2016-09-03
19:52
Fix a problem causing the affinity of sub-select row-value elements to be ignored in some contextes. check-in: 7d9bd22c07 user: dan tags: rowvalue
16:24
Merge the fuzzershell enhancement from trunk. check-in: ed20604848 user: drh tags: rowvalue
16:23
Build the generate_series(START,END,STEP) table-valued function into fuzzershell, to make it easier to construct compact test cases that contain actual data. check-in: 672c21bcf0 user: drh tags: trunk
15:31
Consider the affinity of "b" when using an "a IN (SELECT b ...)" expression with an index on "a". Fix for [199df416]. check-in: f5e4985541 user: dan tags: rowvalue
01:46
Performance optimizations. check-in: f1d06c49ba user: drh tags: rowvalue
2016-09-02
23:56
Merge recent changes from trunk. check-in: c7271fbde1 user: drh tags: rowvalue
21:34
Add a test case for the OOM handled by the previous commit. check-in: 9bdf7ca1b3 user: dan tags: trunk
2016-08-27
14:13
Merge updates from trunk. check-in: 082fd5f8ac user: drh tags: rowvalue
14:05
Fix the extra comments (added with -DSQLITE_ENABLE_EXPLAIN_COMMENTS) so that the sense of <, <=, >, and >= tests is correct and so that the SQLITE_STOREP2 version is shown correctly. These changes are already in the rowvalue branch but are added here since they are technically unrelated to rowvalue. check-in: 4d43c4698e user: drh tags: trunk
01:41
Fix the "Synopsis" on the OP_Lt, OP_Le, OP_Gt, and OP_Ge opcodes, which has been backwards for time out of mind. check-in: f51248dcfa user: drh tags: rowvalue
2016-08-26
22:09
Fix a minor problem in sqlite3FindInIndex() related to rowids being used as part of the index. check-in: 829f802be7 user: drh tags: rowvalue
21:15
Fix the sqlite3FindInIndex() to ensure that it always uses a prefix of the index and uses no repeated columns. Enhanced comments. check-in: b9fc89e432 user: drh tags: rowvalue
19:54
Add an EXPLAIN QUERY PLAN line for when a index is used to implement an IN operator. check-in: 171aa833a2 user: drh tags: rowvalue
19:47
Add test cases to rowvalue2.test. check-in: 078bb69e99 user: dan tags: rowvalue
19:31
Enhance sqlite3FindInIndex() so that it is able to make use of the primary keys at the end of an index. check-in: 4b589fbfcc user: drh tags: rowvalue
18:17
Fix a post-OOM crash in updateRangeAffinityStr(). Add several ALWAYS() macros on unreachable branches. check-in: 87d40195ae user: drh tags: rowvalue
17:54
Fix a problem with affinity changes and vector range comparisons. check-in: b34413ac7e user: dan tags: rowvalue
13:19
Allow ROWID values in indexed vector comparisons. check-in: b0cc6be4eb user: drh tags: rowvalue
03:42
Comment improvements. Put ALWAYS and NEVER macros on three unreachable branches. check-in: 397617009e user: drh tags: rowvalue
01:02
Remove an unreachable branch from sqlite3ExprAffinity() check-in: 9d96f61481 user: drh tags: rowvalue
2016-08-25
22:31
Merge recent changes from trunk. check-in: 5789aab8ef user: drh tags: rowvalue
22:06
Fix the sqlite3_trace_v2() interface so that it goes disabled if either the callback or mask arguments are zero, in accordance with the documentation. check-in: 37e6c54b1a user: drh tags: trunk
21:14
Refactor the sqlite3ExprCodeIN() routine for improved maintainability. check-in: b56705ae63 user: drh tags: rowvalue
17:47
Another fix in the IN-operator algorithm description. check-in: f474aeac4f user: drh tags: rowvalue
17:40
Further refinement of the in-operator.md documentation. check-in: df0648373a user: drh tags: rowvalue
15:46
Improvements to IN operator code generator comments. Avoid unnecessary Copy operations on the LHS of the IN operator. check-in: b634429878 user: drh tags: rowvalue
14:23
Corrections to the IN-operator notes. check-in: 25033ee945 user: drh tags: rowvalue
14:00
Add notes on the implementation of the IN operator. check-in: d256b2caeb user: drh tags: rowvalue
2016-08-24
21:54
Simplified VDBE code for the vector NOT IN null-scanning loop. check-in: 7ae504e62e user: drh tags: rowvalue