- cad63b0 More restrictions on changes to shadow tables when in defensive mode. by drh ยท 6 years ago branch-3.30
- 67eae33 Backport support for the sqlite3_hard_heap_limit64() interface and the by drh ยท 6 years ago
- 6e90771 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]. by drh ยท 6 years ago
- 95d398e Fix a problem with running ALTER TABLE ADD COLUMN statements within a transaction that writes to one or more virtual tables. Fix for [8fe768e9]. by drh ยท 6 years ago
- 1a41ff0 Fix the OP_SeekRowid opcode so that it works correctly with a Real argument by drh ยท 6 years ago
- 2281a15 Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. by drh ยท 6 years ago
- d1c472d Increase the precision of floating point value display in VDBE debugging by drh ยท 6 years ago
- b008e4d Fix some test script issues that come up with SQLITE_OMIT_VIRTUALTABLE builds. by dan ยท 6 years ago
- e2b7a76 Disable sqlite3_drop_module() tests when virtual tables are omitted from by drh ยท 6 years ago
- 905d472 Add missing comment to constant definitions. by drh ยท 6 years ago
- 018dbb1 Improvements to a comment. No code changes. by drh ยท 6 years ago
- e4079e1 Allow compile-time options -DHAVE_GETHOSTUUID=0 and -DHAVE_GETHOSTUUID=1. by drh ยท 6 years ago
- ebc6408 Alternative implementation of the previous check-in which is testable. by drh ยท 6 years ago
- 818a3b5 Fix sqlite3ExprCompare() so that it ignores differences in the Expr.iTable by drh ยท 6 years ago
- 91f34ea Allow DROP TABLE to work on tables name "sqlite_parameters" just as it by drh ยท 6 years ago
- d79cd92 Test for an OOM condition in resolveAlias(). by drh ยท 6 years ago
- a51ddb1 Fix a window-functions problem that could occur if an ORDER BY clause contains an alias for a window-function that is not a top-level expression. by dan ยท 6 years ago
- b19131a Add a missing VdbeCoverage() macro. by drh ยท 6 years ago
- 2829df0 Remove an unused variable. by drh ยท 6 years ago
- e7579a5 Further simplifications to window-function code. by dan ยท 6 years ago
- edf8a7b In the previous check-in, the variable should be openMode, not openFlags. by drh ยท 6 years ago
- 1116b17 In the unix VFS layer, do not attempt to chown() the journal to be the same by drh ยท 6 years ago
- c5b35ae Simplifications to the window-function code. by drh ยท 6 years ago
- 37d296a Bug fixes for window frames of the form (... RANGE BETWEEN b PRECEDING AND a PRECEDING) or (... RANGE a FOLLOWING AND b FOLLOWING) where (a > b). by dan ยท 6 years ago
- 5776ee5 Omit the sqlite3IntTokens array constant for a code simplification. by drh ยท 6 years ago
- 7ca1347 When a scalar subquery has a pre-existing "LIMIT X" then change it to by drh ยท 6 years ago
- b7fc7c8 Fix a harmless unused variable warning in the test logic. by drh ยท 6 years ago
- e39f388 Fix harmless compiler warnings. by drh ยท 6 years ago
- 8c9bcb2 Allow SQLite to omit redundant ORDER BY sorts in the case where a SELECT statement has GROUP BY and ORDER BY clauses that use the same expressions, even when the ORDER BY expressions are marked "DESC". by dan ยท 6 years ago
- af9b58b Simplify the fix in the previous commit. by dan ยท 6 years ago
- ed09ddd Fix a problem with queries containing a min() or max() function for which the FILTER clause excludes all rows. by dan ยท 6 years ago
- 6d2566d Always clear the temporary register cache after coding a subroutine. by drh ยท 6 years ago
- 572b0dd Add extra tests for the handling of corrupt records in fts3. by dan ยท 6 years ago
- aa16c60 Fix another potential "jump depends on uninitialized value" warning. by drh ยท 6 years ago
- 9d70284 Fix an OOB read in the INSTR() function introduced yesterday by check-in by drh ยท 6 years ago
- ec722c1 Do not change the OP_String8 opcode into OP_String until *after* any necessary by drh ยท 6 years ago
- 97b0250 Fix the instr() SQL function so that it makes a copy of its argument by drh ยท 6 years ago
- 7073871 Improved type information display when tracing VDBE execution. by drh ยท 6 years ago
- 91f473b Do not attempt the LIKE optimization for non-text columns and a pattern by drh ยท 6 years ago
- 2ad35d9 Documentation updates for the SQLITE_DIRECTONLY flag. by drh ยท 6 years ago
- b42eb35 Fix a problem with processing CTEs that use a WINDOW clause. by dan ยท 6 years ago
- 8cce6b8 Add the --no-rowids option to the ".recover" command. by dan ยท 6 years ago
- d44c617 Extra comments on fields of the Window object. by drh ยท 6 years ago
- 51a75aa Fix a problem with using json1 window functions with an EXCLUDE clause. by dan ยท 6 years ago
- 01a3b6b Change the meaning of the SQLITE_SUBTYPE flag so that it indicates that the user-defined function cares about the subtypes of its arguments. by dan ยท 6 years ago window-functions-subtype-fix2
- 945a352 Merge latest trunk changes with this branch. by dan ยท 6 years ago
- c204d81 Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit by drh ยท 6 years ago
- fa50834 Ensure the columns of views and sub-queries maintain their implicit collation sequences when the "push-down" optimization is applied. Fix for [18458b1a]. by dan ยท 6 years ago
- e086639 Ensure the columns of views and sub-selects in the FROM clause of a select are always assigned implicit collation sequences, just as table columns are. Possible fix for [a7debbe0]. by dan ยท 6 years ago tkt-a7debbe0_
- e2ba6df Add the SQLITE_SUBTYPE flag, which can be passed to sqlite3_create_function() and similar to indicate to the core that a user function is likely to use sqlite3_result_subtype(). by dan ยท 6 years ago
- 1a97c41 Fix handling of NULL, text and blob values in window queries that use "RANGE BETWEEN A FOLLOWING AND B FOLLOWING", or "B PRECEDING AND A PRECEDING", where A>B. by dan ยท 6 years ago
- c7d12f4 When we play games with COLLATE in order to commute an operator in the by drh ยท 6 years ago
- 4fc8365 Fix a bug introduced earlier today by check-in [88833a9c2849c959]. by drh ยท 6 years ago
- dd668c2 When applying the IN_INDEX_NOOP optimization and the LHS has REAL affinity, by drh ยท 6 years ago
- 0167ef2 Fix an obsolete comment that defines the meaning of one of the parameters by drh ยท 6 years ago
- bffdd63 When computing an expression value for an index-on-expression or a CHECK by drh ยท 6 years ago
- cc80db6 Remove an obsolete paragraph from the OP_Column documentation. No code changes. by drh ยท 6 years ago
- 35a38e0 Fix a harmless compiler warning. by drh ยท 6 years ago
- 81d25cf Mark new VDBE branches never taken. by drh ยท 6 years ago
- 80f6bfc Improvements to the algorithm that determines which SELECT in a sequence by drh ยท 6 years ago
- f66bfcb If a DELETE trigger fired by an UPDATE OR REPLACE statement deletes the row being updated, do not attempt to proceed with the original UPDATE operation. Fix for [d6a0fbc1]. by dan ยท 6 years ago
- 6a19865 Remove some affinity tests that became unreachable due to the prior change. by drh ยท 6 years ago
- 7314495 When the affinity of a table column is INT or REAL, make the affinity of by drh ยท 6 years ago
- a7ce167 Make sure OP_RealAffinity has been applied to all columns of type REAL by drh ยท 6 years ago
- efb5f9a Improvements to VDBE tracing. No changes to code in normal deliverables. by drh ยท 6 years ago
- 9889ede Add test case to window8.test. Also fix an error in a comment in window.c. by dan ยท 6 years ago
- db3a32e Back out the change at [47cd634c98b502d4] which was incorrect. Add a test by drh ยท 6 years ago
- 1cac176 Add further comments to window.c. by dan ยท 6 years ago
- 8b47f52 Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause. by dan ยท 6 years ago
- ae144a1 The expression "(X IS FALSE) IN (FALSE)" does not imply that X is NOT NULL. by drh ยท 6 years ago
- 7a231b4 The expression "(X IS FALSE) BETWEEN FALSE AND TRUE" does not implie that by drh ยท 6 years ago
- 38cefc8 The expression "(x IS FALSE) IS FALSE" does not imply that X is not NULL. by drh ยท 6 years ago
- f4d9c98 Remove a faulty testcase() macro. by drh ยท 6 years ago
- bd717a4 Improve vdbe branch coverage of NULLS LAST code. by dan ยท 6 years ago
- 9d23ea7 Fix other problems similar to ticket [c0390363]. by dan ยท 6 years ago
- db586e4 Add a missing VdbeCoverage() macro. by drh ยท 6 years ago
- f76ccb7 Remove an unreachable branch in the NULLS LAST logic of RANGE window functions. by drh ยท 6 years ago
- b6a9121 Fix another case where SQLite assumes that if "~(? AND FALSE)" is true, "?" must be non-null. by dan ยท 6 years ago
- 1cd382e Avoid assuming that for "~ (? OR TRUE)" to be true, "?" must not be NULL, just as we do for "NOT (? OR TRUE)". Fix for ticket [c0390363]. by dan ยท 6 years ago
- 8085d53 Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. by dan ยท 6 years ago
- e893759 The ALWAYS() added by the previous check-in was incorrect. Take it back out. by drh ยท 6 years ago
- 7ec796d Add ALWAYS() to an always true conditional that results from the by drh ยท 6 years ago
- 790b37a Omit the "x IN (y)" to "x==y" optimization of check-in [e68b427afbc82e20] by drh ยท 6 years ago
- 6397a78 If a TEMP TRIGGER references an auxiliary schema, and that auxiliary schema by drh ยท 6 years ago
- 512e46a Merge in recent fixes from trunk. by drh ยท 6 years ago nulls-last
- d790c9a Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. by dan ยท 6 years ago
- 554a9dc Improved detection of number of column mismatch for vector assignment by drh ยท 6 years ago
- d86fe44 Fix typo in a comment. No code changes. by drh ยท 6 years ago
- e2754c1 Enforce 80-character line discipline in the CLI. Minor improvements to the by drh ยท 6 years ago
- 666a42f Minor performance improvement for balance_nonroot(). by dan ยท 6 years ago
- ee37f8b Fix the built-in edit() SQL function in the CLI so that it works with by drh ยท 6 years ago
- ee6c5e5 Move some things in parse.y so that TK_COLUMN and TK_AGG_COLUMN are assigned the same values as they are on trunk for a very small speedup. by dan ยท 6 years ago
- a31d355 Revise the VDBE comments for NULL-scan so that they also work make by drh ยท 6 years ago
- 5f6a4ea Additional simplifications of the WHERE loop code generator logic for by drh ยท 6 years ago
- 0086e07 Simplification of the WHERE loop code generator for NULLS LAST saves a by drh ยท 6 years ago
- ec3dda5 Invert the meaning of the regBignull flag so that it is 1 when doing the by drh ยท 6 years ago
- 74e1b86 Extra VDBE comments in the NULLS LAST logic provide landmarks to help by drh ยท 6 years ago
- 505ae9d Add additional VDBE coverage marcros. by drh ยท 6 years ago
- a677eec Merge fixes from trunk. Also fix a reference to the KeyInfo.aSortOrder field, by drh ยท 6 years ago
- 0d950af Fix the likely(), unlikely(), and likelihood() functions so that they have by drh ยท 6 years ago