mirror of
https://github.com/php/php-src.git
synced 2026-03-25 16:52:18 +01:00
50 lines
1.1 KiB
PHP
50 lines
1.1 KiB
PHP
--TEST--
|
|
Bug #77047 pg_insert has a broken regex for the 'TIME WITHOUT TIMEZONE' data type
|
|
--EXTENSIONS--
|
|
pgsql
|
|
--SKIPIF--
|
|
<?php
|
|
include("skipif.inc");
|
|
?>
|
|
--FILE--
|
|
<?php
|
|
error_reporting(E_ALL);
|
|
|
|
include 'config.inc';
|
|
|
|
$db = pg_connect($conn_str);
|
|
|
|
pg_query($db, "DROP TABLE IF EXISTS bug77047");
|
|
pg_query($db, "CREATE TABLE bug77047 (
|
|
t TIME WITHOUT TIME ZONE
|
|
)");
|
|
|
|
try {
|
|
pg_insert($db, "bug77047", array("t" => "13:31"));
|
|
} catch (\TypeError $e) {
|
|
echo $e->getMessage();
|
|
}
|
|
pg_insert($db, "bug77047", array("t" => "13:31:13"));
|
|
pg_insert($db, "bug77047", array("t" => "1:2:3"));
|
|
try {
|
|
pg_insert($db, "bug77047", array("t" => "xyz"));
|
|
} catch (\TypeError $e) {
|
|
echo $e->getMessage() . PHP_EOL;
|
|
}
|
|
pg_insert($db, "bug77047", array("t" => NULL));
|
|
pg_insert($db, "bug77047", array("t" => ""));
|
|
|
|
$res = pg_query($db, "SELECT t FROM bug77047");
|
|
while (false !== ($row = pg_fetch_row($res))) {
|
|
var_dump(array_pop($row));
|
|
}
|
|
|
|
?>
|
|
--EXPECTF--
|
|
pg_insert(): Field "t" must be of type string|null, time given
|
|
string(8) "13:31:00"
|
|
string(8) "13:31:13"
|
|
string(8) "01:02:03"
|
|
NULL
|
|
NULL
|