mirror of
https://github.com/php/php-src.git
synced 2025-08-15 21:48:51 +02:00
dfaf7986de
take2 of #12657 ## About Firebird transaction Firebird is a full transactional database, so the DB itself does not support autocommit mode. (Strictly, there is an autocommit mode, but it is a different concept from the "autocommit" that we are used to with MySQL and others.) Therefore, a transaction must have started before any operation is performed, and autocommit mode had to be emulated in PHP. I made sure that a transaction always exists when in autocommit mode. Since the `in_transacntion` function does not work as expected, I have introduced `H->in_manually_txn` to determine whether a transaction is being manually manipulated. ## There are two types of commit/rollback (I'm not talking about two-phase commit. This change does not take into account two-phase commit.) There are `isc_commit_retaining` which starts a transaction again in the same context immediately after committing, and `isc_commit_transaction` which closes the transaction as is. Similarly, there are two types of rollback. ----------- Due to the default value of the transaction isolation level, autocommit mode may obtain unintended results. Regarding this, it would be too large to include support for transaction isolation levels in this PR, so I will leave it as is for now.
25 lines
651 B
PHP
25 lines
651 B
PHP
--TEST--
|
|
FB payload server satisfies connection attempt
|
|
--EXTENSIONS--
|
|
pdo_firebird
|
|
sockets
|
|
--XLEAK--
|
|
A bug in firebird causes a memory leak when calling `isc_attach_database()`.
|
|
See https://github.com/FirebirdSQL/firebird/issues/7849
|
|
--FILE--
|
|
<?php
|
|
require_once "payload_server.inc";
|
|
|
|
$address = run_server(__DIR__ . "/payload_test.data");
|
|
|
|
// no need to change the credentials; we're running against a fake server
|
|
$dsn = "firebird:dbname=inet://$address/test";
|
|
$username = 'SYSDBA';
|
|
$password = 'masterkey';
|
|
|
|
new PDO($dsn, $username, $password, [
|
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
PDO::ATTR_AUTOCOMMIT => false,
|
|
]);
|
|
?>
|
|
--EXPECT--
|