1--TEST-- 2PDO MySQL Bug #41698 (float parameters truncated to integer in prepared statements) 3--EXTENSIONS-- 4pdo 5pdo_mysql 6--SKIPIF-- 7<?php 8require __DIR__ . '/config.inc'; 9require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc'; 10PDOTest::skip(); 11?> 12--FILE-- 13<?php 14require __DIR__ . '/config.inc'; 15require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc'; 16$db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 17 18setlocale(LC_ALL, "de","de_DE","de_DE.ISO8859-1","de_DE.ISO_8859-1","de_DE.UTF-8"); 19 20$db->exec('CREATE TABLE test(floatval DECIMAL(8,6))'); 21$db->exec('INSERT INTO test VALUES(2.34)'); 22$value=4.56; 23$stmt = $db->prepare('INSERT INTO test VALUES(?)'); 24$stmt->execute(array($value)); 25var_dump($db->query('SELECT * from test')->fetchAll(PDO::FETCH_ASSOC)); 26?> 27--EXPECT-- 28array(2) { 29 [0]=> 30 array(1) { 31 ["floatval"]=> 32 string(8) "2.340000" 33 } 34 [1]=> 35 array(1) { 36 ["floatval"]=> 37 string(8) "4.560000" 38 } 39} 40
