Bug #74779 [NEW]: x() and y() truncating floats to integers

From: yunosh Operating system: Linux PHP version: 7.0Git-2017-06-19 (Git) Package: MySQLi related Bug Type: Bug Bug description:x() and y() truncating floats to integers Description: ------------ When retrieving spatial coordinates from a point column using the x() and y() sql functions, the mysqli fetch_array(MYSQLI_ASSOC) method return integers instead of floats if using the MYSQLI_OPT_INT_AND_FLOAT_NATIVE option and locale that don't have a fullstop as decimal separator. Test script: --------------- setlocale(LC_ALL, "de_DE.UTF-8"); $m = new mysqli(); $m->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, true); $result = $m->query("SELECT Y(Point(56.7, 53.34))"); var_dump($result->fetch_array(MYSQLI_ASSOC)); Expected result: ---------------- array(1) { 'Y(Point(56.7, 53.34))' => double(53.34) } Actual result: -------------- array(1) { 'Y(Point(56.7, 53.34))' => double(53) } -- Edit bug report at https://bugs.php.net/bug.php?id=74779&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74779&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74779&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74779&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=74779&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=74779&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=74779&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=74779&r=needscript Try newer version: https://bugs.php.net/fix.php?id=74779&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=74779&r=support Expected behavior: https://bugs.php.net/fix.php?id=74779&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=74779&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=74779&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=74779&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74779&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=74779&r=dst IIS Stability: https://bugs.php.net/fix.php?id=74779&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=74779&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=74779&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=74779&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=74779&r=mysqlcfg