summaryrefslogtreecommitdiff
path: root/ext/pgsql/tests/bug60244.phpt
blob: 888e51129ff56b92f640560ee0b192ea90494c93 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
--TEST--
Bug #60244 (pg_fetch_* functions do not validate that row param is >0)
--SKIPIF--
<?php
include("skipif.inc");
?>
--FILE--
<?php

include 'config.inc';

$db = pg_connect($conn_str);
$result = pg_query("select 'a' union select 'b'");

try {
    var_dump(pg_fetch_array($result, -1));
} catch (\ValueError $e) {
    echo $e->getMessage() . \PHP_EOL;
}
try {
    var_dump(pg_fetch_assoc($result, -1));
} catch (\ValueError $e) {
    echo $e->getMessage() . \PHP_EOL;
}
try {
    var_dump(pg_fetch_object($result, -1));
} catch (\ValueError $e) {
    echo $e->getMessage() . \PHP_EOL;
}
try {
    var_dump(pg_fetch_row($result, -1));
} catch (\ValueError $e) {
    echo $e->getMessage() . \PHP_EOL;
}

var_dump(pg_fetch_array($result, 0));
var_dump(pg_fetch_assoc($result, 0));
var_dump(pg_fetch_object($result, 0));
var_dump(pg_fetch_row($result, 0));

pg_close($db);

?>
--EXPECT--
pg_fetch_array(): Argument #2 ($row) must be greater than or equal to 0
pg_fetch_assoc(): Argument #2 ($row) must be greater than or equal to 0
pg_fetch_object(): Argument #2 ($row) must be greater than or equal to 0
pg_fetch_row(): Argument #2 ($row) must be greater than or equal to 0
array(2) {
  [0]=>
  string(1) "a"
  ["?column?"]=>
  string(1) "a"
}
array(1) {
  ["?column?"]=>
  string(1) "a"
}
object(stdClass)#1 (1) {
  ["?column?"]=>
  string(1) "a"
}
array(1) {
  [0]=>
  string(1) "a"
}