Issue Details (XML | Word | Printable)

Key: CORE-2916
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Broken error handling in the case of a conversion error happened during index creation

Created: 10/Mar/10 10:42 AM   Updated: 03/May/11 11:06 AM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.0.3, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 2.1.3, 3.0 Initial, 2.5 RC1, 2.5 RC2
Fix Version/s: 2.5 RC3, 2.1.4, 3.0 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
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


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 03/May/11 11:06 AM
Q/A test made