Return to bug42134.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Bug #42134 (Collection error for invalid collection name)
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/details.inc');
                     12: 
                     13: // Test collection creation error for normal connection
                     14: 
                     15: if (!empty($dbase)) {
                     16:        $c = oci_connect($user,$password,$dbase);
                     17: }
                     18: else {
                     19:        $c = oci_connect($user,$password);
                     20: }
                     21: 
                     22: $collection = oci_new_collection($c, "ABC");
                     23: if (!$collection) {
                     24:        echo "Normal connection: New Collection error\n";
                     25:        $m = oci_error($c);
                     26:        var_dump($m);
                     27: }
                     28: 
                     29: // Test collection creation error for new connection
                     30: 
                     31: if (!empty($dbase)) {
                     32:        $c = oci_new_connect($user,$password,$dbase);
                     33: }
                     34: else {
                     35:        $c = oci_new_connect($user,$password);
                     36: }
                     37: 
                     38: $collection = oci_new_collection($c, "DEF");
                     39: if (!$collection) {
                     40:        echo "New connection: New Collection error\n";
                     41:        $m = oci_error($c);
                     42:        var_dump($m);
                     43: }
                     44: 
                     45: // Test collection creation error for persistent connection
                     46: 
                     47: if (!empty($dbase)) {
                     48:        $c = oci_pconnect($user,$password,$dbase);
                     49: }
                     50: else {
                     51:        $c = oci_pconnect($user,$password);
                     52: }
                     53: 
                     54: $collection = oci_new_collection($c, "GHI");
                     55: if (!$collection) {
                     56:        echo "Persistent connection: New Collection error\n";
                     57:        $m = oci_error($c);
                     58:        var_dump($m);
                     59: }
                     60: 
                     61: echo "Done\n";
                     62: 
                     63: ?>
                     64: --EXPECTF--
                     65: Warning: oci_new_collection(): OCI-22303: type ""."ABC" not found in %s on line %d
                     66: Normal connection: New Collection error
                     67: array(4) {
                     68:   ["code"]=>
                     69:   int(22303)
                     70:   ["message"]=>
                     71:   string(34) "OCI-22303: type ""."ABC" not found"
                     72:   ["offset"]=>
                     73:   int(0)
                     74:   ["sqltext"]=>
                     75:   string(0) ""
                     76: }
                     77: 
                     78: Warning: oci_new_collection(): OCI-22303: type ""."DEF" not found in %s on line %d
                     79: New connection: New Collection error
                     80: array(4) {
                     81:   ["code"]=>
                     82:   int(22303)
                     83:   ["message"]=>
                     84:   string(34) "OCI-22303: type ""."DEF" not found"
                     85:   ["offset"]=>
                     86:   int(0)
                     87:   ["sqltext"]=>
                     88:   string(0) ""
                     89: }
                     90: 
                     91: Warning: oci_new_collection(): OCI-22303: type ""."GHI" not found in %s on line %d
                     92: Persistent connection: New Collection error
                     93: array(4) {
                     94:   ["code"]=>
                     95:   int(22303)
                     96:   ["message"]=>
                     97:   string(34) "OCI-22303: type ""."GHI" not found"
                     98:   ["offset"]=>
                     99:   int(0)
                    100:   ["sqltext"]=>
                    101:   string(0) ""
                    102: }
                    103: Done