X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F06order_by.t;h=e3b94f704421bc63d9fbdff523b000f231515624;hb=dd1d0dbf25425dbd05193ec6d5453e9170eb832c;hp=bf478df45d9082c5e39a45caea3789eac795886d;hpb=10e6c94609fc94467ef8f281ffe192d8038ffc9e;p=scpubgit%2FQ-Branch.git diff --git a/t/06order_by.t b/t/06order_by.t index bf478df..e3b94f7 100644 --- a/t/06order_by.t +++ b/t/06order_by.t @@ -1,5 +1,3 @@ -#!/usr/bin/perl - use strict; use warnings; use Test::More; @@ -109,10 +107,10 @@ my @cases = my $sql = SQL::Abstract->new; my $sqlq = SQL::Abstract->new({quote_char => '`'}); -for my $case( @cases) { +for my $case (@cases) { my ($stat, @bind); - ($stat, @bind) = $sql->_order_by($case->{given}); + ($stat, @bind) = $sql->where(undef, $case->{given}); is_same_sql_bind ( $stat, \@bind, @@ -120,7 +118,7 @@ for my $case( @cases) { $case->{bind} || [], ); - ($stat, @bind) = $sqlq->_order_by($case->{given}); + ($stat, @bind) = $sqlq->where(undef, $case->{given}); is_same_sql_bind ( $stat, \@bind, @@ -136,6 +134,12 @@ throws_ok ( ); throws_ok ( + sub { $sql->_order_by([ {-desc => 'colA', -asc => 'colB' } ]) }, + qr/hash passed .+ must have exactly one key/, + 'Undeterministic order exception', +); + +throws_ok ( sub { $sql->_order_by({-desc => [ qw/colA colB/ ], -asc => [ qw/colC colD/ ] }) }, qr/hash passed .+ must have exactly one key/, 'Undeterministic order exception',