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: }
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>