Return to bug_38955.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_dblib/tests/bug_38955.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2:  PDO_DBLIB driver does not support transactions
        !             3: --SKIPIF--
        !             4: <?php
        !             5: if (!extension_loaded('pdo_dblib')) die('skip not loaded');
        !             6: require dirname(__FILE__) . '/config.inc';
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: require dirname(__FILE__) . '/config.inc';
        !            11: 
        !            12: /*We see these rows */
        !            13: $db->query("CREATE table php_test(val int)");
        !            14: $db->beginTransaction();
        !            15: $db->query("INSERT INTO php_test(val) values(1)");
        !            16: $db->query("INSERT INTO php_test(val) values(2)");
        !            17: $db->query("INSERT INTO php_test(val) values(3)");
        !            18: $db->query("INSERT INTO php_test(val) values(4)");
        !            19: $db->commit();
        !            20: 
        !            21: /*We don't see these rows */
        !            22: $db->beginTransaction();
        !            23: $db->query("INSERT INTO php_test(val) values(5)");
        !            24: $db->query("INSERT INTO php_test(val) values(6)");
        !            25: $db->query("INSERT INTO php_test(val) values(7)");
        !            26: $db->query("INSERT INTO php_test(val) values(8)");
        !            27: $db->rollback();
        !            28: 
        !            29: $rs = $db->query("SELECT * FROM php_test");
        !            30: $rows = $rs->fetchAll(PDO::FETCH_ASSOC);
        !            31: var_dump($rows);
        !            32: 
        !            33: $db->query("DROP table php_test");
        !            34: ?>
        !            35: --EXPECT--
        !            36: array(4) {
        !            37:   [0]=>
        !            38:   array(1) {
        !            39:     ["val"]=>
        !            40:     string(1) "1"
        !            41:   }
        !            42:   [1]=>
        !            43:   array(1) {
        !            44:     ["val"]=>
        !            45:     string(1) "2"
        !            46:   }
        !            47:   [2]=>
        !            48:   array(1) {
        !            49:     ["val"]=>
        !            50:     string(1) "3"
        !            51:   }
        !            52:   [3]=>
        !            53:   array(1) {
        !            54:     ["val"]=>
        !            55:     string(1) "4"
        !            56:   }
        !            57: }