Re: DBD::Informix test failures

John and I have had some off-list discussion.

The problem is ultimately a test error; the code written a decade or more
ago doesn't take into account a database server configuration option
introduced in the last five years or so.

The relevant Informix configuration parameter is TEMPTAB_NOLOG.  If set,
the test that relies on being able to rollback changes in a temporary table
will fail because the configuration parameter removes the ability to
rollback changes in temporary tables.

The test will be updated and a new DBD::Informix released, probably before
Christmas; the build is working OK and is safe to use in production (or as
safe as it ever was).

This comment covers both of John's emails to dbi-users mailing list.



On Tue, Nov 12, 2013 at 2:01 AM, John Beranek <[email protected]> wrote:

> On 12/11/2013 08:59, John Beranek wrote:
>
>>
>> I'm trying to compile DBD::Informix on a Linux server (or alternatively
>> on a Solaris 10 server, but this shows the same problems) but I'm
>> getting failures in the test suite.
>>
>
> Firstly, I've fixed the subject, that is the subject I had initially
> intended to use.
>
> I boiled down the tests into a simple test script, to convince myself of
> the results:
>
> use DBI;
>
> my $database = 'testdb';
> my $username = 'informix';
> my $password = 'somepassword';
>
> my $test_table = 'test_jb';
>
> my $dbh = DBI->connect("dbi:Informix:$database", $username, $password,
> {AutoCommit => 0});
>
> $dbh->do("CREATE TEMP TABLE $test_table
> (
>         Col01   SERIAL NOT NULL PRIMARY KEY,
>         Col02   CHAR(20) NOT NULL,
>         Col03   DATE NOT NULL,
>         Col04   DATETIME YEAR TO FRACTION(5) NOT NULL
> )") or die "CREATE TEMP TABLE failed\n";
>
> $dbh->commit();
>
> my $date = '25/12/1996';
> my $time = '2004-02-29 23:59:54.32109';
>
> $dbh->do("INSERT INTO $test_table VALUES(0, 'data', '$date', '$time')");
>
> $dbh->rollback();
>
> my $sth = $dbh->prepare("SELECT * from $test_table");
>
> $sth->execute();
>
> use Data::Dumper;
> print Dumper($sth->fetchall_arrayref);
>
> $dbh->disconnect();
>
>
> The results of this script are:
>
> $VAR1 = [
>           [
>             '1',
>             'data                ',
>             '25/12/1996',
>             '2004-02-29 23:59:54.32109'
>           ]
>         ];
>
>
> i.e. the "rollback" appears not to have worked. From the output of the
> test suite, the database is a logged database, and there doesn't appear to
> be any errors setting autocommit off. So, what would cause transaction
> rollbacks not to work?
>
> Cheers,
>
> John
>
> --
> John Beranek                         To generalise is to be an idiot.
> http://redux.org.uk/                                 -- William Blake
>



-- 
Jonathan Leffler <[email protected]>  #include <disclaimer.h>
Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."