Expression index with TRIM may lead to incorrect indexed lookup [CORE3174] #3548
Labels
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.0.6
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.5.0
affect-version: 3.0 Initial
component: engine
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: @asfernandes
Is related to QA554
Test case:
SQL> create table t (c varchar(10));
SQL> insert into t values ('123');
SQL> insert into t values (' 123');
SQL> select * from t where trim(c) = '123';
C
123
123
SQL> commit;
SQL> create index t_c on t computed by (trim(trailing from c));
SQL>
SQL> select * from t where trim(c) = '123';
C
123
Commits: ac3c00d
The text was updated successfully, but these errors were encountered: