diff options
author | Anatol Belski <ab@php.net> | 2016-04-05 15:06:17 +0200 |
---|---|---|
committer | Anatol Belski <ab@php.net> | 2016-04-05 15:06:17 +0200 |
commit | c2cb4664bcaea292be4d77951fb98785f763c193 (patch) | |
tree | facb2bdd9c1998b9b005adb9dc0cff968ead5295 /ext/pdo_pgsql | |
parent | e10257ba8069fb982d9cd8681f6633de9fea534d (diff) | |
download | php-git-c2cb4664bcaea292be4d77951fb98785f763c193.tar.gz |
fix and extend test
Diffstat (limited to 'ext/pdo_pgsql')
-rw-r--r-- | ext/pdo_pgsql/tests/bug62498.phpt | 125 |
1 files changed, 103 insertions, 22 deletions
diff --git a/ext/pdo_pgsql/tests/bug62498.phpt b/ext/pdo_pgsql/tests/bug62498.phpt index cefcd1f3f1..e4ca3dec4f 100644 --- a/ext/pdo_pgsql/tests/bug62498.phpt +++ b/ext/pdo_pgsql/tests/bug62498.phpt @@ -16,21 +16,27 @@ $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); $db->setAttribute (\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); // create the table -$db->exec("CREATE TEMPORARY TABLE bugtest_62498 (intcol INTEGER, stringcol VARCHAR(255), boolcol BOOLEAN, datecol DATE)"); +$db->exec("CREATE TEMPORARY TABLE bugtest_62498 (int2col INT2, int4col INT4, int8col INT8, stringcol VARCHAR(255), boolcol BOOLEAN, datecol DATE, textcol TEXT, tscol TIMESTAMP, byteacol BYTEA)"); // insert some data -$statement = $db->prepare("INSERT INTO bugtest_62498 (intcol, stringcol, boolcol, datecol) VALUES (:intval, :stringval, :boolval, :dateval)"); -$statement->execute(array( - "intval" => "42", +$statement = $db->prepare("INSERT INTO bugtest_62498 (int2col, int4col, int8col, stringcol, boolcol, datecol, textcol, tscol, byteacol) VALUES (:int2val, :int4val, :int8val, :stringval, :boolval, :dateval, :textval, :tsval, :byteaval)"); +$vals = array( + "int2val" => "42", + "int4val" => "42", + "int8val" => "42", "stringval" => "The Answer", "boolval" => true, "dateval" => '2015-12-14', -)); + "textval" => "some text", + "tsval" => 19990108, + "byteaval" => 0, +); +$statement->execute($vals); -$select = $db->query('SELECT intcol, stringcol, boolcol, datecol FROM bugtest_62498'); +$select = $db->query('SELECT int2col, int4col, int8col, stringcol, boolcol, datecol, textcol, tscol, byteacol FROM bugtest_62498'); $meta = []; -for ($i=0; $i < 4; $i++) { - $meta[] = $select->getColumnMeta(0); +for ($i=0; $i < count($vals); $i++) { + $meta[] = $select->getColumnMeta($i); } var_dump($meta); @@ -38,17 +44,17 @@ var_dump($meta); Done --EXPECT-- Begin test... -array(4) { +array(9) { [0]=> array(6) { ["pgsql:oid"]=> - int(23) + int(21) ["native_type"]=> - string(4) "int4" + string(4) "int2" ["name"]=> - string(6) "intcol" + string(7) "int2col" ["len"]=> - int(4) + int(2) ["precision"]=> int(-1) ["pdo_type"]=> @@ -61,7 +67,7 @@ array(4) { ["native_type"]=> string(4) "int4" ["name"]=> - string(6) "intcol" + string(7) "int4col" ["len"]=> int(4) ["precision"]=> @@ -72,13 +78,13 @@ array(4) { [2]=> array(6) { ["pgsql:oid"]=> - int(23) + int(20) ["native_type"]=> - string(4) "int4" + string(4) "int8" ["name"]=> - string(6) "intcol" + string(7) "int8col" ["len"]=> - int(4) + int(8) ["precision"]=> int(-1) ["pdo_type"]=> @@ -87,17 +93,92 @@ array(4) { [3]=> array(6) { ["pgsql:oid"]=> - int(23) + int(1043) ["native_type"]=> - string(4) "int4" + string(7) "varchar" ["name"]=> - string(6) "intcol" + string(9) "stringcol" + ["len"]=> + int(-1) + ["precision"]=> + int(259) + ["pdo_type"]=> + int(2) + } + [4]=> + array(6) { + ["pgsql:oid"]=> + int(16) + ["native_type"]=> + string(4) "bool" + ["name"]=> + string(7) "boolcol" + ["len"]=> + int(1) + ["precision"]=> + int(-1) + ["pdo_type"]=> + int(5) + } + [5]=> + array(6) { + ["pgsql:oid"]=> + int(1082) + ["native_type"]=> + string(4) "date" + ["name"]=> + string(7) "datecol" ["len"]=> int(4) ["precision"]=> int(-1) ["pdo_type"]=> - int(1) + int(2) + } + [6]=> + array(6) { + ["pgsql:oid"]=> + int(25) + ["native_type"]=> + string(4) "text" + ["name"]=> + string(7) "textcol" + ["len"]=> + int(-1) + ["precision"]=> + int(-1) + ["pdo_type"]=> + int(2) + } + [7]=> + array(6) { + ["pgsql:oid"]=> + int(1114) + ["native_type"]=> + string(9) "timestamp" + ["name"]=> + string(5) "tscol" + ["len"]=> + int(8) + ["precision"]=> + int(-1) + ["pdo_type"]=> + int(2) + } + [8]=> + array(6) { + ["pgsql:oid"]=> + int(17) + ["native_type"]=> + string(5) "bytea" + ["name"]=> + string(8) "byteacol" + ["len"]=> + int(-1) + ["precision"]=> + int(-1) + ["pdo_type"]=> + int(3) } } Done |