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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
--TEST--
Bug #71600 (oci_fetch_all result in segfault when select more than 8 columns)
--SKIPIF--
<?php
$target_dbs = array('oracledb' => true, 'timesten' => true); // test runs on these DBs
require(dirname(__FILE__).'/skipif.inc');
?>
--FILE--
<?php
require(dirname(__FILE__).'/connect.inc');
// Initialize
$stmtarray = array(
"create table bug71600_tab (col1 number, col2 number, col3 number,
col4 number, col5 number, col6 number,
col7 number, col8 number, col9 number)",
"insert into bug71600_tab values(1, 2, 3, 4, 5, 6, 7, 8, 9)",
"insert into bug71600_tab values(11, 12, 13, 14, 15, 16, 17, 18, 19)"
);
oci8_test_sql_execute($c, $stmtarray);
// Run test
$sql = "select col1,col2,col3,col4,col5,col6,col7,col8,col9 from bug71600_tab";
echo "Test 1\n";
$stmt = oci_parse($c, $sql);
echo "Executing SELECT statament...\n";
oci_execute($stmt,OCI_DEFAULT);
echo "Fetching data by columns...\n";
oci_fetch_all($stmt, $result);
oci_free_statement($stmt);
$rsRows=(count($result,1)/($rows = count($result,0)))-1;
echo "$rsRows Records Found\n";
$rsCount=0;
while($rsCount < $rsRows)
{
$col1 =$result['COL1'][$rsCount];
$col9 =$result['COL9'][$rsCount];
echo "$rsCount|$col1|$col9\n";
$rsCount++;
}
echo "Test 2\n";
$stmt = oci_parse($c, $sql);
echo "Re-executing SELECT statament...\n";
oci_execute($stmt,OCI_DEFAULT);
echo "Fetching data by rows...\n";
oci_fetch_all($stmt, $result, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
oci_free_statement($stmt);
$rsRows=count($result,0);
echo "$rsRows Records Found\n";
$rsCount=0;
while($rsCount < $rsRows)
{
$col1 = $result[$rsCount]['COL1'];
$col9 = $result[$rsCount]['COL9'];
echo "$rsCount|$col1|$col9\n";
$rsCount++;
}
// Cleanup
$stmtarray = array(
"drop table bug71600_tab"
);
oci8_test_sql_execute($c, $stmtarray);
?>
===DONE===
<?php exit(0); ?>
--EXPECT--
Test 1
Executing SELECT statament...
Fetching data by columns...
2 Records Found
0|1|9
1|11|19
Test 2
Re-executing SELECT statament...
Fetching data by rows...
2 Records Found
0|1|9
1|11|19
===DONE===
|
