Return to bug47189.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/bug47189.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #47189 (Multiple oci_fetch_all calls) 
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs: different error handling for this undefined behavior
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: echo "Test 1\n";
                     14: 
                     15: $s = oci_parse($c, "select * from dual");
                     16: oci_execute($s);
                     17: oci_fetch_all($s, $rs, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
                     18: var_dump($rs);
                     19: oci_fetch_all($s, $rs1, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
                     20: var_dump($rs1); 
                     21: 
                     22: echo "Test 2\n";
                     23: 
                     24: $s = oci_parse($c, "select * from dual");
                     25: oci_execute($s);
                     26: oci_fetch_all($s, $rs, 0, 1, OCI_FETCHSTATEMENT_BY_ROW);
                     27: var_dump($rs);
                     28: oci_fetch_all($s, $rs1, 0, 1, OCI_FETCHSTATEMENT_BY_ROW);
                     29: var_dump($rs1); 
                     30: 
                     31: ?>
                     32: ===DONE===
                     33: <?php exit(0); ?>
                     34: --EXPECTF--
                     35: Test 1
                     36: array(1) {
                     37:   [0]=>
                     38:   array(1) {
                     39:     ["DUMMY"]=>
                     40:     string(1) "X"
                     41:   }
                     42: }
                     43: array(0) {
                     44: }
                     45: Test 2
                     46: array(1) {
                     47:   [0]=>
                     48:   array(1) {
                     49:     ["DUMMY"]=>
                     50:     string(1) "X"
                     51:   }
                     52: }
                     53: 
                     54: Warning: oci_fetch_all(): ORA-01002: %s in %s on line %d
                     55: array(0) {
                     56: }
                     57: ===DONE===