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/imp_res_prefetch.phpt ('Oracle Database 12c Implicit Result Sets: basic test')

Script

1: <?php
2:
3:
require(dirname(__FILE__).'/connect.inc');
4:
5:
// Initialization
6:
7:
$stmtarray = array(
8:     
"drop table imp_res_prefetch_tab_1",
9:     
"create table imp_res_prefetch_tab_1 (c1 number, c2 varchar2(10))",
10:     
"insert into imp_res_prefetch_tab_1 values (1, 'abcde')",
11:     
"insert into imp_res_prefetch_tab_1 values (2, 'fghij')",
12:     
"insert into imp_res_prefetch_tab_1 values (3, 'klmno')",
13:
14:     
"drop table imp_res_prefetch_tab_2",
15:     
"create table imp_res_prefetch_tab_2 (c3 varchar2(1))",
16:     
"insert into imp_res_prefetch_tab_2 values ('t')",
17:     
"insert into imp_res_prefetch_tab_2 values ('u')",
18:     
"insert into imp_res_prefetch_tab_2 values ('v')",
19:
20:     
"create or replace procedure imp_res_prefetch_proc as
21:       c1 sys_refcursor;
22:     begin
23:       open c1 for select * from imp_res_prefetch_tab_1 order by 1;
24:       dbms_sql.return_result(c1);
25:
26:       open c1 for select * from imp_res_prefetch_tab_2 order by 1;
27:       dbms_sql.return_result(c1);
28:     end;"
29:
);
30:
31:
oci8_test_sql_execute($c$stmtarray);
32:
33:
// Run Test
34:
35:
echo "Test 1 - prefetch 0\n";
36:
$s oci_parse($c"begin imp_res_prefetch_proc(); end;");
37:
oci_execute($s);
38:
var_dump(oci_set_prefetch($s0));
39: while ((
$row oci_fetch_row($s)) != false)
40:     
var_dump($row);
41:
42: echo 
"\nTest 1 - prefetch 1\n";
43:
$s oci_parse($c"begin imp_res_prefetch_proc(); end;");
44:
oci_execute($s);
45:
var_dump(oci_set_prefetch($s1));
46: while ((
$row oci_fetch_row($s)) != false)
47:     
var_dump($row);
48:
49: echo 
"\nTest 1 - prefetch 2\n";
50:
$s oci_parse($c"begin imp_res_prefetch_proc(); end;");
51:
oci_execute($s);
52:
var_dump(oci_set_prefetch($s2));
53: while ((
$row oci_fetch_row($s)) != false)
54:     
var_dump($row);
55:
56:
// Clean up
57:
58:
$stmtarray = array(
59:     
"drop procedure imp_res_prefetch_proc",
60:     
"drop table imp_res_prefetch_tab_1",
61:     
"drop table imp_res_prefetch_tab_2"
62:
);
63:
64:
oci8_test_sql_execute($c$stmtarray);
65:
66:
?>
67:
===DONE===
68:

Expected

Test 1 - prefetch 0
bool(true)
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}
array(1) {
  [0]=>
  string(1) "t"
}
array(1) {
  [0]=>
  string(1) "u"
}
array(1) {
  [0]=>
  string(1) "v"
}

Test 1 - prefetch 1
bool(true)
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}
array(1) {
  [0]=>
  string(1) "t"
}
array(1) {
  [0]=>
  string(1) "u"
}
array(1) {
  [0]=>
  string(1) "v"
}

Test 1 - prefetch 2
bool(true)
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}
array(1) {
  [0]=>
  string(1) "t"
}
array(1) {
  [0]=>
  string(1) "u"
}
array(1) {
  [0]=>
  string(1) "v"
}
===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:50:22
  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:50:22
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- Test 1 - prefetch 0
002- bool(true)
003- array(2) {
004-   [0]=>
005-   string(1) "1"
006-   [1]=>
007-   string(5) "abcde"
008- }
009- array(2) {
010-   [0]=>
011-   string(1) "2"
012-   [1]=>
013-   string(5) "fghij"
014- }
015- array(2) {
016-   [0]=>
017-   string(1) "3"
018-   [1]=>
019-   string(5) "klmno"
020- }
021- array(1) {
022-   [0]=>
023-   string(1) "t"
024- }
025- array(1) {
026-   [0]=>
027-   string(1) "u"
028- }
029- array(1) {
030-   [0]=>
031-   string(1) "v"
032- }
033- 
034- Test 1 - prefetch 1
035- bool(true)
036- array(2) {
037-   [0]=>
038-   string(1) "1"
039-   [1]=>
040-   string(5) "abcde"
041- }
042- array(2) {
043-   [0]=>
044-   string(1) "2"
045-   [1]=>
046-   string(5) "fghij"
047- }
048- array(2) {
049-   [0]=>
050-   string(1) "3"
051-   [1]=>
052-   string(5) "klmno"
053- }
054- array(1) {
055-   [0]=>
056-   string(1) "t"
057- }
058- array(1) {
059-   [0]=>
060-   string(1) "u"
061- }
062- array(1) {
063-   [0]=>
064-   string(1) "v"
065- }
066- 
067- Test 1 - prefetch 2
068- bool(true)
069- array(2) {
070-   [0]=>
071-   string(1) "1"
072-   [1]=>
073-   string(5) "abcde"
074- }
075- array(2) {
076-   [0]=>
077-   string(1) "2"
078-   [1]=>
079-   string(5) "fghij"
080- }
081- array(2) {
082-   [0]=>
083-   string(1) "3"
084-   [1]=>
085-   string(5) "klmno"
086- }
087- array(1) {
088-   [0]=>
089-   string(1) "t"
090- }
091- array(1) {
092-   [0]=>
093-   string(1) "u"
094- }
095- array(1) {
096-   [0]=>
097-   string(1) "v"
098- }
099- ===DONE===

 

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

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