Annotation of embedaddon/php/ext/oci8/tests/bug44113.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: Bug #44113 (New collection creation can fail with OCI-22303)
3: --SKIPIF--
4: <?php
5: $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
6: require(dirname(__FILE__).'/skipif.inc');
7: if (getenv('SKIP_SLOW_TESTS')) die('skip slow tests excluded by request');
8: ?>
9: --FILE--
10: <?php
11:
12: require(dirname(__FILE__).'/connect.inc');
13:
14: // Initialization
15:
16: $stmtarray = array(
17: "create or replace type bug44113_list_t as table of number"
18: );
19:
20: oci8_test_sql_execute($c, $stmtarray);
21:
22: // Run Test
23: // The test can take some time to complete and can exceed PHP's test
24: // timout limit on slow networks.
25:
26: for ($x = 0; $x < 70000; $x++) {
27: if (!($var = oci_new_collection($c, 'BUG44113_LIST_T'))) {
28: print "Failed new collection creation on $x\n";
29: break;
30: }
31: }
32:
33: print "Completed $x\n";
34:
35: // Cleanup
36:
37: $stmtarray = array(
38: "drop type bug44113_list_t"
39: );
40:
41: oci8_test_sql_execute($c, $stmtarray);
42:
43: echo "Done\n";
44:
45: ?>
46: --EXPECT--
47: Completed 70000
48: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>