ID: 49803
Updated by: sixd@php.net
Reported By: stronk7 at moodle dot org
-Status: Assigned
+Status: Feedback
Bug Type: OCI8 related
Operating System: MacOS X (any)
PHP Version: 5.2.11
Assigned To: sixd
New Comment:
What's the testcase?
Previous Comments:
------------------------------------------------------------------------
[2009-10-07 16:29:46] stronk7 at moodle dot org
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 this bug report at http://bugs.php.net/?id=49803&edit=1