Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/indexexpr1.test
2025-04-10
| ||
10:18 | [d32dba192b] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 23523) | |
2024-10-11
| ||
20:36 | [928671af9d] part of check-in [3bb03a2891] Experimental change to explain query plan to identify covering indexes on expressions. (check-in: [3bb03a2891] user: dan branch: eqp-covering-index-on-expr, size: 23543) | |
2024-05-04
| ||
11:31 | [24fa85a12d] part of check-in [2f9fba931d] Functions that pass through the sqlite3_value of one of their arguments must also be marked as SQLITE_RESULT_SUBTYPE, in case one of their arguments has a subtype. (check-in: [2f9fba931d] user: drh branch: func-rw-subtype, size: 23453) | |
2024-05-03
| ||
19:35 | [870ffcf391] part of check-in [cdd1610c44] The coalesce(), ifnull(), and iif() functions pass through subtype values from their arguments, and hence need to have the SQLITE_RESULT_SUBTYPE flag set. (check-in: [cdd1610c44] user: drh branch: func-rw-subtype, size: 22592) | |
2023-11-08
| ||
18:08 | [833f511213] part of check-in [e908b26a99] Do not cover expressions using an indexed expression if the indexed expression is a function that might set a subtype. (check-in: [e908b26a99] user: drh branch: idx-expr-fix, size: 21616) | |
2023-04-18
| ||
14:13 | [62558b1cfd] part of check-in [5acc3ef83e] Another fix to the indexed expressions in aggregate queries with GROUP BY enhancement of ticket [99378177930f87bd] and implemented by check-in [b9190d3da70c4171] to address a problem described by forum post f34e32d120, (check-in: [5acc3ef83e] user: drh branch: trunk, size: 21141) | |
2023-02-13
| ||
18:42 | [b2a15637dc] part of check-in [2d2b91cc0f] Do not allow WHERE clause terms to match constant string index terms, which can happen if DQS_DDL is enabled. Follow-up to [44200596aa943963]. dbsqlfuzz 54c9db85ed4af7055f5fd0d50877875c82b11d46. (check-in: [2d2b91cc0f] user: drh branch: trunk, size: 20201) | |
2022-11-28
| ||
18:17 | [1cd460113e] part of check-in [c022c0152a] Test cases added derived from the enhancment ticket. (check-in: [c022c0152a] user: drh branch: covering-indexed-expr, size: 19493) | |
2022-04-30
| ||
12:35 | [3360c2a29a] part of check-in [a8da85c57e] Preserve the COLLATE operator on an index on an expression when resolving the use of that expression into a reference to the index. See forum thread 7efabf4b03328e57 for details. (check-in: [a8da85c57e] user: drh branch: trunk, size: 17642) | |
2021-10-01
| ||
20:39 | [8f7241410e] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 17041) | |
2021-03-20
| ||
15:11 | [7e0e7a33ac] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 16935) | |
2019-10-30
| ||
18:50 | [284e119999] part of check-in [2978b65ebe] 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] (check-in: [2978b65ebe] user: drh branch: trunk, size: 16947) | |
2019-09-26
| ||
19:53 | [c26c8b3523] part of check-in [0ceab26f15] Minor fix for test file indexexpr1.test. (check-in: [0ceab26f15] user: dan branch: trunk, size: 16965) | |
2019-09-02
| ||
00:58 | [fb56f0b9a9] part of check-in [0658c16e31] 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]. (check-in: [0658c16e31] user: drh branch: trunk, size: 16900) | |
2019-08-10
| ||
15:06 | [0f293369ed] part of check-in [da01ba4fa4] Fix the sqliteExprImpliesExpr() routine so that it recognizes that "(NULL IS FALSE) IS FALSE" doe not imply "NULL NOT NULL". Ticket [9080b6227fabb466] (check-in: [da01ba4fa4] user: drh branch: trunk, size: 16106) | |
2018-02-01
| ||
01:13 | [635261197b] part of check-in [88e2ce9167] 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]. (check-in: [88e2ce9167] user: drh branch: trunk, size: 15712) | |
2018-01-03
| ||
01:47 | [ace1ad489a] part of check-in [4165fae920] Add another test case (found by OSSFuzz) for the problem fixed in check-in [2846458a] and described by ticket [dc3f932f5a147771]. No changes to code. (check-in: [4165fae920] user: drh branch: trunk, size: 14963) | |
2018-01-02
| ||
18:11 | [60e2d6f1d1] part of check-in [2846458af5] 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. (check-in: [2846458af5] user: drh branch: trunk, size: 14629) | |
2017-08-14
| ||
14:53 | [84100e8801] part of check-in [d0da791ba0] 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]. (check-in: [d0da791ba0] user: drh branch: trunk, size: 14169) | |
2017-07-21
| ||
20:31 | [f348668daf] part of check-in [8de20fc72a] Remove stray (and incomplete) comment from a test file. No changes to code. (check-in: [8de20fc72a] user: mistachkin branch: trunk, size: 13519) | |
2017-07-20
| ||
13:17 | [f06298de30] part of check-in [22eda0985e] 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. (check-in: [22eda0985e] user: drh branch: index-on-date-func, size: 13607) | |
2017-07-19
| ||
19:48 | [1857373a97] part of check-in [0a5e1c04d9] Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. (check-in: [0a5e1c04d9] user: drh branch: index-on-date-func, size: 13567) | |
2017-02-11
| ||
13:51 | [038b3befa7] part of check-in [9689d04b82] Ensure that indexed expressions with collating sequences are handled correctly. Proposed fix for ticket [eb703ba7b50c1a5]. (check-in: [9689d04b82] user: drh branch: trunk, size: 13482) | |
2016-10-10
| ||
14:34 | [7d243fac50] part of check-in [aebe429e52] When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. (check-in: [aebe429e52] user: dan branch: trunk, size: 13047) | |
13:29 | [28a82b3ed1] part of check-in [71797ba431] Make sure indexes on expressions skip over initial NULL values in the index. Fix for ticket [4baa464912129477f3c9] (check-in: [71797ba431] user: drh branch: trunk, size: 12205) | |
2015-12-21
| ||
15:22 | [cb71b65861] part of check-in [34073ce87d] 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. (check-in: [34073ce87d] user: drh branch: trunk, size: 11591) | |
2015-09-25
| ||
20:49 | [bbb52b5d57] part of check-in [113181cec4] Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. (check-in: [113181cec4] user: drh branch: trunk, size: 11073) | |
2015-09-24
| ||
18:47 | [4bce4e4b6b] part of check-in [668fc1ebaf] Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. (check-in: [668fc1ebaf] user: drh branch: trunk, size: 10435) | |
12:19 | [203c83a05a] part of check-in [c2fcb03299] Make sure joins work correctly when both sides of the join are connected using indexed expressions. (check-in: [c2fcb03299] user: drh branch: trunk, size: 9178) | |
11:26 | [b750682e07] part of check-in [d9b716a6bd] Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. (check-in: [d9b716a6bd] user: drh branch: trunk, size: 8756) | |
2015-09-18
| ||
18:09 | [b4dd422f6d] part of check-in [25f34cb9b5] Fix a crash that can occur with a skip-scan on an index with expressions when SQLITE_ENABLE_EXPLAIN_COMMENTS is defined. (check-in: [25f34cb9b5] user: drh branch: trunk, size: 8470) | |
2015-09-05
| ||
22:36 | [4feec154aa] part of check-in [7ab0b258ea] 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. (check-in: [7ab0b258ea] user: drh branch: trunk, size: 8041) | |
2015-08-31
| ||
23:09 | [3c5033412f] part of check-in [5a2c0e90a1] Fix a bug in error reporting when a UNIQUE index on expressions fails its uniqueness test. (check-in: [5a2c0e90a1] user: drh branch: index-expr, size: 7261) | |
18:13 | [d04a390527] part of check-in [e2f1caf117] Case should not be significant when comparing function names. (check-in: [e2f1caf117] user: drh branch: index-expr, size: 6781) | |
17:34 | [1e57b4bb93] part of check-in [c77554b5c4] 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. (check-in: [c77554b5c4] user: drh branch: index-expr, size: 5338) | |
15:58 | Added: [36b7aab1fd] part of check-in [f889369638] Improved analysis and usage of indexed expressions in the query planner. (check-in: [f889369638] user: drh branch: index-expr, size: 1559) | |