PostgreSQL component does not allow for inserting or updating records with Int64 values
Original Reporter info from Mantis: aurawin
-
Reporter name: Andrew Brunner
Original Reporter info from Mantis: aurawin
- Reporter name: Andrew Brunner
Description:
Server: postgres 8.4.5
postgres component does not allow for inserting or updating records with Int64 values (LargeInt/BIGINT) values over that of High(Integer).
The fields in my database are BIGINT.
Background info:
used the connector/transaction/query via Lazarus project
Created tables with sql execute with BIGINT/SERIAL/BIGSERIAL/ constraints (all ok)
Verified columns per table per schema. ok.
Nearly most of the features of this component look good. Problem is when working with AsLargeInt and values over High(Integer).
Steps to reproduce:
To duplicate just use High(Int64) and prepare will suceed but execute throws server error "expecting int..." So it fails post with range check error for integer overflow (imo).
Meaning:
Have table with at least one BIGINT field.
Just query.sql.text to execute with parameter(s) with value set to High(INT64)
Additional information:
I'm really needing either MySQL or PostgreSQL components with full features. So please pick one and resolve so I can move forward with project.
Mantis conversion info:
- Mantis ID: 17683
- OS: Ubuntu x64
- OS Build: 10.10
- Build: 16195 (subversion)
- Platform: Hexcore AMD x64
- Version: 2.5.1
- Fixed in version: 2.4.4
- Fixed in revision: 16422 (#0379e000)
- Target version: 3.0.0