You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
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.
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.
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.
The text was updated successfully, but these errors were encountered: