bug69752.phpt 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. --TEST--
  2. PDO PgSQL Bug #69752 (memory leak with closeCursor)
  3. --SKIPIF--
  4. <?php
  5. if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
  6. require dirname(__FILE__) . '/config.inc';
  7. require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
  8. PDOTest::skip();
  9. ?>
  10. --FILE--
  11. <?php
  12. require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
  13. $pdo = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
  14. $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
  15. $pdo->beginTransaction();
  16. $pdo->exec("
  17. create table foo (
  18. id bigserial not null primary key,
  19. field1 text not null,
  20. field2 text not null,
  21. field3 text not null,
  22. field4 int4 not null
  23. )
  24. ");
  25. $stmt = $pdo->prepare("insert into foo (field1, field2, field3, field4) values (:field1, :field2, :field3, :field4)");
  26. $max = 1000;
  27. $first_time_usage = null;
  28. for($i = 0; $i < $max; $i++) {
  29. $data = array(
  30. 'field1' => "field1: $i",
  31. 'field2' => "field2: $i",
  32. 'field3' => "field3: $i",
  33. 'field4' => $i
  34. );
  35. $stmt->execute($data);
  36. $stmt->closeCursor();
  37. $usage = intval(floor(memory_get_usage() / 1024));
  38. if ($first_time_usage === null) $first_time_usage = $usage;
  39. /* Use delta instead of direct comparison here */
  40. if (abs($first_time_usage - $usage) > 3){
  41. printf("Memory Leak Detected: %d != %d\n", $usage, $first_time_usage);
  42. break;
  43. }
  44. }
  45. $pdo->rollBack();
  46. echo "done\n"
  47. ?>
  48. --EXPECTF--
  49. done