--TEST--
PDO ODBC auto commit mode
--EXTENSIONS--
pdo_odbc
--SKIPIF--
<?php
require 'ext/pdo/tests/pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
require 'ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

echo "========== not in transaction ==========\n";

echo "auto commit ON from ON\n";
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
echo "Success\n\n";

echo "auto commit OFF from ON\n";
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
echo "Success\n\n";

echo "auto commit OFF from OFF\n";
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
echo "Success\n\n";

echo "auto commit ON from OFF\n";
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
echo "Success\n\n";

echo "========== in transaction ==========\n";

echo "begin transaction\n";
$db->beginTransaction();
echo "\n";

echo "auto commit ON from ON, expect error\n";
try {
    $db->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
} catch (PDOException $e) {
    var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
    echo $e->getMessage()."\n\n";
}

echo "auto commit OFF from ON, expect error\n";
try {
    $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
} catch (PDOException $e) {
    var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
    echo $e->getMessage()."\n\n";
}

echo "end transaction\n";
$db->rollback();

echo "auto commit OFF\n";
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);

echo "begin transaction\n";
$db->beginTransaction();
echo "\n";

echo "auto commit ON from OFF, expect error\n";
try {
    $db->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
} catch (PDOException $e) {
    var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
    echo $e->getMessage()."\n\n";
}

echo "auto commit OFF from OFF, expect error\n";
try {
    $db->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
} catch (PDOException $e) {
    var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT));
    echo $e->getMessage()."\n\n";
}

echo "end transaction\n";
$db->rollback();
echo "\n";

echo "done!";
?>
--EXPECT--
========== not in transaction ==========
auto commit ON from ON
bool(true)
Success

auto commit OFF from ON
bool(false)
Success

auto commit OFF from OFF
bool(false)
Success

auto commit ON from OFF
bool(true)
Success

========== in transaction ==========
begin transaction

auto commit ON from ON, expect error
bool(true)
SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open

auto commit OFF from ON, expect error
bool(true)
SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open

end transaction
auto commit OFF
begin transaction

auto commit ON from OFF, expect error
bool(false)
SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open

auto commit OFF from OFF, expect error
bool(false)
SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open

end transaction

done!