xref: /PHP-8.4/ext/pdo_firebird/tests/ddl2.phpt (revision d6a0b3af)
1--TEST--
2PDO_Firebird: DDL/transactions 2
3--EXTENSIONS--
4pdo_firebird
5--SKIPIF--
6<?php require('skipif.inc'); ?>
7--XLEAK--
8A bug in firebird causes a memory leak when calling `isc_attach_database()`.
9See https://github.com/FirebirdSQL/firebird/issues/7849
10--FILE--
11<?php
12require("testdb.inc");
13
14$dbh = getDbConnection();
15$dbh->exec("CREATE TABLE test_ddl2 (val int)");
16
17$dbh->beginTransaction();
18$dbh->exec("INSERT INTO test_ddl2 (val) VALUES (120)");
19$dbh->exec("CREATE TABLE test_ddl2_2 (val INT)");
20$dbh->rollback();
21
22$result = $dbh->query("SELECT * FROM test_ddl2");
23var_dump($result->fetchAll());
24
25unset($dbh);
26echo "done\n";
27?>
28--CLEAN--
29<?php
30require("testdb.inc");
31$dbh = getDbConnection();
32$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
33@$dbh->exec('DROP TABLE test_ddl2');
34@$dbh->exec('DROP TABLE test_ddl2_2');
35?>
36--EXPECT--
37array(0) {
38}
39done
40