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