--TEST--
GH-10908 (Bus error with PDO Firebird on RPI with 64 bit kernel and 32 bit userland)
--EXTENSIONS--
pdo_firebird
--SKIPIF--
<?php require('skipif.inc'); ?>
--XLEAK--
A bug in firebird causes a memory leak when calling `isc_attach_database()`.
See https://github.com/FirebirdSQL/firebird/issues/7849
--FILE--
<?php

require("testdb.inc");

$sql = <<<EOT
CREATE TABLE gh10908(
  ID BIGINT NOT NULL,
  CODE VARCHAR(60) NOT NULL,
  NUM NUMERIC(18, 3),
  DBL DOUBLE PRECISION,
  FLT FLOAT,
  TS TIMESTAMP,
  MYDATE DATE,
  MYTIME TIME,
  MYBLOB BLOB,
  MYSMALLINT SMALLINT,
  MYINT INT,
  MYCHAR CHAR(10),
  MYBOOL BOOLEAN
);
EOT;
$dbh = getDbConnection();
$dbh->exec($sql);
$dbh->exec("INSERT INTO gh10908 VALUES(1, 'ABC', 12.34, 1.0, 2.0, '2023-03-24 17:39', '2023-03-24', '17:39', 'abcdefg', 32767, 200000, 'azertyuiop', false);");

function query_and_dump($dbh, $sql) {
    foreach ($dbh->query($sql) as $row) {
        print_r($row);
        print("\n");
    }
}

query_and_dump($dbh, "SELECT CODE   FROM gh10908"); // works fine
query_and_dump($dbh, "SELECT ID     FROM gh10908"); // Used to "bus error"
query_and_dump($dbh, "SELECT NUM    FROM gh10908"); // Used to "bus error"
query_and_dump($dbh, "SELECT DBL    FROM gh10908"); // Used to "bus error"
query_and_dump($dbh, "SELECT TS     FROM gh10908"); // Used to "bus error"
query_and_dump($dbh, "SELECT MYBLOB FROM gh10908"); // Used to "bus error"
query_and_dump($dbh, "SELECT *      FROM gh10908"); // Used to "bus error"

query_and_dump($dbh, "SELECT CAST(NUM AS NUMERIC(9, 3)) FROM gh10908"); // works fine
query_and_dump($dbh, "SELECT CAST(ID AS INTEGER)        FROM gh10908"); // works fine
query_and_dump($dbh, "SELECT CAST(ID AS BIGINT)         FROM gh10908"); // Used to "bus error"

echo "Did not crash\n";

?>
--CLEAN--
<?php
require 'testdb.inc';
$dbh = getDbConnection();
@$dbh->exec("DROP TABLE gh10908");
unset($dbh);
?>
--EXPECT--
Array
(
    [CODE] => ABC
    [0] => ABC
)

Array
(
    [ID] => 1
    [0] => 1
)

Array
(
    [NUM] => 12.340
    [0] => 12.340
)

Array
(
    [DBL] => 1
    [0] => 1
)

Array
(
    [TS] => 2023-03-24 17:39:00
    [0] => 2023-03-24 17:39:00
)

Array
(
    [MYBLOB] => abcdefg
    [0] => abcdefg
)

Array
(
    [ID] => 1
    [0] => 1
    [CODE] => ABC
    [1] => ABC
    [NUM] => 12.340
    [2] => 12.340
    [DBL] => 1
    [3] => 1
    [FLT] => 2
    [4] => 2
    [TS] => 2023-03-24 17:39:00
    [5] => 2023-03-24 17:39:00
    [MYDATE] => 2023-03-24
    [6] => 2023-03-24
    [MYTIME] => 17:39:00
    [7] => 17:39:00
    [MYBLOB] => abcdefg
    [8] => abcdefg
    [MYSMALLINT] => 32767
    [9] => 32767
    [MYINT] => 200000
    [10] => 200000
    [MYCHAR] => azertyuiop
    [11] => azertyuiop
    [MYBOOL] => 
    [12] => 
)

Array
(
    [CAST] => 12.340
    [0] => 12.340
)

Array
(
    [CAST] => 1
    [0] => 1
)

Array
(
    [CAST] => 1
    [0] => 1
)

Did not crash