php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #81143 BIGINT support
Submitted: 2021-06-15 18:42 UTC Modified: -
Votes:6
Avg. Score:4.3 ± 0.9
Reproduced:6 of 6 (100.0%)
Same Version:4 (66.7%)
Same OS:0 (0.0%)
From: simbiat at outlook dot com Assigned:
Status: Open Package: PDO Core
PHP Version: 8.0.7 OS:
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: simbiat at outlook dot com
New email:
PHP Version: OS:

 

 [2021-06-15 18:42 UTC] simbiat at outlook dot com
Description:
------------
Currently PHP's PDO does not support BIGINT. When using prepared statements with binding, if we want to use bind a BIGINT we can't use PDO::PARAM_INT, since it will fail on PHP's side due to BIGINT being larger than PHP's maximum value for INT. The only alternative option (at least for MySQL) seems to be "use string" (PDO::PARAM_STR), but this can result in strange behavior (https://dba.stackexchange.com/questions/293791/missing-an-inserted-row), which can even lead to loss of data in some circumstances, because (as confirmed in https://bugs.mysql.com/bug.php?id=103992) MySQL does not guarantee valid and consistent comparison of BIGINT [UNSIGNED] vs VARCHAR.
As such PDO needs to have a way to bind BIGINT values.
Of course, one can use casting in the queries to work around the limitation, but that is counterintuitive and easily forgettable.

Test script:
---------------
N/A since feature request

Expected result:
----------------
PDO::PARAM_BIGINT is added to future versions of PHP

Actual result:
--------------
Currently no PDO::PARAM_BIGINT

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2023-05-16 11:41 UTC] architecturehomed at gmail dot com
Architecture homedesign are sharing latest news about home architecture, home design, home decoration, roofing, furniture etc. More info to visit: (https://architecturehomedesign.com)github.com
 [2024-07-09 10:46 UTC] addy345willson at gmail dot com
Thanks for creating this bug (https://github.com)(https://www.securespend.com.co)
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Dec 03 17:01:29 2024 UTC