Broken error handling in the case of a conversion error happened during index creation [CORE2916] #3300
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.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.5 Alpha 1
affect-version: 2.5 Beta 1
affect-version: 2.5 Beta 2
affect-version: 2.5 RC1
affect-version: 2.5 RC2
affect-version: 3.0 Initial
component: engine
fix-version: 2.1.4
fix-version: 2.5 RC3
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: @dyemanov
Is related to QA276
Test case:
create table tab (col date);
insert into tab (col) values (current_date);
commit;
create index itab on tab computed (cast(col as int));
commit;
-- no error returned, although the cast cannot succeed
select * from tab where cast(col as int) is null;
-- we get a conversion error which means that the record has been found, i.e. the index key is created as NULL
Commits: 13b54a0 dcc66e0 8c3db43
The text was updated successfully, but these errors were encountered: