Issue Details (XML | Word | Printable)

Key: CORE-2977
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Alexander Volok
Votes: 0
Watchers: 1
Operations

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

FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)

Created: 23/Apr/10 04:55 PM   Updated: 04/Feb/11 12:03 PM
Component/s: Engine
Affects Version/s: 2.1.3
Fix Version/s: 2.5 RC3, 2.1.4

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

Environment:
GDB with ODS 9.1 (from IB 5.6 when ported to FB 1.5, when ported to FB 2.1.3 but without a backup-rectore procedure for some case). Application using IBX for Dbaccess, but it doesn't matter.
I may send a sample database by request.

Planning Status: Unspecified

Sub-Tasks  All   Open   

 Description  « Hide
execution of statement such as
select*from opers where op_date<="1/1/2001"

leads to error message:
Overflow occurred during data type conversion.
conversion error from string "1/1/2001".

table "opers" has index on field op_date

this statement works ok
select*from opers where op_date<=cast ("1/1/2001"as date)

as far as i can see only fields of type DATE with NON-recomputed index on them. FB1.5 works fine.
Backup-restore procedure fixes this issue, but for some case it is not possible to do on all the databases in use (over 350 all over Ukraine)

P.S. Sorry for my bad english

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 23/Apr/10 09:38 PM
The issue was introduced in FB 2.0 due to cleanup of "unused" code. It seems more or less easy to restore corresponding pieces.