#!/usr/bin/perl -w
# test for https://rt.cpan.org/Public/Bug/Display.html?id=55244
use strict;
use warnings;
use Test::More;
use lib 't','.';
use TestFirebird;
my $T = TestFirebird->new;
my ( $dbh, $error_str )
= $T->connect_to_database( { AutoCommit => 0, RaiseError => 1 } );
if ($error_str) {
BAIL_OUT("Unknown: $error_str!");
}
unless ( $dbh->isa('DBI::db') ) {
plan skip_all => 'Connection to database failed, cannot continue testing';
}
else {
plan tests => 6;
}
ok($dbh, 'Connected to the database');
my $table = find_new_table($dbh);
ok( $dbh->do("CREATE TABLE $table(i INTEGER NOT NULL)"),
'table $table created' );
$dbh->commit;
my $insert_sql = "INSERT INTO $table(i) VALUES(42)";
my $sth = $dbh->prepare_cached($insert_sql);
ok( $sth->execute );
$dbh->rollback;
$sth = $dbh->prepare_cached($insert_sql);
ok( $sth->execute(), 'cached statement execues after rollback' );
ok( $dbh->do("DROP TABLE $table") );
$dbh->commit;
ok( $dbh->disconnect );