Bug #80592 [Opn->Ver]: all floats are the same in ODBC parameters

Edit report at https://bugs.php.net/bug.php?id=80592&edit=1 ID: 80592 Updated by: cmb@php.net Reported by: a dot kasparas at gmc dot lt Summary: all floats are the same in ODBC parameters -Status: Open +Status: Verified Type: Bug Package: ODBC related Operating System: Windows 10 Pro PHP Version: 8.0.0 Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2021-01-05 13:44:53] 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"} ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=80592&edit=1