xref: /PHP-8.2/ext/pdo_odbc/tests/autocommit.phpt (revision 933dccb7)
1--TEST--
2PDO ODBC auto commit mode
3--EXTENSIONS--
4pdo_odbc
5--SKIPIF--
6<?php
7require 'ext/pdo/tests/pdo_test.inc';
8PDOTest::skip();
9?>
10--XLEAK--
11A bug in msodbcsql causes a memory leak when reconnecting after closing. See GH-12306
12--FILE--
13<?php
14require 'ext/pdo/tests/pdo_test.inc';
15
16$table = 'autocommit_pdo_odbc';
17
18$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
19$db->exec("CREATE TABLE {$table} (id INT, name VARCHAR(255))");
20unset($db);
21
22$db = new PDO(getenv('PDOTEST_DSN'), getenv('PDOTEST_USER'), getenv('PDOTEST_PASS'), [
23    PDO::ATTR_AUTOCOMMIT => 0,
24]);
25
26$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
27$db->query("INSERT INTO {$table} (id, name) VALUES (1, 'test')");
28unset($db);
29
30$db = new PDO(getenv('PDOTEST_DSN'), getenv('PDOTEST_USER'), getenv('PDOTEST_PASS'));
31
32$r = $db->query("SELECT * FROM {$table}");
33var_dump($r->fetchAll(PDO::FETCH_ASSOC));
34
35echo "done!";
36?>
37--CLEAN--
38<?php
39require 'ext/pdo/tests/pdo_test.inc';
40$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
41$db->exec("DROP TABLE IF EXISTS autocommit_pdo_odbc");
42?>
43--EXPECT--
44array(1) {
45  [0]=>
46  array(2) {
47    ["id"]=>
48    string(1) "1"
49    ["name"]=>
50    string(4) "test"
51  }
52}
53done!
54