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

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: }