Repository navigation
[pdo_odbc] Unable to turn on autocommit mode with setAttribute #12767
Description
Description
The following code:
<?php
$dsn = "/* your dsn */";
$user = "/* your user */";
$pass = "/* your pass */";
$db = new PDO($dsn, $user, $pass);
$db->exec("CREATE TABLE test (id INT, name VARCHAR(255))");
unset($db);
$db = new PDO($dsn, $user, $pass, [
PDO::ATTR_AUTOCOMMIT => 0,
]);
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
$db->query("INSERT INTO test (id, name) VALUES (1, 'test')");
unset($db);
$db = new PDO($dsn, $user, $pass);
$r = $db->query("SELECT * FROM test");
var_dump($r->fetchAll(PDO::FETCH_ASSOC));Resulted in this output:
array(0) {
}
But I expected this output instead:
array(1) {
[0]=>
array(2) {
["id"]=>
string(1) "1"
["name"]=>
string(4) "test"
}
}
I noticed the bug while reading the C source code, so I already know the cause. This is because when you change the attribute value after the constructor, nothing is done. The fix may be ready by the end of 8.1's bug fixes.
PHP Version
PHP8.1 ~ master
Operating System
No response
Activity
SakiTakamachi commentedon Nov 24, 2023
There is a possibility that the behavior related to transactions may change slightly, so I would like to fix this for master.
SakiTakamachi commentedon Nov 24, 2023
The main change is in the behavior when changing the autocommit mode while a transaction exists. I think this should probably be an error, but it could be a breaking change.
Fix GH-12767: Fixed to be able to change autocommit mode using setAtt…
Merge branch 'PHP-8.2' into PHP-8.3
Merge branch 'PHP-8.3'