Test Improvements

gistfile1.diff

--- before.log	2015-06-27 02:42:23.987409298 -0500
+++ after.log	2015-06-27 02:16:23.495463595 -0500
@@ -1,251 +1,179 @@
 =====================================================================
 Number of tests :  353               295
 Tests skipped   :   58 ( 16.4%) --------
 Tests warned    :    0 (  0.0%) (  0.0%)
-Tests failed    :  236 ( 66.9%) ( 80.0%)
+Tests failed    :  164 ( 46.5%) ( 55.6%)
 Expected fail   :    0 (  0.0%) (  0.0%)
-Tests passed    :   59 ( 16.7%) ( 20.0%)
+Tests passed    :  131 ( 37.1%) ( 44.4%)
 ---------------------------------------------------------------------
-Time taken      : 1198 seconds
+Time taken      :  234 seconds
 =====================================================================
 
 =====================================================================
 FAILED TEST SUMMARY
 ---------------------------------------------------------------------
-oci_bind_array_by_name() and invalid values 5 [ext/oci8/tests/array_bind_005.phpt]
-oci_bind_array_by_name(), SQLT_CHR and default max_length [ext/oci8/tests/array_bind_006.phpt]
-oci_bind_array_by_name() and invalid values 8 [ext/oci8/tests/array_bind_010.phpt]
-oci_bind_array_by_name(), SQLT_CHR, default max_length and empty array [ext/oci8/tests/array_bind_012.phpt]
-oci_bind_array_by_name(), SQLT_CHR, default max_length and empty array [ext/oci8/tests/array_bind_013.phpt]
-oci_bind_array_by_name() and NUMBERs [ext/oci8/tests/array_bind_014.phpt]
-oci_bind_array_by_name() and SQLT_ODT [ext/oci8/tests/array_bind_date.phpt]
-oci_bind_array_by_name() and SQLT_ODT [ext/oci8/tests/array_bind_date1.phpt]
-oci_bind_array_by_name() and SQLT_FLT [ext/oci8/tests/array_bind_float.phpt]
-oci_bind_array_by_name() and SQLT_FLT [ext/oci8/tests/array_bind_float1.phpt]
-oci_bind_array_by_name() and SQLT_INT [ext/oci8/tests/array_bind_int.phpt]
-oci_bind_array_by_name() and SQLT_INT [ext/oci8/tests/array_bind_int1.phpt]
-oci_bind_array_by_name() and SQLT_CHR [ext/oci8/tests/array_bind_str.phpt]
-oci_bind_array_by_name() and SQLT_CHR [ext/oci8/tests/array_bind_str1.phpt]
-Bug #47243 (Crash on exit with ZTS mode) [ext/oci8/tests/b47243_1.phpt]
-Bug #47243 (Crash on exit with ZTS mode) [ext/oci8/tests/b47243_2.phpt]
-Bug #47243 (Crash on exit with ZTS mode) [ext/oci8/tests/b47243_3.phpt]
 SELECT oci_bind_by_name with SQLT_AFC aka CHAR [ext/oci8/tests/bind_char_1_11gR1.phpt]
 SELECT oci_bind_by_name with SQLT_AFC aka CHAR and dates [ext/oci8/tests/bind_char_2_11gR1.phpt]
 PL/SQL oci_bind_by_name with SQLT_AFC aka CHAR to CHAR parameter [ext/oci8/tests/bind_char_3_11gR1.phpt]
 PL/SQL oci_bind_by_name with SQLT_AFC aka CHAR to VARCHAR2 parameter [ext/oci8/tests/bind_char_4_11gR1.phpt]
 binding empty values [ext/oci8/tests/bind_empty.phpt]
 bind LONG field [ext/oci8/tests/bind_long.phpt]
 bind LONG RAW field [ext/oci8/tests/bind_long_raw.phpt]
 Bind miscellaneous column types using default types [ext/oci8/tests/bind_misccoltypes.phpt]
 Bind miscellaneous column types and generating errors [ext/oci8/tests/bind_misccoltypes_errs.phpt]
 Bind with NUMBER column variants [ext/oci8/tests/bind_number.phpt]
 Bind with various WHERE conditions [ext/oci8/tests/bind_query.phpt]
 bind RAW field [ext/oci8/tests/bind_raw.phpt]
 bind RAW field with OCI_B_BIN [ext/oci8/tests/bind_raw_2.phpt]
 Test ROWID bind [ext/oci8/tests/bind_rowid.phpt]
 Bind tests with SQLT_AFC [ext/oci8/tests/bind_sqltafc.phpt]
 Bind with SQLT_CHR [ext/oci8/tests/bind_sqltchr_1.phpt]
 PL/SQL bind with SQLT_CHR [ext/oci8/tests/bind_sqltchr_2.phpt]
 Bind with SQLT_INT [ext/oci8/tests/bind_sqltint.phpt]
 Bind with SQLT_NUM [ext/oci8/tests/bind_sqltnum.phpt]
 Bug #26133 (ocifreedesc() segfault) [ext/oci8/tests/bug26133.phpt]
 Bug #27303 (OCIBindByName binds numeric PHP values as characters) [ext/oci8/tests/bug27303_1_11gR1.phpt]
 Bug #27303 (OCIBindByName binds numeric PHP values as characters) [ext/oci8/tests/bug27303_2_11gR1.phpt]
 Bug #27303 (OCIBindByName binds numeric PHP values as characters) [ext/oci8/tests/bug27303_3.phpt]
 Bug #27303 (OCIBindByName binds numeric PHP values as characters) [ext/oci8/tests/bug27303_4_11gR1.phpt]
 Bug #32325 (Cannot retrieve collection using OCI8) [ext/oci8/tests/bug32325.phpt]
 Bug #35973 (Error ORA-24806 occurs when trying to fetch a NCLOB field) [ext/oci8/tests/bug35973.phpt]
 Bug #36010 (Crash when executing SQL statement with lob parameter twice) [ext/oci8/tests/bug36010.phpt]
-Bug #36096 (oci_result() returns garbage after oci_fetch() failed) [ext/oci8/tests/bug36096.phpt]
-Bug #36403 (oci_execute no longer supports OCI_DESCRIBE_ONLY) [ext/oci8/tests/bug36403.phpt]
 Bug #37220 (LOB Type mismatch when using windows & oci8.dll) [ext/oci8/tests/bug37220.phpt]
 Bug #37581 (oci_bind_array_by_name clobbers input array when using SQLT_AFC, AVC) [ext/oci8/tests/bug37581.phpt]
 Bug #38161 (oci_bind_by_name() returns garbage when Oracle didn't set the variable) [ext/oci8/tests/bug38161.phpt]
-Bug #38173 (Freeing nested cursors causes OCI8 to segfault) [ext/oci8/tests/bug38173.phpt]
-Bug #40078 (ORA-01405 when fetching NULL values using oci_bind_array_by_name()) [ext/oci8/tests/bug40078.phpt]
-Bug #40415 (Using oci_fetchall with nested cursors) [ext/oci8/tests/bug40415.phpt]
-Bug #41069 (Oracle crash with certain data over a DB-link when prefetch memory limit used - Oracle bug 6039623) [ext/oci8/tests/bug41069.phpt]
-Bug #42173 (TIMESTAMP and INTERVAL query and field functions) [ext/oci8/tests/bug42173.phpt]
 Bug #42496 (LOB fetch leaks cursors, eventually failing with ORA-1000 maximum open cursors reached) [ext/oci8/tests/bug42496_1.phpt]
 Bug #42496 (LOB fetch leaks cursors, eventually failing with ORA-1000 maximum open cursors reached) [ext/oci8/tests/bug42496_2.phpt]
 Bug #42841 (REF CURSOR and oci_new_cursor PHP crash) [ext/oci8/tests/bug42841.phpt]
 Bug #43492 (Nested cursor leaks) [ext/oci8/tests/bug43492.phpt]
 Bug #43492 (Nested cursor leaks after related bug #44206 fixed) [ext/oci8/tests/bug43492_2.phpt]
 Bug #43497 (OCI8 XML/getClobVal aka temporary LOBs leak UGA memory) [ext/oci8/tests/bug43497.phpt]
 Bug #44008 (Incorrect usage of OCI-Lob->close crashes PHP) [ext/oci8/tests/bug44008.phpt]
 Bug #44113 (New collection creation can fail with OCI-22303) [ext/oci8/tests/bug44113.phpt]
-Bug #44206 (Test if selecting ref cursors leads to ORA-1000 maximum open cursors reached) [ext/oci8/tests/bug44206.phpt]
 Bug #45458 (OCI8: Numeric keys for associative arrays are not handled properly) [ext/oci8/tests/bug45458.phpt]
 Bug #46994 (CLOB size does not update when using CLOB IN OUT param in stored procedure) [ext/oci8/tests/bug46994.phpt]
-Bug #47189 (Multiple oci_fetch_all calls) [ext/oci8/tests/bug47189.phpt]
 Bug #51253 (oci_bind_array_by_name() array references) [ext/oci8/tests/bug51253.phpt]
-Bug #51291 (oci_error() doesn't report last error when called two times) [ext/oci8/tests/bug51291_1.phpt]
 Bug #51291 (oci_error() doesn't report last error when called two times) [ext/oci8/tests/bug51291_2.phpt]
 oci_new_collection() + free() [ext/oci8/tests/coll_002.phpt]
 oci_new_collection() + free() [ext/oci8/tests/coll_002_func.phpt]
 collection methods [ext/oci8/tests/coll_003.phpt]
 collection methods [ext/oci8/tests/coll_003_func.phpt]
 oci_collection_assign() [ext/oci8/tests/coll_004.phpt]
 oci_collection_assign() [ext/oci8/tests/coll_004_func.phpt]
 ocinewcollection() + free() [ext/oci8/tests/coll_006.phpt]
 ocinewcollection() + free() [ext/oci8/tests/coll_006_func.phpt]
 collection methods [ext/oci8/tests/coll_007.phpt]
 ocicollassign() [ext/oci8/tests/coll_008.phpt]
 collections and wrong dates [ext/oci8/tests/coll_009.phpt]
 collections and wrong dates [ext/oci8/tests/coll_009_func.phpt]
 collections and nulls [ext/oci8/tests/coll_010.phpt]
 collections and nulls [ext/oci8/tests/coll_010_func.phpt]
 collections and strings [ext/oci8/tests/coll_011.phpt]
 collections and strings [ext/oci8/tests/coll_011_func.phpt]
 collections and correct dates [ext/oci8/tests/coll_012.phpt]
 collections and correct dates [ext/oci8/tests/coll_012_func.phpt]
 collections and correct dates (2) [ext/oci8/tests/coll_013.phpt]
 collections and correct dates (2) [ext/oci8/tests/coll_013_func.phpt]
 collections and strings (2) [ext/oci8/tests/coll_014.phpt]
 collections and strings (2) [ext/oci8/tests/coll_014_func.phpt]
 collections and numbers (2) [ext/oci8/tests/coll_015.phpt]
 collections and numbers (2) [ext/oci8/tests/coll_015_func.phpt]
 collections and negative/too big element indexes [ext/oci8/tests/coll_016.phpt]
 collections and negative/too big element indexes [ext/oci8/tests/coll_016_func.phpt]
 collections and nulls (2) [ext/oci8/tests/coll_017.phpt]
 collections and nulls (2) [ext/oci8/tests/coll_017_func.phpt]
 Collection trim tests [ext/oci8/tests/coll_018.phpt]
 Test collection Oracle error handling collections and numbers (2) [ext/oci8/tests/coll_019.phpt]
 Test OCI_NO_AUTO_COMMIT constant [ext/oci8/tests/commit_001.phpt]
 ocicommit()/ocirollback() [ext/oci8/tests/commit_old.phpt]
-Set and get of connection attributes with all types of connections. [ext/oci8/tests/conn_attr_1.phpt]
 Set and get of connection attributes across persistent connections and sysdba connection. [ext/oci8/tests/conn_attr_2.phpt]
 Set and get of connection attributes with oci_close(). [ext/oci8/tests/conn_attr_3.phpt]
-Set and get of connection attributes with errors. [ext/oci8/tests/conn_attr_4.phpt]
-Set and get connection attributes with scope end. [ext/oci8/tests/conn_attr_5.phpt]
-Test oci_connect end-of-scope when statement returned [ext/oci8/tests/connect_scope1.phpt]
-Test oci_pconnect end-of-scope when statement returned [ext/oci8/tests/connect_scope2.phpt]
-Check oci_connect try/catch end-of-scope with old_oci_close_semantics Off [ext/oci8/tests/connect_scope_try1.phpt]
-Check oci_connect try/catch end-of-scope with old_oci_close_semantics On [ext/oci8/tests/connect_scope_try2.phpt]
-Check oci_new_connect try/catch end-of-scope with old_oci_close_semantics Off [ext/oci8/tests/connect_scope_try3.phpt]
-Check oci_new_connect try/catch end-of-scope with old_oci_close_semantics On [ext/oci8/tests/connect_scope_try4.phpt]
-Check oci_pconnect try/catch end-of-scope with old_oci_close_semantics Off [ext/oci8/tests/connect_scope_try5.phpt]
-Check oci_pconnect try/catch end-of-scope with old_oci_close_semantics On [ext/oci8/tests/connect_scope_try6.phpt]
 oci_connect() with invalid character set [ext/oci8/tests/connect_with_charset_001.phpt]
 bind and fetch cursor from a statement [ext/oci8/tests/cursor_bind.phpt]
 binding a cursor (with errors) [ext/oci8/tests/cursor_bind_err.phpt]
 fetching cursor from a statement [ext/oci8/tests/cursors.phpt]
 fetching cursor from a statement [ext/oci8/tests/cursors_old.phpt]
 PL/SQL: dbms_output [ext/oci8/tests/dbmsoutput.phpt]
-oci8.default_prefetch ini option [ext/oci8/tests/default_prefetch.phpt]
-oci8.default_prefetch ini option [ext/oci8/tests/default_prefetch0.phpt]
-oci8.default_prefetch ini option [ext/oci8/tests/default_prefetch1.phpt]
-oci8.default_prefetch ini option [ext/oci8/tests/default_prefetch2.phpt]
 oci_define_by_name() [ext/oci8/tests/define.phpt]
 oci_define_by_name() [ext/oci8/tests/define0.phpt]
 oci_define_by_name() [ext/oci8/tests/define1.phpt]
 Test oci_define_by_name types [ext/oci8/tests/define2.phpt]
 Test oci_define_by_name() LOB descriptor [ext/oci8/tests/define3.phpt]
 oci_define_by_name() on partial number of columns [ext/oci8/tests/define4.phpt]
 oci_define_by_name() for statement re-execution [ext/oci8/tests/define5.phpt]
 oci_define_by_name tests with REF CURSORs [ext/oci8/tests/define6.phpt]
 ocidefinebyname() [ext/oci8/tests/define_old.phpt]
 commit connection after destroying the descriptor [ext/oci8/tests/descriptors.phpt]
 DRCP: oci_connect() with oci_close() and oci8.old_oci_close_semantics ON [ext/oci8/tests/drcp_conn_close1.phpt]
 DRCP: oci_connect() [ext/oci8/tests/drcp_connect1.phpt]
 DRCP: oci_pconnect() with oci_close() and oci8.old_oci_close_semantics ON [ext/oci8/tests/drcp_pconn_close1.phpt]
-DRCP: oci_new_connect() and oci_connect() with scope end when oci8.old_oci_close_semantics ON [ext/oci8/tests/drcp_scope1.phpt]
-DRCP: oci_new_connect() and oci_connect with scope end when oci8.old_oci_close_semantics OFF [ext/oci8/tests/drcp_scope2.phpt]
-DRCP: oci_pconnect() with scope end when oci8.old_oci_close_semantics ON [ext/oci8/tests/drcp_scope3.phpt]
-DRCP: oci_pconnect() with scope end when oci8.old_oci_close_semantics OFF [ext/oci8/tests/drcp_scope4.phpt]
-DRCP: oci_pconnect() with scope end when oci8.old_oci_close_semantics ON [ext/oci8/tests/drcp_scope5.phpt]
-Verify that the Driver Name attribute is set [ext/oci8/tests/driver_name.phpt]
-SELECT tests with duplicate column anmes [ext/oci8/tests/dupcolnames.phpt]
-Basic test for setting Oracle 11gR2 "edition" attribute [ext/oci8/tests/edition_1.phpt]
-Set and check Oracle 11gR2 "edition" attribute [ext/oci8/tests/edition_2.phpt]
 Test some oci_bind_by_name error conditions [ext/oci8/tests/error_bind.phpt]
-ocifetch() & ociresult() [ext/oci8/tests/fetch.phpt]
-oci_fetch_all() [ext/oci8/tests/fetch_all.phpt]
-oci_fetch_all() [ext/oci8/tests/fetch_all1.phpt]
 oci_fetch_all() - 2 [ext/oci8/tests/fetch_all2.phpt]
 oci_fetch_all() - all combinations of flags [ext/oci8/tests/fetch_all3.phpt]
-Test oci_fetch_* array overwriting when query returns no rows [ext/oci8/tests/fetch_all4.phpt]
-Test oci_fetch_all with 0 and -1 skip & maxrows [ext/oci8/tests/fetch_all5.phpt]
 oci_fetch_array() [ext/oci8/tests/fetch_array.phpt]
-oci_fetch_assoc() [ext/oci8/tests/fetch_assoc.phpt]
 ocifetchinto() [ext/oci8/tests/fetch_into.phpt]
 various ocifetchinto() tests [ext/oci8/tests/fetch_into1.phpt]
 ocifetchinto() & wrong number of params [ext/oci8/tests/fetch_into2.phpt]
-oci_fetch_object() [ext/oci8/tests/fetch_object.phpt]
-oci_fetch_object() [ext/oci8/tests/fetch_object_1.phpt]
 oci_fetch_object() with CLOB and NULL [ext/oci8/tests/fetch_object_2.phpt]
-oci_fetch_row() [ext/oci8/tests/fetch_row.phpt]
-oci_field_*() family [ext/oci8/tests/field_funcs.phpt]
-oci_field_*() family [ext/oci8/tests/field_funcs0.phpt]
-oci_field_*() family: error cases [ext/oci8/tests/field_funcs1.phpt]
-Bug #41917 (invalid scale and precision) [ext/oci8/tests/field_funcs2.phpt]
-oci_field_*() family: basic column types [ext/oci8/tests/field_funcs3.phpt]
 ocicolumn*() family [ext/oci8/tests/field_funcs_old.phpt]
 oci_lob_write() and friends [ext/oci8/tests/lob_001.phpt]
 oci_lob_write() and friends (with errors) [ext/oci8/tests/lob_002.phpt]
 oci_lob_read() and friends [ext/oci8/tests/lob_003.phpt]
 oci_lob_seek()/rewind()/append() [ext/oci8/tests/lob_004.phpt]
 oci_lob_is_equal() [ext/oci8/tests/lob_005.phpt]
 oci_lob_write()/truncate()/erase() [ext/oci8/tests/lob_006.phpt]
 oci_lob_write()/size()/load() [ext/oci8/tests/lob_007.phpt]
 oci_lob_write()/read()/eof() [ext/oci8/tests/lob_008.phpt]
 oci_lob_import()/read() [ext/oci8/tests/lob_009.phpt]
 oci_lob_save() [ext/oci8/tests/lob_010.phpt]
 oci_lob_copy() [ext/oci8/tests/lob_011.phpt]
 oci_lob_export() [ext/oci8/tests/lob_012.phpt]
 lob buffering [ext/oci8/tests/lob_013.phpt]
 oci_lob_free()/close() [ext/oci8/tests/lob_014.phpt]
 various tests with wrong param count [ext/oci8/tests/lob_015.phpt]
 returning multiple lobs [ext/oci8/tests/lob_016.phpt]
 returning multiple lobs (using persistent connection) [ext/oci8/tests/lob_017.phpt]
 fetching the same lob several times [ext/oci8/tests/lob_018.phpt]
 oci_lob_write()/erase()/read() with BLOBs [ext/oci8/tests/lob_019.phpt]
 oci_lob_write()/erase()/read() with CLOBs [ext/oci8/tests/lob_020.phpt]
 oci_lob_free()/close() [ext/oci8/tests/lob_021.phpt]
 fetching the same lob several times [ext/oci8/tests/lob_022.phpt]
 oci_lob_import()/read() [ext/oci8/tests/lob_023.phpt]
 oci_lob_load() [ext/oci8/tests/lob_024.phpt]
 oci_lob_read() tests [ext/oci8/tests/lob_025.phpt]
 oci_lob_seek()/rewind()/append() [ext/oci8/tests/lob_026.phpt]
 oci_lob_truncate() [ext/oci8/tests/lob_027.phpt]
 Test piecewise fetch of CLOBs equal to, and larger than PHP_OCI_LOB_BUFFER_SIZE [ext/oci8/tests/lob_030.phpt]
 Test LOB->read(), LOB->seek() and LOB->tell() with nul bytes in data [ext/oci8/tests/lob_031.phpt]
 oci_lob_write() and friends [ext/oci8/tests/lob_032.phpt]
 various oci_lob_write() error messages [ext/oci8/tests/lob_033.phpt]
 lob buffering - 2 [ext/oci8/tests/lob_034.phpt]
 oci_lob_copy() - 2 [ext/oci8/tests/lob_035.phpt]
 Exercise cleanup code when LOB buffering is on [ext/oci8/tests/lob_036.phpt]
 Fetching two different lobs and using them after fetch [ext/oci8/tests/lob_037.phpt]
 Array fetch CLOB and BLOB [ext/oci8/tests/lob_038.phpt]
 Test CLOB->write() for multiple inserts [ext/oci8/tests/lob_039.phpt]
 Bug #37706 (Test LOB locator reuse. Extends simple test of lob_037.phpt) [ext/oci8/tests/lob_040.phpt]
 Check LOBS are valid after statement free [ext/oci8/tests/lob_041.phpt]
 Check various LOB error messages [ext/oci8/tests/lob_042.phpt]
 Bug #49560 (LOB resource destructor and refcount test) [ext/oci8/tests/lob_043.phpt]
 oci_lob_truncate() with default parameter value [ext/oci8/tests/lob_044.phpt]
 Test null data for CLOBs [ext/oci8/tests/lob_null.phpt]
 temporary lobs [ext/oci8/tests/lob_temp.phpt]
 closing temporary lobs [ext/oci8/tests/lob_temp1.phpt]
 Writing temporary lob before binding [ext/oci8/tests/lob_temp2.phpt]
 Null bytes in SQL statements [ext/oci8/tests/null_byte_2.phpt]
 Null bytes in SQL statements [ext/oci8/tests/null_byte_3.phpt]
-oci_num_*() family [ext/oci8/tests/num.phpt]
 oci_execute() segfault after repeated bind of LOB descriptor [ext/oci8/tests/oci_execute_segfault.phpt]
 oci8.old_oci_close_semantics Off [ext/oci8/tests/old_oci_close1.phpt]
 oci_password_change() for non-persistent connections [ext/oci8/tests/password.phpt]
 oci_password_change() for persistent connections [ext/oci8/tests/password_2.phpt]
 PECL Bug #10194 (segfault in Instant Client when memory_limit is reached inside the callback) [ext/oci8/tests/pecl_bug10194.phpt]
 PECL Bug #10194 (segfault in Instant Client when memory_limit is reached inside the callback) [ext/oci8/tests/pecl_bug10194_blob_64.phpt]
-PECL Bug #8816 (issue in php_oci_statement_fetch with more than one piecewise column) [ext/oci8/tests/pecl_bug8816.phpt]
-oci_set_prefetch() [ext/oci8/tests/prefetch.phpt]
-ocisetprefetch() [ext/oci8/tests/prefetch_old.phpt]
 Prefetch with REF cursor. Test different values for prefetch with oci_set_prefetch(). [ext/oci8/tests/refcur_prefetch_1.phpt]
 Prefetch with REF cursor. Test No 2 [ext/oci8/tests/refcur_prefetch_2.phpt]
 Prefetch with Nested cursors with INI setting. [ext/oci8/tests/refcur_prefetch_3.phpt]
 Prefetch with REF cursor. Test No 4 [ext/oci8/tests/refcur_prefetch_4.phpt]
-SELECTing NULL values [ext/oci8/tests/select_null.phpt]
-statement cache [ext/oci8/tests/statement_cache.phpt]
-uncommitted connection [ext/oci8/tests/uncommitted.phpt]
 Basic XMLType test [ext/oci8/tests/xmltype_01.phpt]
 Basic XMLType test #2 [ext/oci8/tests/xmltype_02.phpt]
 =====================================================================