Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
CONFLICTS	9 B	-rw-rw-r--	2022-10-31 11:36
bug_47415.phpt	882 B	-rw-rw-r--	2022-10-31 11:36
bug_48877.phpt	921 B	-rw-rw-r--	2022-10-31 11:36
bug_53280.phpt	1.12 KB	-rw-rw-r--	2022-10-31 11:36
bug_62024.phpt	916 B	-rw-rw-r--	2022-10-31 11:36
bug_64037.phpt	1.01 KB	-rw-rw-r--	2022-10-31 11:36
bug_72583.phpt	543 B	-rw-rw-r--	2022-10-31 11:36
bug_72931.phpt	439 B	-rw-rw-r--	2022-10-31 11:36
bug_73087.phpt	643 B	-rw-rw-r--	2022-10-31 11:36
bug_74462.phpt	704 B	-rw-rw-r--	2022-10-31 11:36
bug_76448.data	749 B	-rw-rw-r--	2022-10-31 11:36
bug_76448.phpt	697 B	-rw-rw-r--	2022-10-31 11:36
bug_76449.data	464 B	-rw-rw-r--	2022-10-31 11:36
bug_76449.phpt	700 B	-rw-rw-r--	2022-10-31 11:36
bug_76450.data	464 B	-rw-rw-r--	2022-10-31 11:36
bug_76450.phpt	815 B	-rw-rw-r--	2022-10-31 11:36
bug_76452.data	856 B	-rw-rw-r--	2022-10-31 11:36
bug_76452.phpt	696 B	-rw-rw-r--	2022-10-31 11:36
bug_76488.phpt	612 B	-rw-rw-r--	2022-10-31 11:36
bug_77863.phpt	3.1 KB	-rw-rw-r--	2022-10-31 11:36
bug_aaa.phpt	528 B	-rw-rw-r--	2022-10-31 11:36
common.phpt	848 B	-rw-rw-r--	2022-10-31 11:36
connect.phpt	211 B	-rw-rw-r--	2022-10-31 11:36
ddl.phpt	965 B	-rw-rw-r--	2022-10-31 11:36
dialect_1.phpt	1.3 KB	-rw-rw-r--	2022-10-31 11:36
execute.phpt	1.25 KB	-rw-rw-r--	2022-10-31 11:36
payload_server.inc	2.5 KB	-rw-rw-r--	2022-10-31 11:36
payload_server.php	478 B	-rw-rw-r--	2022-10-31 11:36
payload_test.data	424 B	-rw-rw-r--	2022-10-31 11:36
payload_test.phpt	654 B	-rw-rw-r--	2022-10-31 11:36
rowCount.phpt	950 B	-rw-rw-r--	2022-10-31 11:36
skipif.inc	202 B	-rw-rw-r--	2022-10-31 11:36
testdb.inc	595 B	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
PDO_Firebird: Bug #76488 PDO Firebird does not support boolean datatype in input parameters
--SKIPIF--
<?php require('skipif.inc'); ?>
--ENV--
LSAN_OPTIONS=detect_leaks=0
--FILE--
<?php

require 'testdb.inc';

$sql = <<<SQL
with t(b, s) as (
  select true, 'true' from rdb\$database
  union all
  select false, 'false' from rdb\$database
  union all
  select unknown, 'unknown' from rdb\$database
)
select trim(s) as s from t where b is not distinct from :p
SQL;

try {
  $query = $dbh->prepare($sql);

// PDO::PARAM_BOOL
  $query->bindValue('p', 0, PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 1, PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', false, PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', true, PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 'false', PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 'True', PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', null, PDO::PARAM_BOOL);
  $query->execute();
  var_dump($query->fetchColumn(0));

// PDO::PARAM_STR
  $query->bindValue('p', false, PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', true, PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 0, PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 1, PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 'false', PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 'true', PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', null, PDO::PARAM_STR);
  $query->execute();
  var_dump($query->fetchColumn(0));

// PDO::PARAM_INT
  $query->bindValue('p', false, PDO::PARAM_INT);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', true, PDO::PARAM_INT);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 0, PDO::PARAM_INT);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 1, PDO::PARAM_INT);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 'false', PDO::PARAM_INT);
  $query->execute();
  var_dump($query->fetchColumn(0));

$query->bindValue('p', 'true', PDO::PARAM_INT);
  $query->execute();
  var_dump($query->fetchColumn(0));

echo "OK\n";
}
catch(Exception $e) {
	echo $e->getMessage() . '<br>';
	echo $e->getTraceAsString();
}
?>
--EXPECT--
string(5) "false"
string(4) "true"
string(5) "false"
string(4) "true"
string(5) "false"
string(4) "true"
string(7) "unknown"
string(5) "false"
string(4) "true"
string(5) "false"
string(4) "true"
string(5) "false"
string(4) "true"
string(7) "unknown"
string(5) "false"
string(4) "true"
string(5) "false"
string(4) "true"
string(5) "false"
string(4) "true"
OK