Mercurial > hg > monetdb-perl
changeset 27:536255410444
Test fetchrow_array
author | Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> |
---|---|
date | Wed, 16 Dec 2020 11:31:46 +0100 (2020-12-16) |
parents | a0b0ed79f8ab |
children | e3e0159771c7 |
files | DBD/t/15many.t |
diffstat | 1 files changed, 13 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/DBD/t/15many.t +++ b/DBD/t/15many.t @@ -16,7 +16,7 @@ use DBD_TEST(); use Test::More; if (defined $ENV{DBI_DSN}) { - plan tests => 4; + plan tests => 5; } else { plan skip_all => 'Cannot test without DB info'; } @@ -44,7 +44,17 @@ ok($count == 1000, 'got 1000 rows as req $count = scalar(@{$r}); ok($count % 1000 == 0, "got $count rows"); - - +# fetch some data using fetchrow_array +# fetch a lot of rows and see we don't get disconnected halfway, see Bug 2897 +$query = qq{ + SELECT value as i, value as j, value as k FROM sys.generate_series(0,100); +}; +$sth = $dbh->prepare($query); +$sth->execute; +my $cells = 0; +while (my @row = $sth->fetchrow_array) { + $cells += 1 + $#row; +} +is($cells, 300, 'fetch items using fetchrow_array'); ok( $dbh->disconnect,'Disconnect');