1--TEST--
2PDO_Firebird: Bug #74462 Returns only NULLs for boolean fields
3--EXTENSIONS--
4pdo_firebird
5--SKIPIF--
6<?php require('skipif.inc'); ?>
7--XLEAK--
8A bug in firebird causes a memory leak when calling `isc_attach_database()`.
9See https://github.com/FirebirdSQL/firebird/issues/7849
10--FILE--
11<?php
12require 'testdb.inc';
13
14$dbh = getDbConnection();
15$dbh->exec('recreate table test74462 (id integer not null, abool boolean)');
16$dbh->exec('insert into test74462 (id, abool) values (1, true)');
17$dbh->exec('insert into test74462 (id, abool) values (2, false)');
18$dbh->exec('insert into test74462 (id, abool) values (3, null)');
19$S = $dbh->query('select abool from test74462 order by id');
20$D = $S->fetchAll(PDO::FETCH_COLUMN);
21unset($S);
22unset($dbh);
23var_dump($D);
24?>
25--CLEAN--
26<?php
27require 'testdb.inc';
28$dbh = getDbConnection();
29@$dbh->exec("DROP TABLE test74462");
30unset($dbh);
31?>
32--EXPECT--
33array(3) {
34  [0]=>
35  bool(true)
36  [1]=>
37  bool(false)
38  [2]=>
39  NULL
40}
41