|
If you were logged in you would be able to see more operations.
|
|
|
Time Tracking:
Issue & Sub-Tasks
Issue Only
Issue & Sub-Tasks
Issue Only
|
|
|
|
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.
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
|
|
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
|
|
Description
|
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 |
Show » |
|
Bug
Closed
Major
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
