PHP 8.1, PDO, MySQL, Decimal column

[marmichalski]

Hello,

decimal type is returned as string in PHP, but phpstan-dba thinks it's a float 😢.

This is, of course, without stringified fetches.

(unless I miss something 😱)

[staabm]

Thx for reporting. Are you willing to contribute?

the relevant parts can be found here

• type mappings: https://github.com/staabm/phpstan-dba/tree/5c112b0f38ff9fda55a2366c31648cbdc46283dd/src/TypeMapping
• tests

  phpstan-dba/tests/default/data/pdo-mysql.php

  Line 21 in 5c112b0

  assertType('PDOStatement<array{pid: int<0, 4294967295>, c_char5: string, c_varchar255: string, c_varchar25: string|null, c_varbinary255: string, c_varbinary25: string|null, c_date: string|null, c_time: string|null, c_datetime: string|null, c_timestamp: string|null, c_year: int<0, 2155>|null, c_tiny_text: string|null, c_medium_text: string|null, c_text: string|null, c_long_text: string|null, c_enum: string, c_set: string, c_bit: int|null, c_int: int<-2147483648, 2147483647>, c_tinyint: int<-128, 127>, c_smallint: int<-32768, 32767>, c_mediumint: int<-8388608, 8388607>, c_bigint: int, c_double: float, c_real: float, c_boolean: int<-128, 127>, c_blob: string, c_tinyblob: string, c_mediumblog: string, c_longblob: string, c_unsigned_tinyint: int<0, 255>, c_unsigned_int: int<0, 4294967295>, c_unsigned_smallint: int<0, 65535>, c_unsigned_mediumint: int<0, 16777215>, c_unsigned_bigint: int<0, max>, c_json: string|null, c_json_not_null: string}>', $stmt);

[marmichalski]

Thx for reporting. Are you willing to contribute?

Yes, of course, but probably next week 🙈