Annotation of embedaddon/php/ext/oci8/tests/bug42134.phpt, revision 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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>