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     ! 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===