X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F747mssql_ado.t;h=7981c781ceccc930f13afdb5fe982e2d57cf8606;hb=533c69f140568b3643912fe342429752feb2b7c0;hp=227c9b506ce1211fd4b0b7f2b01ec54aa06a5c1c;hpb=7c5b1b9f543c0a88a8abd583e8e37f31fce26e1c;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/747mssql_ado.t b/t/747mssql_ado.t index 227c9b5..7981c78 100644 --- a/t/747mssql_ado.t +++ b/t/747mssql_ado.t @@ -11,7 +11,7 @@ my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MSSQL_ADO_${_}" } qw/DSN USER PAS plan skip_all => 'Set $ENV{DBICTEST_MSSQL_ADO_DSN}, _USER and _PASS to run this test' unless ($dsn && $user); -plan tests => 10; +plan tests => 12; my $schema = DBICTest::Schema->connect($dsn, $user, $pass); $schema->storage->ensure_connected; @@ -39,6 +39,14 @@ ok($new->artistid > 0, 'Auto-PK worked'); my $found = $schema->resultset('Artist')->search({ name => 'foo' })->first; is $found->artistid, $new->artistid, 'search works'; +# test large column list in select +$found = $schema->resultset('Artist')->search({ name => 'foo' }, { + select => ['artistid', 'name', map "'foo' foo_$_", 0..50], + as => ['artistid', 'name', map "foo_$_", 0..50], +})->first; +is $found->artistid, $new->artistid, 'select with big column list'; +is $found->get_column('foo_50'), 'foo', 'last item in big column list'; + # create a few more rows for (1..6) { $schema->resultset('Artist')->create({ name => 'Artist ' . $_ });