Gecko [ www.ctm-euromeuble.fr ]

Name	Size	Permission	Date
CONFLICTS	6 B	-rw-rw-r--	2022-10-31 11:36
bug36727.phpt	718 B	-rw-rw-r--	2022-10-31 11:36
bug43925.phpt	1.48 KB	-rw-rw-r--	2022-10-31 11:36
bug46274.phpt	1.67 KB	-rw-rw-r--	2022-10-31 11:36
bug46274_2.phpt	1.91 KB	-rw-rw-r--	2022-10-31 11:36
bug48764.phpt	1.7 KB	-rw-rw-r--	2022-10-31 11:36
bug61267.phpt	577 B	-rw-rw-r--	2022-10-31 11:36
bug62479.phpt	2.04 KB	-rw-rw-r--	2022-10-31 11:36
bug62498-32bit.phpt	4.35 KB	-rw-rw-r--	2022-10-31 11:36
bug62498.phpt	4.35 KB	-rw-rw-r--	2022-10-31 11:36
bug62593.phpt	1.66 KB	-rw-rw-r--	2022-10-31 11:36
bug64953.phpt	1.39 KB	-rw-rw-r--	2022-10-31 11:36
bug66584.phpt	4.79 KB	-rw-rw-r--	2022-10-31 11:36
bug67462.phpt	926 B	-rw-rw-r--	2022-10-31 11:36
bug68199.phpt	2.81 KB	-rw-rw-r--	2022-10-31 11:36
bug68371.phpt	2.22 KB	-rw-rw-r--	2022-10-31 11:36
bug69344.phpt	1.03 KB	-rw-rw-r--	2022-10-31 11:36
bug69362.phpt	1.74 KB	-rw-rw-r--	2022-10-31 11:36
bug69752.phpt	1.44 KB	-rw-rw-r--	2022-10-31 11:36
bug70313.phpt	865 B	-rw-rw-r--	2022-10-31 11:36
bug70861.phpt	1.22 KB	-rw-rw-r--	2022-10-31 11:36
bug71573.phpt	703 B	-rw-rw-r--	2022-10-31 11:36
bug71885.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
bug71885_2.phpt	1.34 KB	-rw-rw-r--	2022-10-31 11:36
bug72294.phpt	3.16 KB	-rw-rw-r--	2022-10-31 11:36
bug72570.phpt	731 B	-rw-rw-r--	2022-10-31 11:36
bug72633.phpt	955 B	-rw-rw-r--	2022-10-31 11:36
bug73959.phpt	805 B	-rw-rw-r--	2022-10-31 11:36
bug75402.phpt	3.56 KB	-rw-rw-r--	2022-10-31 11:36
bug_33876.phpt	3.34 KB	-rw-rw-r--	2022-10-31 11:36
bug_49985.phpt	959 B	-rw-rw-r--	2022-10-31 11:36
bug_64705.phpt	427 B	-rw-rw-r--	2022-10-31 11:36
common.phpt	737 B	-rw-rw-r--	2022-10-31 11:36
config.inc	540 B	-rw-rw-r--	2022-10-31 11:36
copy_from.phpt	7.49 KB	-rw-rw-r--	2022-10-31 11:36
copy_to.phpt	3.74 KB	-rw-rw-r--	2022-10-31 11:36
debug_emulated_prepares.phpt	1.17 KB	-rw-rw-r--	2022-10-31 11:36
disable_prepares.phpt	1.26 KB	-rw-rw-r--	2022-10-31 11:36
getnotify.phpt	2.82 KB	-rw-rw-r--	2022-10-31 11:36
is_in_transaction.phpt	1.74 KB	-rw-rw-r--	2022-10-31 11:36
large_objects.phpt	2.45 KB	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
PDO PgSQL Bug #75402 Possible Memory Leak using PDO::CURSOR_SCROLL option
--SKIPIF--
<?php
if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
require __DIR__ . '/config.inc';
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(__DIR__ . '/common.phpt');

$resp = new \stdClass();
$resp->entries = [];

$db->query('DROP TABLE IF EXISTS bug75402 CASCADE');
$db->query('CREATE TABLE bug75402 (
    "id" character varying(64) NOT NULL,
    "group_id" character varying(64) NOT NULL,
    "submitter" character varying(320) NOT NULL,
    "operation" character varying(32) NOT NULL,
    "description" character varying(320) NOT NULL,
    "stage" character varying(16) NOT NULL,
    "status" character varying(64) NOT NULL,
    "progress" integer NOT NULL,
    "insert_datetime" timestamp(3) NOT NULL,
    "begin_datetime" timestamp(3),
    "end_datetime" timestamp(3),
    "life_hours" integer NOT NULL,
    "family" character varying(32) NOT NULL,
    "parallelism_group" character varying(32) NOT NULL,
    "max_parallelism" integer NOT NULL,
    "hidden" boolean NOT NULL,
    "abort" boolean NOT NULL,
    "order_folder_pathname" character varying(320),
    "worker" character varying(32) NOT NULL,
    CONSTRAINT "pk_bug75402" PRIMARY KEY ("id")
) WITH (oids = false);');

$db->query("INSERT INTO bug75402 (\"id\", \"group_id\", \"submitter\", \"operation\", \"description\", \"stage\", \"status\", \"progress\", \"insert_datetime\", \"begin_datetime\", \"end_datetime\", \"life_hours\", \"family\", \"parallelism_group\", \"max_parallelism\", \"hidden\", \"abort\", \"order_folder_pathname\", \"worker\") VALUES
('20171016083645_5337',	'G_20171016083645_5337',	'TESTPetunia',	'IMPORT',	'',	'DON',	'Completed',	100,	'2017-10-16 08:36:45',	'2017-10-16 08:36:46',	'2017-10-16 08:36:46',	96,	'IMPORT',	'',	-1,	'f',	'f',	'C:\ProgramData\TestPath\TestApp\Jobs\Jobs\\20171016083645_5337',	'MainService')");

$sql = "SELECT 
            ID as \"sID\",
            GROUP_ID as \"sGroupID\",
            SUBMITTER as \"sOwner\",
            OPERATION as \"sOperation\",
            DESCRIPTION as \"sInfo\",
            STAGE as \"sShortStatus\",
            STATUS as \"sStatus\",
            PROGRESS as \"sProgress\",
            HIDDEN as \"bHidden\",
            to_char(INSERT_DATETIME, 'IYYY.MM.DD HH24:MI:SS')  as \"sDatetime\" 
          FROM bug75402 
          ORDER BY INSERT_DATETIME DESC";

if ($db) {
    $stmt = $db->prepare($sql,
		array(
			// With the following options memory is not being
			// deallocated
			  \PDO::ATTR_CURSOR => \PDO::CURSOR_SCROLL
			// With the following option memory is de-allocated
			// \PDO::ATTR_CURSOR => \PDO::CURSOR_FWDONLY
		)
    );
    $stmt->execute();

while ($entry = $stmt->fetchObject()) {
      $resp->entries [] = $entry;
    }
    $stmt->closeCursor();
    $stmt = null;
    $db = null;
}

var_dump($resp);
--EXPECT--
object(stdClass)#2 (1) {
  ["entries"]=>
  array(1) {
    [0]=>
    object(stdClass)#4 (10) {
      ["sid"]=>
      string(19) "20171016083645_5337"
      ["sgroupid"]=>
      string(21) "G_20171016083645_5337"
      ["sowner"]=>
      string(11) "TESTPetunia"
      ["soperation"]=>
      string(6) "IMPORT"
      ["sinfo"]=>
      string(0) ""
      ["sshortstatus"]=>
      string(3) "DON"
      ["sstatus"]=>
      string(9) "Completed"
      ["sprogress"]=>
      string(3) "100"
      ["bhidden"]=>
      bool(false)
      ["sdatetime"]=>
      string(19) "2017.10.16 08:36:45"
    }
  }
}