php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #80592 all floats are the same in ODBC parameters
Submitted: 2021-01-05 13:44 UTC Modified: 2021-01-05 14:29 UTC
From: a dot kasparas at gmc dot lt Assigned:
Status: Closed Package: ODBC related
PHP Version: 8.0.0 OS: Windows 10 Pro
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: a dot kasparas at gmc dot lt
New email:
PHP Version: OS:

 

 [2021-01-05 13:44 UTC] a dot kasparas at gmc dot lt
Description:
------------
Floats submitted over prepared statement parameters are all set to the same (last?) value.

Test script:
---------------
On SQL server create table for tests:

CREATE TABLE float_test(
F1 float not null,
F2 float not null,
F3 float not null
);

Create ODBC connection FLOAT_TEST using available driver for SQL server;

Then execute:

$o = odbc_connect('FLOAT_TEST', 'user', 'pass');
$st_txt = 'INSERT INTO float_test (f1, f2, f3) values (?, ?, ?)';
odbc_exec($o, 'DELETE FROM float_test');
$st = odbc_prepare($o, $st_txt);
odbc_execute($st, array(1.0, 2.0, 3.0));
$st2 = odbc_prepare($o, 'SELECT f1, f2, f3 from float_test');
odbc_execute($st2);
echo json_encode(odbc_fetch_object($st2));

Expected result:
----------------
{"f1":"1.0","f2":"2.0","f3":"3.0"}

Actual result:
--------------
{"f1":"3.0","f2":"3.0","f3":"3.0"}

Patches

Pull Requests

Pull requests:

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2021-01-05 14:29 UTC] cmb@php.net
-Status: Open +Status: Verified
 [2021-01-05 23:26 UTC] cmb@php.net
The following pull request has been associated:

Patch Name: Fix #80592: all floats are the same in ODBC parameters
On GitHub:  https://github.com/php/php-src/pull/6579
Patch:      https://github.com/php/php-src/pull/6579.patch
 [2021-01-06 12:56 UTC] cmb@php.net
Automatic comment on behalf of cmbecker69@gmx.de
Revision: http://git.php.net/?p=php-src.git;a=commit;h=f674a3343ce3ab349291bde795a4ad07220f42b8
Log: Fix #80592: all floats are the same in ODBC parameters
 [2021-01-06 12:56 UTC] cmb@php.net
-Status: Verified +Status: Closed
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 14:01:29 2024 UTC