Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/indexexpr1.test
autosetup
October 11, 2024
D
Experimental change to explain query plan to identify covering indexes on expressions.
dan committed
14101a3
May 4, 2024
D
Functions that pass through the sqlite3_value of one of their arguments must
drh committed
5b9b7cb
May 3, 2024
D
The coalesce(), ifnull(), and iif() functions pass through subtype values
drh committed
0901571
November 8, 2023
D
Do not cover expressions using an indexed expression if the indexed expression
drh committed
2cbe140
April 18, 2023
D
Another fix to the indexed expressions in aggregate queries with GROUP BY
drh committed
f84aeac
February 13, 2023
D
Do not allow WHERE clause terms to match constant string index terms, which
drh committed
b4dc263
November 28, 2022
D
Test cases added derived from the enhancment ticket.
drh committed
cbb9585
April 30, 2022
D
Preserve the COLLATE operator on an index on an expression when resolving
drh committed
2aa1086
October 1, 2021
D
Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.
dan committed
37f3ac8
March 20, 2021
D
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
drh committed
8210233
October 30, 2019
D
Always disallow the use of non-deterministic functions in CHECK constraints,
drh committed
20cee7d
September 26, 2019
D
Minor fix for test file indexexpr1.test.
dan committed
9d30c8f
September 2, 2019
D
When computing an expression value for an index-on-expression or a CHECK
drh committed
bffdd63
August 10, 2019
D
Fix the sqliteExprImpliesExpr() routine so that it recognizes that
drh committed
14c865e
February 1, 2018
D
When an index is based on a text representation of a numeric column in the
drh committed
06b3bd5
January 3, 2018
D
Add another test case (found by OSSFuzz) for the problem fixed in
drh committed
9eb8dba
January 2, 2018
D
In the constraint resolution logic, be careful not to cache column values
drh committed
4d795ef
August 14, 2017
D
Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference
drh committed
4dd89d5
July 21, 2017
M
Remove stray (and incomplete) comment from a test file. No changes to code.
mistachkin committed
07c3a1a
July 20, 2017
D
Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab.
drh committed
6e97f8e
July 19, 2017
D
Allow indexes to be created on date/time functions as long as the 'now'
drh committed
3e34eab
February 11, 2017
D
Ensure that indexed expressions with collating sequences are handled
drh committed
13ac46e
October 10, 2016
D
When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444].
dan committed
90b2fe6
D
Make sure indexes on expressions skip over initial NULL values in the
drh committed
48590fc
December 21, 2015
D
Ensure that the Expr objects that describe indexed expressions are not modified
drh committed
1c75c9d
September 25, 2015
D
Fix PRAGMA integrity_check so that it works with a UNIQUE index over
drh committed
68391ac
September 24, 2015
D
Enhance the query planner so that it is able to use indexed expressions
drh committed
dae26fe
D
Make sure joins work correctly when both sides of the join are connected
drh committed
c5de2d0
D
Correctly handle the case of a WHERE-clause term with indexed expressions on
drh committed
7269443
September 18, 2015
D
Fix a crash that can occur with a skip-scan on an index with
drh committed
e63e8a6
September 5, 2015
D
Omit all use of Expr nodes for TK_AS, as those nodes no longer served a useful
drh committed
0b8d255
August 31, 2015
D
Fix a bug in error reporting when a UNIQUE index on expressions fails its
drh committed
8b57642
D
Case should not be significant when comparing function names.
drh committed
390b88a
D
Make the distinction between truly deterministic functions and date/time
drh committed
1d85e40
D
Improved analysis and usage of indexed expressions in the query planner.
drh committed
4799142