X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F06order_by.t;h=0d340ae961baa7c2b0b2c39cd1830e5f67d8f396;hb=47662caa5fb4467570af9f7b0fb3dffca20c7ed7;hp=4236e70091551589585c6fc6e29f06c3952c4a7b;hpb=46dc2f3e47d514cd376003cea2df63222c492b0b;p=scpubgit%2FQ-Branch.git diff --git a/t/06order_by.t b/t/06order_by.t index 4236e70..0d340ae 100644 --- a/t/06order_by.t +++ b/t/06order_by.t @@ -58,6 +58,11 @@ my @cases = expects => '', expects_quoted => '', }, + { + given => [ {} ], + expects => '', + expects_quoted => '', + }, { given => [{-desc => [ qw/colA colB/ ] }], @@ -107,10 +112,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, @@ -118,7 +123,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, @@ -134,6 +139,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',