Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
bug41996.phpt	491 B	-rw-rw-r--	2022-10-31 11:36
bug44301.phpt	811 B	-rw-rw-r--	2022-10-31 11:36
bug46274.phpt	1.46 KB	-rw-rw-r--	2022-10-31 11:36
bug46274_2.phpt	1.66 KB	-rw-rw-r--	2022-10-31 11:36
bug54379.phpt	1.12 KB	-rw-rw-r--	2022-10-31 11:36
bug57702.phpt	4.25 KB	-rw-rw-r--	2022-10-31 11:36
bug60994.phpt	4.71 KB	-rw-rw-r--	2022-10-31 11:36
bug_33707.phpt	697 B	-rw-rw-r--	2022-10-31 11:36
checkliveness.phpt	1.16 KB	-rw-rw-r--	2022-10-31 11:36
common.phpt	701 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_action.phpt	1.18 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_autocommit_1.phpt	1.65 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_autocommit_2.phpt	3.52 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_autocommit_3.phpt	1.29 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_case.phpt	1.81 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_client.phpt	975 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_client_identifier.phpt	1.38 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_client_info.phpt	1.27 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_drivername.phpt	420 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_module.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_nulls_1.phpt	1.38 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_prefetch_1.phpt	1.54 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_prefetch_2.phpt	1.18 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_server.phpt	856 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_class_constants.phpt	1.32 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_fread_1.phpt	5.19 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_quote1.phpt	2.54 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stmt_getcolumnmeta.phpt	10.35 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stream_1.phpt	3.38 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stream_2a.phpt	2.2 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stream_2b.phpt	1.82 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_templob_1.phpt	2.53 KB	-rw-rw-r--	2022-10-31 11:36
pecl_bug_11345.phpt	734 B	-rw-rw-r--	2022-10-31 11:36
pecl_bug_6364.phpt	1.55 KB	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
PDO OCI: Test to verify all implicitly created temporary LOB are cleaned up
--SKIPIF--
<?php
if (!extension_loaded('pdo') || !extension_loaded('pdo_oci')) die('skip not loaded');
require(__DIR__.'/../../pdo/tests/pdo_test.inc');
PDOTest::skip();
?>
--FILE--
<?PHP

require('ext/pdo/tests/pdo_test.inc');
$db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');

$clobquery1 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery2 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery3 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery4 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery5 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery6 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery7 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery8 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery9 = "select TO_CLOB('Hello World') CLOB_DATA from dual";
$clobquery10 = "select TO_CLOB('Hello World') CLOB_DATA from dual";

$stmt= $db->prepare($clobquery1);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery2);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery3);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery4);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery5);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery6);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery7);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery8);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery9);
$stmt->execute();
$row = $stmt->fetch();
$stmt= $db->prepare($clobquery10);
$stmt->execute();
$row = $stmt->fetch();

$query1 = "SELECT SYS_CONTEXT('USERENV', 'SID') SID FROM DUAL";

$stmt1 = $db->prepare($query1);
$stmt1->execute();

$row1 = $stmt1->fetch();
$sid_value = $row1[0];

$query2 = "SELECT (CACHE_LOBS+NOCACHE_LOBS+ABSTRACT_LOBS) FROM V\$TEMPORARY_LOBS WHERE SID = :SID_VALUE";

$stmt2 = $db->prepare($query2);
$stmt2->bindParam(':SID_VALUE', $sid_value);
$stmt2->execute();

$row2 = $stmt2->fetch();
/* 1 temporary LOB still exists in V$TEMPORARY_LOBS since the destructor of $stmt is not yet called by PHP */
if ($row2[0] > 1)
{
  echo "TEMP_LOB is not yet cleared!" . $row2[0] . "\n";
}
else
{
  echo "Success! All the temporary LOB in previously closed statements are properly cleaned.\n";
}

?>
--EXPECT--
Success! All the temporary LOB in previously closed statements are properly cleaned.