Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1) [CORE2977] #3359

Closed
firebird-automations opened this issue Apr 23, 2010 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Alexander Volok (alexander_volok)

Jira_subtask_outward CORE2980

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

Commits: ca04228 786781e a8051dd

====== Test Details ======

Issue could not be reproduced on 2.0.0., 2.0.6, 2.0.7 and 2.1.3.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The issue was introduced in FB 2.0 due to cleanup of "unused" code. It seems more or less easy to restore corresponding pieces.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC3 [ 10381 ]

Fix Version: 2.1.4 [ 10361 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Deferred

Test Details: Couldn`t reproduce on database created in WI-V1.5.6.5026 Firebird 1.5 with ODS = 10.1.
Need a database file created in IB 5.6, but doubt that such test will have any value.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Deferred => Done successfully

Test Details: Couldn`t reproduce on database created in WI-V1.5.6.5026 Firebird 1.5 with ODS = 10.1.
Need a database file created in IB 5.6, but doubt that such test will have any value.

=>

Issue could not be reproduced on 2.0.0., 2.0.6, 2.0.7 and 2.1.3.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants