Gecko [ www.foryou-vip.com ]

Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.112
Domains : Cant Read [ /etc/named.conf ]
User : www-data

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: support 1 sql dialect
--SKIPIF--
<?php require('skipif.inc');
if (strpos(getenv('PDO_FIREBIRD_TEST_DSN'), 'dialect=1')===false) {
    die('skip: PDO_FIREBIRD_TEST_DSN must contain a string "dialect=1"');
}
?>
--ENV--
LSAN_OPTIONS=detect_leaks=0
--FILE--
<?php
	require("testdb.inc");

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
	$dbh->setAttribute(PDO::FB_ATTR_TIMESTAMP_FORMAT, '%Y-%m-%d %H:%M:%S');

$sql =
	'SELECT
	  1 as N,
	  2.0 as F,
	  cast(0.76 as numeric(15, 2)) as K,
	  cast(\'2019-06-12\' as date) as DT
	FROM RDB$DATABASE';
	$query = $dbh->prepare($sql);
	$query->execute();
	$row = $query->fetch(\PDO::FETCH_OBJ);
	var_dump($row->N);
	var_dump($row->F);
	var_dump($row->K);
	var_dump($row->DT);

unset($query);

$dbh->exec('RECREATE TABLE test_d1(K numeric(15, 2), DT date)');
	$sql='INSERT INTO test_d1(K, DT) values(?, ?)';
	$query = $dbh->prepare($sql);
	$query->execute([0.76, '2019-06-12']);
	unset($query);

$sql='SELECT * FROM test_d1';
	$query = $dbh->prepare($sql);
	$query->execute();
	$row = $query->fetch(\PDO::FETCH_OBJ);
	var_dump($row->K);
	var_dump($row->DT);

unset($query);
	unset($dbh);
	echo "done\n";

?>
--EXPECT--
int(1)
string(8) "2.000000"
string(4) "0.76"
string(19) "2019-06-12 00:00:00"
string(4) "0.76"
string(19) "2019-06-12 00:00:00"
done