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/fetch_all2.phpt ('oci_fetch_all() - 2')

Script

1: <?php
2:
3:
require dirname(__FILE__)."/connect.inc";
4: require 
dirname(__FILE__).'/create_table.inc';
5:
6:
$insert_sql "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (1,1)";
7:
8:
$s oci_parse($c$insert_sql);
9:
10: for (
$i 0$i<3$i++) {
11:     
oci_execute($s);
12: }
13:
14:
oci_commit($c);
15:
16:
$select_sql "SELECT * FROM ".$schema."".$table_name."";
17:
18:
$s oci_parse($c$select_sql);
19:
20:
oci_execute($s);
21:
var_dump(oci_fetch_all($s$all));
22:
var_dump($all);
23:
24:
oci_execute($s);
25:
var_dump(oci_fetch_all($s$all010OCI_FETCHSTATEMENT_BY_ROW));
26:
var_dump($all);
27:
28:
oci_execute($s);
29:
var_dump(oci_fetch_all($s$all, -1, -1OCI_FETCHSTATEMENT_BY_ROW));
30:
var_dump($all);
31:
32:
oci_execute($s);
33:
var_dump(oci_fetch_all($s$all02OCI_FETCHSTATEMENT_BY_ROW+OCI_NUM));
34:
var_dump($all);
35:
36:
oci_execute($s);
37:
var_dump(oci_fetch_all($s$all02OCI_NUM));
38:
var_dump($all);
39:
40:
oci_execute($s);
41:
var_dump(oci_fetch_all($s$all01OCI_BOTH));
42:
var_dump($all);
43:
44: require 
dirname(__FILE__).'/drop_table.inc';
45:     
46: echo 
"Done\n";
47:
?>
48:

Expected

int(3)
array(5) {
  ["ID"]=>
  array(3) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
    [2]=>
    string(1) "1"
  }
  ["VALUE"]=>
  array(3) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
    [2]=>
    string(1) "1"
  }
  ["BLOB"]=>
  array(3) {
    [0]=>
    NULL
    [1]=>
    NULL
    [2]=>
    NULL
  }
  ["CLOB"]=>
  array(3) {
    [0]=>
    NULL
    [1]=>
    NULL
    [2]=>
    NULL
  }
  ["STRING"]=>
  array(3) {
    [0]=>
    NULL
    [1]=>
    NULL
    [2]=>
    NULL
  }
}
int(3)
array(3) {
  [0]=>
  array(5) {
    ["ID"]=>
    string(1) "1"
    ["VALUE"]=>
    string(1) "1"
    ["BLOB"]=>
    NULL
    ["CLOB"]=>
    NULL
    ["STRING"]=>
    NULL
  }
  [1]=>
  array(5) {
    ["ID"]=>
    string(1) "1"
    ["VALUE"]=>
    string(1) "1"
    ["BLOB"]=>
    NULL
    ["CLOB"]=>
    NULL
    ["STRING"]=>
    NULL
  }
  [2]=>
  array(5) {
    ["ID"]=>
    string(1) "1"
    ["VALUE"]=>
    string(1) "1"
    ["BLOB"]=>
    NULL
    ["CLOB"]=>
    NULL
    ["STRING"]=>
    NULL
  }
}
int(0)
array(0) {
}
int(2)
array(2) {
  [0]=>
  array(5) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
    [2]=>
    NULL
    [3]=>
    NULL
    [4]=>
    NULL
  }
  [1]=>
  array(5) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
    [2]=>
    NULL
    [3]=>
    NULL
    [4]=>
    NULL
  }
}
int(2)
array(5) {
  [0]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
  }
  [1]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
  }
  [2]=>
  array(2) {
    [0]=>
    NULL
    [1]=>
    NULL
  }
  [3]=>
  array(2) {
    [0]=>
    NULL
    [1]=>
    NULL
  }
  [4]=>
  array(2) {
    [0]=>
    NULL
    [1]=>
    NULL
  }
}
int(1)
array(5) {
  [0]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  [1]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  [2]=>
  array(1) {
    [0]=>
    NULL
  }
  [3]=>
  array(1) {
    [0]=>
    NULL
  }
  [4]=>
  array(1) {
    [0]=>
    NULL
  }
}
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:37:59
  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:37:59
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- int(3)
002- array(5) {
003-   ["ID"]=>
004-   array(3) {
005-     [0]=>
006-     string(1) "1"
007-     [1]=>
008-     string(1) "1"
009-     [2]=>
010-     string(1) "1"
011-   }
012-   ["VALUE"]=>
013-   array(3) {
014-     [0]=>
015-     string(1) "1"
016-     [1]=>
017-     string(1) "1"
018-     [2]=>
019-     string(1) "1"
020-   }
021-   ["BLOB"]=>
022-   array(3) {
023-     [0]=>
024-     NULL
025-     [1]=>
026-     NULL
027-     [2]=>
028-     NULL
029-   }
030-   ["CLOB"]=>
031-   array(3) {
032-     [0]=>
033-     NULL
034-     [1]=>
035-     NULL
036-     [2]=>
037-     NULL
038-   }
039-   ["STRING"]=>
040-   array(3) {
041-     [0]=>
042-     NULL
043-     [1]=>
044-     NULL
045-     [2]=>
046-     NULL
047-   }
048- }
049- int(3)
050- array(3) {
051-   [0]=>
052-   array(5) {
053-     ["ID"]=>
054-     string(1) "1"
055-     ["VALUE"]=>
056-     string(1) "1"
057-     ["BLOB"]=>
058-     NULL
059-     ["CLOB"]=>
060-     NULL
061-     ["STRING"]=>
062-     NULL
063-   }
064-   [1]=>
065-   array(5) {
066-     ["ID"]=>
067-     string(1) "1"
068-     ["VALUE"]=>
069-     string(1) "1"
070-     ["BLOB"]=>
071-     NULL
072-     ["CLOB"]=>
073-     NULL
074-     ["STRING"]=>
075-     NULL
076-   }
077-   [2]=>
078-   array(5) {
079-     ["ID"]=>
080-     string(1) "1"
081-     ["VALUE"]=>
082-     string(1) "1"
083-     ["BLOB"]=>
084-     NULL
085-     ["CLOB"]=>
086-     NULL
087-     ["STRING"]=>
088-     NULL
089-   }
090- }
091- int(0)
092- array(0) {
093- }
094- int(2)
095- array(2) {
096-   [0]=>
097-   array(5) {
098-     [0]=>
099-     string(1) "1"
100-     [1]=>
101-     string(1) "1"
102-     [2]=>
103-     NULL
104-     [3]=>
105-     NULL
106-     [4]=>
107-     NULL
108-   }
109-   [1]=>
110-   array(5) {
111-     [0]=>
112-     string(1) "1"
113-     [1]=>
114-     string(1) "1"
115-     [2]=>
116-     NULL
117-     [3]=>
118-     NULL
119-     [4]=>
120-     NULL
121-   }
122- }
123- int(2)
124- array(5) {
125-   [0]=>
126-   array(2) {
127-     [0]=>
128-     string(1) "1"
129-     [1]=>
130-     string(1) "1"
131-   }
132-   [1]=>
133-   array(2) {
134-     [0]=>
135-     string(1) "1"
136-     [1]=>
137-     string(1) "1"
138-   }
139-   [2]=>
140-   array(2) {
141-     [0]=>
142-     NULL
143-     [1]=>
144-     NULL
145-   }
146-   [3]=>
147-   array(2) {
148-     [0]=>
149-     NULL
150-     [1]=>
151-     NULL
152-   }
153-   [4]=>
154-   array(2) {
155-     [0]=>
156-     NULL
157-     [1]=>
158-     NULL
159-   }
160- }
161- int(1)
162- array(5) {
163-   [0]=>
164-   array(1) {
165-     [0]=>
166-     string(1) "1"
167-   }
168-   [1]=>
169-   array(1) {
170-     [0]=>
171-     string(1) "1"
172-   }
173-   [2]=>
174-   array(1) {
175-     [0]=>
176-     NULL
177-   }
178-   [3]=>
179-   array(1) {
180-     [0]=>
181-     NULL
182-   }
183-   [4]=>
184-   array(1) {
185-     [0]=>
186-     NULL
187-   }
188- }
189- Done

 

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

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