Return to bug_49985.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_pgsql / tests

Annotation of embedaddon/php/ext/pdo_pgsql/tests/bug_49985.phpt, revision 1.1.1.2

1.1       misho       1: --TEST--
                      2: Bug #49985 (pdo_pgsql prepare() re-use previous aborted transaction)
                      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: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
                     14: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                     15: 
                     16: $db->exec("CREATE TABLE test (a int PRIMARY KEY)");
                     17: 
                     18: for ($i = 0; $i < 3; $i++) {
                     19:     try {
                     20:         $db->beginTransaction();
                     21:         $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)");
                     22:         var_dump($stmt->execute(array(1)));
                     23:         $db->commit();
                     24:     } catch (Exception $e) {
                     25:         echo trim(current(explode("\n", $e->getMessage())))."\n";
                     26:         $db->rollback();
                     27:     }
                     28: }
                     29: 
                     30: ?>
                     31: --EXPECTF--
                     32: bool(true)
1.1.1.2 ! misho      33: SQLSTATE[23505]: %stest_pkey%s
        !            34: SQLSTATE[23505]: %stest_pkey%s
1.1       misho      35: