#49803 [NEW]: OCI statement cache causes ORA-01007

From: stronk7 at moodle dot org Operating system: MacOS X (any) PHP version: 5.2.11 PHP Bug Type: OCI8 related Bug description: OCI statement cache causes ORA-01007 Description: ------------ Under certain circumstances (multiple DDL creation) OCI client statement cache causes ORA-01007: variable not in select list error in simple queries against those tables. Only disabling the cache ( oci8.statement_cache_size = 0 in php.ini, from default 20) alleviates the problem. Running with cache disabled has a big impact in oci performance. It should be some explicit way to clean the cache from php oci or the driver itself should be "clever enough" to clean it when DDL statements are executed. Reproduce code: --------------- http://tracker.moodle.org/secure/attachment/18556/testing_oci_stmt_cache_pureoci.php Expected result: ---------------- TESTING MOODLE 2.0 OCI DRIVER WITH oci8.statement_cache_size = 0 (from php.ini) Created table unit_table (id, course, name). Ok Selected 0 records from table. Ok Dropped table unit_table (id, course, name). Ok Created table unit_table (id, course). Ok Selected 0 records from table. Ok Dropped table unit_table (id, course). Ok Actual result: -------------- TESTING MOODLE 2.0 OCI DRIVER WITH oci8.statement_cache_size = 20 (from php.ini) Created table unit_table (id, course, name). Ok Selected 0 records from table. Ok Dropped table unit_table (id, course, name). Ok Created table unit_table (id, course). Ok Error selecting records from table!! ORA-01007: variable not in select list Dropped table unit_table (id, course). Ok -- Edit bug report at http://bugs.php.net/?id=49803&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=49803&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=49803&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=49803&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=49803&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=49803&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=49803&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=49803&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=49803&r=needscript Try newer version: http://bugs.php.net/fix.php?id=49803&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=49803&r=support Expected behavior: http://bugs.php.net/fix.php?id=49803&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=49803&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=49803&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=49803&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49803&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=49803&r=dst IIS Stability: http://bugs.php.net/fix.php?id=49803&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=49803&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=49803&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=49803&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=49803&r=mysqlcfg