if ($storage_idx == 0 &&
$schema->storage->isa('DBIx::Class::Storage::DBI::Sybase::NoBindVars')) {
-# no placeholders in this version of Sybase or DBD::Sybase
+# no placeholders in this version of Sybase or DBD::Sybase (or using FreeTDS)
my $tb = Test::More->builder;
$tb->skip('no placeholders') for 1..$TESTS;
next;
# mostly stolen from the blob stuff Nniuq wrote for t/73oracle.t
SKIP: {
- skip 'Need at least version 1.09 of DBD::Sybase to test TEXT/IMAGE', 12
- unless $DBD::Sybase::VERSION >= 1.09;
+ skip 'TEXT/IMAGE support does not work with FreeTDS', 12
+ if $schema->storage->_using_freetds;
my $dbh = $schema->storage->dbh;
{
my $maxloblen = length $binstr{'large'};
note
"Localizing LongReadLen to $maxloblen to avoid truncation of test data";
- local $dbh->{'LongReadLen'} = $maxloblen;
+ local $dbh->{'LongReadLen'} = $maxloblen * 2;
my $rs = $schema->resultset('BindType');
my $last_id;
$last_id = $created->id if $created;
my $got = eval {
- $rs->search({ id => $last_id }, { select => [$type] })->single->$type
+ $rs->find($last_id)->$type
};
diag $@ if $@;
ok($got eq $binstr{$size}, "verified inserted $size $type");
}
}
- # try a blob update
- TODO: {
- local $TODO = 'updating TEXT/IMAGE does not work yet';
-
- my $new_str = $binstr{large} . 'foo';
- eval { $rs->search({ id => $last_id })->update({ blob => $new_str }) };
- ok !$@, 'updated blob successfully';
- diag $@ if $@;
- ok(eval {
- $rs->search({ id => $last_id }, { select => ['blob'] })->single->blob
- } eq $new_str, "verified updated blob" );
- diag $@ if $@;
- }
-
# blob insert with explicit PK
{
local $SIG{__WARN__} = sub {};
],{ RaiseError => 1, PrintError => 0 });
}
my $created = eval { $rs->create( { id => 1, blob => $binstr{large} } ) };
- ok(!$@, "inserted large blob without dying");
+ ok(!$@, "inserted large blob without dying with manual PK");
diag $@ if $@;
my $got = eval {
- $rs->search({ id => 1 }, { select => ['blob'] })->single->blob
+ $rs->find(1)->blob
+ };
+ diag $@ if $@;
+ ok($got eq $binstr{large}, "verified inserted large blob with manual PK");
+
+ # try a blob update
+ my $new_str = $binstr{large} . 'mtfnpy';
+ eval { $rs->search({ id => 1 })->update({ blob => $new_str }) };
+ ok !$@, 'updated blob successfully';
+ diag $@ if $@;
+ $got = eval {
+ $rs->find(1)->blob
};
diag $@ if $@;
- ok($got eq $binstr{large}, "verified inserted large blob");
+ ok($got eq $new_str, "verified updated blob");
}
}