Php: Alpine : PHP with PDO not return proper native value from database

[sanjay-rakholiya]

I have used official alpine php-image for different versions with pdo_mysql extension.

Set PDO::ATTR_EMULATE_PREPARES = false to get native db value.

It's return float(11.1) instead of float(11.11) and problem with only Alpine while working proper for buster php-image

Issue reported on alpine too : https://gitlab.alpinelinux.org/alpine/aports/issues/11072

RUN apk update --no-cache \
    && apk add --no-cache $PHPIZE_DEPS \
    && docker-php-ext-install pdo pdo_mysql

Docker up & Run php test file not returning proper native value for float datatype in Mysql

<?php 

// DB configuration
$host =  'localhost';
$user = 'test';
$dbPass = 'test';
$dbname = 'test';
$dsn = 'mysql:host='. $host .';dbname='. $dbname;

// PDO connection and settings
$pdo = new PDO($dsn, $user, $dbPass);

// It's required otherwise return value in string instead of float
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

// Here amount is float(5,2) & Value = 11.11
$sql = 'SELECT id, amount FROM account WHERE id=1236';
$stmt = $pdo->prepare($sql);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);

echo '<pre>';
var_dump($row['amount']); // It's return float(11.1) instead of float(11.11)
echo "\n";
echo '</pre>';
exit;

[wglambert]

The php images consume the source from https://www.php.net/, so when Cogitri said to ask upstream he meant php upstream

https://github.com/docker-library/php/blob/ae3f372b446b6457326504d9b9984ce708f20c3d/7.4/alpine3.11/fpm/Dockerfile#L67

https://github.com/docker-library/php/blob/ae3f372b446b6457326504d9b9984ce708f20c3d/7.4/alpine3.11/fpm/Dockerfile#L77

Looking at php bug reports of the 8 that mention Alpine I don't see a related one. So I would file the issue there since there's nothing actionable for us as maintainers of the image when we just consume what upstream provides

[andypost]

@wglambert thank you a lot for the list of bugs, alpine disables lots of tests to pass, this could help to fix them

[andypost]

So the issue is just about a way to buildextension in original image.
If you need this native data types you should build --with-pdo-mysql=shared,mysqlnd according to https://www.php.net/manual/en/mysqlinfo.library.choosing.php