[PHP-CVS] cvs: php-src(PHP_5_2) /ext/oci8/tests bug42134.phpt

[Antony Dovgal]

tony2001                Tue Jul 31 21:11:33 2007 UTC

  Added files:                 (Branch: PHP_5_2)
    /php-src/ext/oci8/tests     bug42134.phpt 
  Log:
  add test
  
  

http://cvs.php.net/viewvc.cgi/php-src/ext/oci8/tests/bug42134.phpt?view=markup&rev=1.1
Index: php-src/ext/oci8/tests/bug42134.phpt
+++ php-src/ext/oci8/tests/bug42134.phpt
--TEST--
Bug #42134 (Collection error for invalid collection name)
--SKIPIF--
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
--FILE--
<?php

require(dirname(__FILE__).'/details.inc');

// Test collection creation error for normal connection

if (!empty($dbase)) {
        $c = oci_connect($user,$password,$dbase);
}
else {
        $c = oci_connect($user,$password);
}

$collection = oci_new_collection($c, "ABC");
if (!$collection) {
        echo "Normal connection: New Collection error\n";
        $m = oci_error($c);
        var_dump($m);
}

// Test collection creation error for new connection

if (!empty($dbase)) {
        $c = oci_new_connect($user,$password,$dbase);
}
else {
        $c = oci_new_connect($user,$password);
}

$collection = oci_new_collection($c, "DEF");
if (!$collection) {
        echo "New connection: New Collection error\n";
        $m = oci_error($c);
        var_dump($m);
}

// Test collection creation error for persistent connection

if (!empty($dbase)) {
        $c = oci_pconnect($user,$password,$dbase);
}
else {
        $c = oci_pconnect($user,$password);
}

$collection = oci_new_collection($c, "GHI");
if (!$collection) {
        echo "Persistent connection: New Collection error\n";
        $m = oci_error($c);
        var_dump($m);
}

echo "Done\n";

?>
--EXPECTF--
Warning: oci_new_collection(): OCI-22303: type ""."ABC" not found in %s on line 
%d
Normal connection: New Collection error
array(4) {
  ["code"]=>
  int(22303)
  ["message"]=>
  string(34) "OCI-22303: type ""."ABC" not found"
  ["offset"]=>
  int(0)
  ["sqltext"]=>
  string(0) ""
}

Warning: oci_new_collection(): OCI-22303: type ""."DEF" not found in %s on line 
%d
New connection: New Collection error
array(4) {
  ["code"]=>
  int(22303)
  ["message"]=>
  string(34) "OCI-22303: type ""."DEF" not found"
  ["offset"]=>
  int(0)
  ["sqltext"]=>
  string(0) ""
}

Warning: oci_new_collection(): OCI-22303: type ""."GHI" not found in %s on line 
%d
Persistent connection: New Collection error
array(4) {
  ["code"]=>
  int(22303)
  ["message"]=>
  string(34) "OCI-22303: type ""."GHI" not found"
  ["offset"]=>
  int(0)
  ["sqltext"]=>
  string(0) ""
}
Done
--UEXPECTF--
Warning: oci_new_collection(): OCI-22303: type ""."ABC" not found in %s on line 
%d
Normal connection: New Collection error
array(4) {
  [u"code"]=>
  int(22303)
  [u"message"]=>
  unicode(34) "OCI-22303: type ""."ABC" not found"
  [u"offset"]=>
  int(0)
  [u"sqltext"]=>
  unicode(0) ""
}

Warning: oci_new_collection(): OCI-22303: type ""."DEF" not found in %s on line 
%d
New connection: New Collection error
array(4) {
  [u"code"]=>
  int(22303)
  [u"message"]=>
  unicode(34) "OCI-22303: type ""."DEF" not found"
  [u"offset"]=>
  int(0)
  [u"sqltext"]=>
  unicode(0) ""
}

Warning: oci_new_collection(): OCI-22303: type ""."GHI" not found in %s on line 
%d
Persistent connection: New Collection error
array(4) {
  [u"code"]=>
  int(22303)
  [u"message"]=>
  unicode(34) "OCI-22303: type ""."GHI" not found"
  [u"offset"]=>
  int(0)
  [u"sqltext"]=>
  unicode(0) ""
}
Done

-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php