xref: /PHP-8.2/ext/mysqli/tests/bug70384.phpt (revision 05ed3b77)
1--TEST--
2mysqli_float_handling - ensure 4 byte float is handled correctly
3--EXTENSIONS--
4mysqli
5--SKIPIF--
6<?php
7require_once 'connect.inc';
8if (!$link = @my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
9    die(sprintf("skip Can't connect to MySQL Server - [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
10}
11
12if ($link->server_version < 50709) {
13    die("skip MySQL 5.7.9+ needed. Found [".
14        intval(substr($link->server_version."", -5, 1)).
15        ".".
16        intval(substr($link->server_version."", -4, 2)).
17        ".".
18        intval(substr($link->server_version."", -2, 2)).
19        "]");
20}
21?>
22--FILE--
23<?php
24    require 'connect.inc';
25    if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
26        printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
27        die();
28    }
29
30    if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) {
31        printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
32        die();
33    }
34
35    if (!mysqli_query($link, "CREATE TABLE test(jsfield JSON) ENGINE = InnoDB")) {
36        printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
37        die();
38    }
39    $jsfield_data = '{"aaa": 123}';
40    // Insert via string to make sure the real floating number gets to the DB
41    if (!mysqli_query($link, "INSERT INTO test VALUES ('".$jsfield_data."')")) {
42        printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
43        die();
44    }
45
46    if (!($res = mysqli_query($link, "SELECT *  FROM test"))) {
47        printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
48        die();
49    }
50    $rows = $res->fetch_all();
51    if (json_encode($rows[0][0]) != json_encode($jsfield_data)) {
52        printf("[006] Data differs");
53        var_dump(json_encode($rows[0][0]) != json_encode($jsfield_data));
54        die();
55    }
56    mysqli_close($link);
57    echo "OK";
58?>
59--CLEAN--
60<?php
61require_once "clean_table.inc";
62?>
63--EXPECT--
64OK
65