Return to coll_019.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Test collection Oracle error handling collections and numbers (2)
                      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: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      9: require(dirname(__FILE__).'/skipif.inc');
                     10: ?> 
                     11: --FILE--
                     12: <?php
                     13: 
                     14: require dirname(__FILE__)."/connect.inc";
                     15: 
                     16: $ora_sql = "DROP TYPE ".$type_name;;
                     17: $statement = oci_parse($c,$ora_sql);
                     18: @oci_execute($statement);
                     19: 
                     20: 
                     21: echo "Test 0\n";
                     22: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF BLOB";
                     23: $statement = oci_parse($c,$ora_sql);
                     24: oci_execute($statement);
                     25: 
                     26: $coll1 = oci_new_collection($c, $type_name);
                     27: 
                     28: var_dump($coll1->append('a long string'));              // invalid type for append
                     29: var_dump($coll1->assignElem(1, 'a long string'));      // invalid type for assignelem()
                     30: var_dump($coll1->getElem(0));
                     31: 
                     32: require dirname(__FILE__)."/drop_type.inc";
                     33: 
                     34: echo "Test 1\n";
                     35: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER";
                     36: $statement = oci_parse($c,$ora_sql);
                     37: oci_execute($statement);
                     38: 
                     39: $coll1 = oci_new_collection($c, $type_name);
                     40: 
                     41: var_dump($coll1->assignElem(1, null));                 // invalid location for null
                     42: var_dump($coll1->getElem(0));
                     43: 
                     44: echo "Test 2\n";
                     45: var_dump($coll1->assignElem(1, 1234));                 // invalid location for number
                     46: var_dump($coll1->getElem(0));
                     47: 
                     48: require dirname(__FILE__)."/drop_type.inc";
                     49: 
                     50: echo "Test 3\n";
                     51: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR2(1)";
                     52: $statement = oci_parse($c,$ora_sql);
                     53: oci_execute($statement);
                     54: 
                     55: $coll1 = oci_new_collection($c, $type_name);
                     56: 
                     57: var_dump($coll1->assignElem(1, 'abc'));                // invalid location for string
                     58: var_dump($coll1->getElem(0));
                     59: 
                     60: require dirname(__FILE__)."/drop_type.inc";
                     61: 
                     62: echo "Test 4\n";
                     63: $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE";
                     64: $statement = oci_parse($c,$ora_sql);
                     65: oci_execute($statement);
                     66: 
                     67: $coll1 = oci_new_collection($c, $type_name);
                     68: 
                     69: var_dump($coll1->append(1));                                   // invalid date format
                     70: var_dump($coll1->assignElem(1, '01-JAN-06'));                  // invalid location for date
                     71: var_dump($coll1->getElem(0));
                     72: 
                     73: require dirname(__FILE__)."/drop_type.inc";
                     74: 
                     75: echo "Done\n";
                     76: 
                     77: ?>
                     78: --EXPECTF--
                     79: Test 0
                     80: 
                     81: Notice: OCI-Collection::append(): Unknown or unsupported type of element: 113 in %s on line %d
                     82: bool(false)
                     83: 
                     84: Notice: OCI-Collection::assignelem(): Unknown or unsupported type of element: 113 in %s on line %d
                     85: bool(false)
                     86: bool(false)
                     87: Test 1
                     88: 
                     89: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
                     90: bool(false)
                     91: bool(false)
                     92: Test 2
                     93: 
                     94: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
                     95: bool(false)
                     96: bool(false)
                     97: Test 3
                     98: 
                     99: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
                    100: bool(false)
                    101: bool(false)
                    102: Test 4
                    103: 
                    104: Warning: OCI-Collection::append(): OCI-01840: input value not long enough for date format in %s on line %d
                    105: bool(false)
                    106: 
                    107: Warning: OCI-Collection::assignelem(): OCI-22165: given index [1] must be in the range of %s in %s on line %d
                    108: bool(false)
                    109: bool(false)
                    110: Done