Skip to content

Instantly share code, notes, and snippets.

@camporter
Created June 27, 2015 07:48
Show Gist options
  • Save camporter/6e3761a098bf68d2986b to your computer and use it in GitHub Desktop.
Save camporter/6e3761a098bf68d2986b to your computer and use it in GitHub Desktop.
Test Improvements
--- 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]
=====================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment