|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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
|
|
Description
|
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
|
Show » |
|
Bug
Closed
Major
Broken error handling in the case of a conversion error happened during index creation
