PHP  
 PHP_HEAD
downloads | QA | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
 

Test Failure Report for ext/oci8/tests/bug43492_2.phpt ('Bug #43492 (Nested cursor leaks after related bug #44206 fixed)')

Script

1: <?php
2:
3:
// This test is similar to bug43492.phpt without the explicit free.
4: // Now that bug 44206 is fixed an automatic clean up will occur -
5: // though it is still recommended in practice.
6:
7:
require dirname(__FILE__).'/connect.inc';
8:
9:
$stmtarray = array(
10:     
"DROP table bug43492_tab",
11:     
"CREATE TABLE bug43492_tab(col1 VARCHAR2(1))",
12:     
"INSERT INTO bug43492_tab VALUES ('A')",
13:     
"INSERT INTO bug43492_tab VALUES ('B')",
14:     
"INSERT INTO bug43492_tab VALUES ('C')",
15:     
"INSERT INTO bug43492_tab VALUES ('D')",
16:     
"INSERT INTO bug43492_tab VALUES ('E')",
17:     
"INSERT INTO bug43492_tab VALUES ('F')",
18:     
"INSERT INTO bug43492_tab VALUES ('G')",
19:     
"INSERT INTO bug43492_tab VALUES ('H')",
20:     
"INSERT INTO bug43492_tab VALUES ('I')",
21:     
"INSERT INTO bug43492_tab VALUES ('J')"
22:
);
23:
24:
oci8_test_sql_execute($c$stmtarray);
25:
26: function 
fetch($c$i) {
27:     
$s ociparse($c'select cursor(select * from bug43492_tab) c from bug43492_tab');
28:     
ociexecute($sOCI_DEFAULT);
29:     
ocifetchinto($s$resultOCI_ASSOC);
30:     
ociexecute($result['C'], OCI_DEFAULT);
31:     return 
$result['C'];
32: }
33:
34: for(
$i 0$i 300$i++) {
35:     
$cur fetch($c$i);
36:     for(
$j 0$j 10$j++) {
37:         
ocifetchinto($cur$rowOCI_NUM);
38:         echo 
"$row[0] ";
39:     }
40:     echo 
"\n";
41:     
ocifreestatement($cur);
42: }
43:
44: echo 
"Done\n";
45:
46:
// Cleanup
47:
48:
$stmtarray = array(
49:     
"DROP table bug43492_tab"
50:
);
51:
52:
oci8_test_sql_execute($c$stmtarray);
53:
54:
?>
55:

Expected

A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
A B C D E F G H I J 
Done

Output

***********************************************************************
Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

  VERSION INFORMATION:
	TNS for Linux: Version 11.2.0.2.0 - Beta
	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
  Time: 17-JUN-2018 05:04:06
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener

Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect.inc on line 14
    nt secondary err code: 111
    nt OS err code: 0

Diff

001+ ***********************************************************************
002+ Fatal NI connect error 12541, connecting to:
003+  (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
004+ 
005+   VERSION INFORMATION:
006+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
007+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
008+   Time: 17-JUN-2018 05:04:06
009+   Tracing not turned on.
010+   Tns error struct:
011+     ns main err code: 12541
012+     TNS-12541: TNS:no listener
013+     ns secondary err code: 12560
014+     nt main err code: 511
015+     TNS-00511: No listener
016+ 
017+ Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect.inc on line 14
018+     nt secondary err code: 111
019+     nt OS err code: 0
001- A B C D E F G H I J 
002- A B C D E F G H I J 
003- A B C D E F G H I J 
004- A B C D E F G H I J 
005- A B C D E F G H I J 
006- A B C D E F G H I J 
007- A B C D E F G H I J 
008- A B C D E F G H I J 
009- A B C D E F G H I J 
010- A B C D E F G H I J 
011- A B C D E F G H I J 
012- A B C D E F G H I J 
013- A B C D E F G H I J 
014- A B C D E F G H I J 
015- A B C D E F G H I J 
016- A B C D E F G H I J 
017- A B C D E F G H I J 
018- A B C D E F G H I J 
019- A B C D E F G H I J 
020- A B C D E F G H I J 
021- A B C D E F G H I J 
022- A B C D E F G H I J 
023- A B C D E F G H I J 
024- A B C D E F G H I J 
025- A B C D E F G H I J 
026- A B C D E F G H I J 
027- A B C D E F G H I J 
028- A B C D E F G H I J 
029- A B C D E F G H I J 
030- A B C D E F G H I J 
031- A B C D E F G H I J 
032- A B C D E F G H I J 
033- A B C D E F G H I J 
034- A B C D E F G H I J 
035- A B C D E F G H I J 
036- A B C D E F G H I J 
037- A B C D E F G H I J 
038- A B C D E F G H I J 
039- A B C D E F G H I J 
040- A B C D E F G H I J 
041- A B C D E F G H I J 
042- A B C D E F G H I J 
043- A B C D E F G H I J 
044- A B C D E F G H I J 
045- A B C D E F G H I J 
046- A B C D E F G H I J 
047- A B C D E F G H I J 
048- A B C D E F G H I J 
049- A B C D E F G H I J 
050- A B C D E F G H I J 
051- A B C D E F G H I J 
052- A B C D E F G H I J 
053- A B C D E F G H I J 
054- A B C D E F G H I J 
055- A B C D E F G H I J 
056- A B C D E F G H I J 
057- A B C D E F G H I J 
058- A B C D E F G H I J 
059- A B C D E F G H I J 
060- A B C D E F G H I J 
061- A B C D E F G H I J 
062- A B C D E F G H I J 
063- A B C D E F G H I J 
064- A B C D E F G H I J 
065- A B C D E F G H I J 
066- A B C D E F G H I J 
067- A B C D E F G H I J 
068- A B C D E F G H I J 
069- A B C D E F G H I J 
070- A B C D E F G H I J 
071- A B C D E F G H I J 
072- A B C D E F G H I J 
073- A B C D E F G H I J 
074- A B C D E F G H I J 
075- A B C D E F G H I J 
076- A B C D E F G H I J 
077- A B C D E F G H I J 
078- A B C D E F G H I J 
079- A B C D E F G H I J 
080- A B C D E F G H I J 
081- A B C D E F G H I J 
082- A B C D E F G H I J 
083- A B C D E F G H I J 
084- A B C D E F G H I J 
085- A B C D E F G H I J 
086- A B C D E F G H I J 
087- A B C D E F G H I J 
088- A B C D E F G H I J 
089- A B C D E F G H I J 
090- A B C D E F G H I J 
091- A B C D E F G H I J 
092- A B C D E F G H I J 
093- A B C D E F G H I J 
094- A B C D E F G H I J 
095- A B C D E F G H I J 
096- A B C D E F G H I J 
097- A B C D E F G H I J 
098- A B C D E F G H I J 
099- A B C D E F G H I J 
100- A B C D E F G H I J 
101- A B C D E F G H I J 
102- A B C D E F G H I J 
103- A B C D E F G H I J 
104- A B C D E F G H I J 
105- A B C D E F G H I J 
106- A B C D E F G H I J 
107- A B C D E F G H I J 
108- A B C D E F G H I J 
109- A B C D E F G H I J 
110- A B C D E F G H I J 
111- A B C D E F G H I J 
112- A B C D E F G H I J 
113- A B C D E F G H I J 
114- A B C D E F G H I J 
115- A B C D E F G H I J 
116- A B C D E F G H I J 
117- A B C D E F G H I J 
118- A B C D E F G H I J 
119- A B C D E F G H I J 
120- A B C D E F G H I J 
121- A B C D E F G H I J 
122- A B C D E F G H I J 
123- A B C D E F G H I J 
124- A B C D E F G H I J 
125- A B C D E F G H I J 
126- A B C D E F G H I J 
127- A B C D E F G H I J 
128- A B C D E F G H I J 
129- A B C D E F G H I J 
130- A B C D E F G H I J 
131- A B C D E F G H I J 
132- A B C D E F G H I J 
133- A B C D E F G H I J 
134- A B C D E F G H I J 
135- A B C D E F G H I J 
136- A B C D E F G H I J 
137- A B C D E F G H I J 
138- A B C D E F G H I J 
139- A B C D E F G H I J 
140- A B C D E F G H I J 
141- A B C D E F G H I J 
142- A B C D E F G H I J 
143- A B C D E F G H I J 
144- A B C D E F G H I J 
145- A B C D E F G H I J 
146- A B C D E F G H I J 
147- A B C D E F G H I J 
148- A B C D E F G H I J 
149- A B C D E F G H I J 
150- A B C D E F G H I J 
151- A B C D E F G H I J 
152- A B C D E F G H I J 
153- A B C D E F G H I J 
154- A B C D E F G H I J 
155- A B C D E F G H I J 
156- A B C D E F G H I J 
157- A B C D E F G H I J 
158- A B C D E F G H I J 
159- A B C D E F G H I J 
160- A B C D E F G H I J 
161- A B C D E F G H I J 
162- A B C D E F G H I J 
163- A B C D E F G H I J 
164- A B C D E F G H I J 
165- A B C D E F G H I J 
166- A B C D E F G H I J 
167- A B C D E F G H I J 
168- A B C D E F G H I J 
169- A B C D E F G H I J 
170- A B C D E F G H I J 
171- A B C D E F G H I J 
172- A B C D E F G H I J 
173- A B C D E F G H I J 
174- A B C D E F G H I J 
175- A B C D E F G H I J 
176- A B C D E F G H I J 
177- A B C D E F G H I J 
178- A B C D E F G H I J 
179- A B C D E F G H I J 
180- A B C D E F G H I J 
181- A B C D E F G H I J 
182- A B C D E F G H I J 
183- A B C D E F G H I J 
184- A B C D E F G H I J 
185- A B C D E F G H I J 
186- A B C D E F G H I J 
187- A B C D E F G H I J 
188- A B C D E F G H I J 
189- A B C D E F G H I J 
190- A B C D E F G H I J 
191- A B C D E F G H I J 
192- A B C D E F G H I J 
193- A B C D E F G H I J 
194- A B C D E F G H I J 
195- A B C D E F G H I J 
196- A B C D E F G H I J 
197- A B C D E F G H I J 
198- A B C D E F G H I J 
199- A B C D E F G H I J 
200- A B C D E F G H I J 
201- A B C D E F G H I J 
202- A B C D E F G H I J 
203- A B C D E F G H I J 
204- A B C D E F G H I J 
205- A B C D E F G H I J 
206- A B C D E F G H I J 
207- A B C D E F G H I J 
208- A B C D E F G H I J 
209- A B C D E F G H I J 
210- A B C D E F G H I J 
211- A B C D E F G H I J 
212- A B C D E F G H I J 
213- A B C D E F G H I J 
214- A B C D E F G H I J 
215- A B C D E F G H I J 
216- A B C D E F G H I J 
217- A B C D E F G H I J 
218- A B C D E F G H I J 
219- A B C D E F G H I J 
220- A B C D E F G H I J 
221- A B C D E F G H I J 
222- A B C D E F G H I J 
223- A B C D E F G H I J 
224- A B C D E F G H I J 
225- A B C D E F G H I J 
226- A B C D E F G H I J 
227- A B C D E F G H I J 
228- A B C D E F G H I J 
229- A B C D E F G H I J 
230- A B C D E F G H I J 
231- A B C D E F G H I J 
232- A B C D E F G H I J 
233- A B C D E F G H I J 
234- A B C D E F G H I J 
235- A B C D E F G H I J 
236- A B C D E F G H I J 
237- A B C D E F G H I J 
238- A B C D E F G H I J 
239- A B C D E F G H I J 
240- A B C D E F G H I J 
241- A B C D E F G H I J 
242- A B C D E F G H I J 
243- A B C D E F G H I J 
244- A B C D E F G H I J 
245- A B C D E F G H I J 
246- A B C D E F G H I J 
247- A B C D E F G H I J 
248- A B C D E F G H I J 
249- A B C D E F G H I J 
250- A B C D E F G H I J 
251- A B C D E F G H I J 
252- A B C D E F G H I J 
253- A B C D E F G H I J 
254- A B C D E F G H I J 
255- A B C D E F G H I J 
256- A B C D E F G H I J 
257- A B C D E F G H I J 
258- A B C D E F G H I J 
259- A B C D E F G H I J 
260- A B C D E F G H I J 
261- A B C D E F G H I J 
262- A B C D E F G H I J 
263- A B C D E F G H I J 
264- A B C D E F G H I J 
265- A B C D E F G H I J 
266- A B C D E F G H I J 
267- A B C D E F G H I J 
268- A B C D E F G H I J 
269- A B C D E F G H I J 
270- A B C D E F G H I J 
271- A B C D E F G H I J 
272- A B C D E F G H I J 
273- A B C D E F G H I J 
274- A B C D E F G H I J 
275- A B C D E F G H I J 
276- A B C D E F G H I J 
277- A B C D E F G H I J 
278- A B C D E F G H I J 
279- A B C D E F G H I J 
280- A B C D E F G H I J 
281- A B C D E F G H I J 
282- A B C D E F G H I J 
283- A B C D E F G H I J 
284- A B C D E F G H I J 
285- A B C D E F G H I J 
286- A B C D E F G H I J 
287- A B C D E F G H I J 
288- A B C D E F G H I J 
289- A B C D E F G H I J 
290- A B C D E F G H I J 
291- A B C D E F G H I J 
292- A B C D E F G H I J 
293- A B C D E F G H I J 
294- A B C D E F G H I J 
295- A B C D E F G H I J 
296- A B C D E F G H I J 
297- A B C D E F G H I J 
298- A B C D E F G H I J 
299- A B C D E F G H I J 
300- A B C D E F G H I J 
301- Done

 

Generated at Mon, 18 Jun 2018 17:33:50 +0000 (5 days ago)

Copyright © 2005-2018 The PHP Group
All rights reserved.