X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F74mssql.t;h=5df9b5ea57ae1e538ff12e8da7fcbbb067948fdb;hb=d52d4d6e066eca4c85c5f4f6cf7b005f0dc883bc;hp=3397f3c843f2111d53a16aae8f470a8f64e485f3;hpb=bbdda28109ffb2442af84b3cbe5c4921714a52dd;p=dbsrgits%2FDBIx-Class.git diff --git a/t/74mssql.t b/t/74mssql.t index 3397f3c..5df9b5e 100644 --- a/t/74mssql.t +++ b/t/74mssql.t @@ -18,6 +18,11 @@ my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MSSQL_${_}" } qw/DSN USER PASS/}; plan skip_all => 'Set $ENV{DBICTEST_MSSQL_DSN}, _USER and _PASS to run this test' unless ($dsn); +{ + my $srv_ver = DBICTest::Schema->connect($dsn, $user, $pass)->storage->_server_info->{dbms_version}; + ok ($srv_ver, 'Got a test server version on fresh schema: ' . ($srv_ver||'???') ); +} + my $testdb_supports_placeholders = DBICTest::Schema->connect($dsn, $user, $pass) ->storage ->_supports_typeless_placeholders; @@ -173,15 +178,10 @@ SQL my $have_rno = $version >= 9 ? 1 : 0; - local $storage->{_sql_maker} = undef; - local $storage->{_sql_maker_opts} = undef; - local $storage->{_dbh_details}{info} = {}; # delete cache - $storage->sql_maker; - my $rno_detected = - ($storage->{_sql_maker_opts}{limit_dialect} eq 'RowNumberOver') ? 1 : 0; + ($storage->sql_limit_dialect eq 'RowNumberOver') ? 1 : 0; ok (($have_rno == $rno_detected), 'row_number() over support detected correctly');