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-issue-importer opened this issue Apr 23, 2010 · 6 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 24, 2010

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 24, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 28, 2010

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC3 [ 10381 ]

Fix Version: 2.1.4 [ 10361 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 4, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 20, 2015

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 23, 2016

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants