Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/indexexpr1.test
|
2019-10-30
| ||
| 18:50 | Always disallow the use of non-deterministic functions in CHECK constraints, even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] file: [284e1199] check-in: [2978b65e] user: drh branch: trunk, size: 16947 | |
|
2019-09-26
| ||
| 19:53 | Minor fix for test file indexexpr1.test. file: [c26c8b35] check-in: [0ceab26f] user: dan branch: trunk, size: 16965 | |
|
2019-09-02
| ||
| 00:58 | When computing an expression value for an index-on-expression or a CHECK constraint and the expressions uses a REAL table column, but the value of that column is an integer (in other words, when it is using the store-real-as-integer optimization) be sure to promote the value to real before evaluating the expression. Ticket [57af00b6642ecd68]. file: [fb56f0b9] check-in: [0658c16e] user: drh branch: trunk, size: 16900 | |
|
2019-08-10
| ||
| 15:06 | Fix the sqliteExprImpliesExpr() routine so that it recognizes that "(NULL IS FALSE) IS FALSE" doe not imply "NULL NOT NULL". Ticket [9080b6227fabb466] file: [0f293369] check-in: [da01ba4f] user: drh branch: trunk, size: 16106 | |
|
2018-02-01
| ||
| 01:13 | When an index is based on a text representation of a numeric column in the original table, make sure the indexed value uses the canonical text representation of the numeric value in the table. Proposed fix for ticket [343634942dd54ab57b70]. file: [63526119] check-in: [88e2ce91] user: drh branch: trunk, size: 15712 | |
|
2018-01-03
| ||
| 01:47 | Add another test case (found by OSSFuzz) for the problem fixed in check-in [2846458a] and described by ticket [dc3f932f5a147771]. No changes to code. file: [ace1ad48] check-in: [4165fae9] user: drh branch: trunk, size: 14963 | |
|
2018-01-02
| ||
| 18:11 | In the constraint resolution logic, be careful not to cache column values in registers whose initialization might be bypassed by an OP_NoConflict opcode. Fix for ticket [dc3f932f5a147771] reported by OSSFuzz. file: [60e2d6f1] check-in: [2846458a] user: drh branch: trunk, size: 14629 | |
|
2017-08-14
| ||
| 14:53 | Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference to an expression column in an index on an expression. Fix for ticket [aa98619ad08ddcab]. file: [84100e88] check-in: [d0da791b] user: drh branch: trunk, size: 14169 | |
|
2017-07-21
| ||
| 20:31 | Remove stray (and incomplete) comment from a test file. No changes to code. file: [f348668d] check-in: [8de20fc7] user: mistachkin branch: trunk, size: 13519 | |
|
2017-07-20
| ||
| 13:17 | Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints. file: [f06298de] check-in: [22eda098] user: drh branch: index-on-date-func, size: 13607 | |
|
2017-07-19
| ||
| 19:48 | Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. file: [1857373a] check-in: [0a5e1c04] user: drh branch: index-on-date-func, size: 13567 | |
|
2017-02-11
| ||
| 13:51 | Ensure that indexed expressions with collating sequences are handled correctly. Proposed fix for ticket [eb703ba7b50c1a5]. file: [038b3bef] check-in: [9689d04b] user: drh branch: trunk, size: 13482 | |
|
2016-10-10
| ||
| 14:34 | When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. file: [7d243fac] check-in: [aebe429e] user: dan branch: trunk, size: 13047 | |
| 13:29 | Make sure indexes on expressions skip over initial NULL values in the index. Fix for ticket [4baa464912129477f3c9] file: [28a82b3e] check-in: [71797ba4] user: drh branch: trunk, size: 12205 | |
|
2015-12-21
| ||
| 15:22 | Ensure that the Expr objects that describe indexed expressions are not modified by code generation. Fix for an assert() problem found by Jon Metzman using AFL. file: [cb71b658] check-in: [34073ce8] user: drh branch: trunk, size: 11591 | |
|
2015-09-25
| ||
| 20:49 | Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. file: [bbb52b5d] check-in: [113181ce] user: drh branch: trunk, size: 11073 | |
|
2015-09-24
| ||
| 18:47 | Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. file: [4bce4e4b] check-in: [668fc1eb] user: drh branch: trunk, size: 10435 | |
| 12:19 | Make sure joins work correctly when both sides of the join are connected using indexed expressions. file: [203c83a0] check-in: [c2fcb032] user: drh branch: trunk, size: 9178 | |
| 11:26 | Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. file: [b750682e] check-in: [d9b716a6] user: drh branch: trunk, size: 8756 | |
|
2015-09-18
| ||
| 18:09 | Fix a crash that can occur with a skip-scan on an index with expressions when SQLITE_ENABLE_EXPLAIN_COMMENTS is defined. file: [b4dd422f] check-in: [25f34cb9] user: drh branch: trunk, size: 8470 | |
|
2015-09-05
| ||
| 22:36 | Omit all use of Expr nodes for TK_AS, as those nodes no longer served a useful purpose and in fact interferred with the query planner. file: [4feec154] check-in: [7ab0b258] user: drh branch: trunk, size: 8041 | |
|
2015-08-31
| ||
| 23:09 | Fix a bug in error reporting when a UNIQUE index on expressions fails its uniqueness test. file: [3c503341] check-in: [5a2c0e90] user: drh branch: index-expr, size: 7261 | |
| 18:13 | Case should not be significant when comparing function names. file: [d04a3905] check-in: [e2f1caf1] user: drh branch: index-expr, size: 6781 | |
| 17:34 | Make the distinction between truly deterministic functions and date/time functions which only return the same answer for a single query. Only truly deterministic functions are allowed in indexes. Add new expression index test cases. file: [1e57b4bb] check-in: [c77554b5] user: drh branch: index-expr, size: 5338 | |
| 15:58 | Improved analysis and usage of indexed expressions in the query planner. file: [36b7aab1] check-in: [f8893696] user: drh branch: index-expr, size: 1559 Added | |