X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F07subqueries.t;h=7d5fbd4e66f8fe77ffc9b7d0a8bf0266e7ba914c;hb=3ae1c5e20cfd486c0a0def29832f05977d0092a0;hp=28bac85ade52387e42589f104f4b9ffe2120238b;hpb=10e6c94609fc94467ef8f281ffe192d8038ffc9e;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/07subqueries.t b/t/07subqueries.t index 28bac85..7d5fbd4 100644 --- a/t/07subqueries.t +++ b/t/07subqueries.t @@ -1,5 +1,3 @@ -#!/usr/bin/perl - use strict; use warnings; use Test::More; @@ -36,7 +34,7 @@ push @tests, { #2 ($sub_stmt, @sub_bind) - = $sql->select("t1", "c1", {c2 => {"<" => 100}, + = $sql->select("t1", "c1", {c2 => {"<" => 100}, c3 => {-like => "foo%"}}); $where = { foo => 1234, @@ -49,7 +47,7 @@ push @tests, { }; #3 -($sub_stmt, @sub_bind) +($sub_stmt, @sub_bind) = $sql->select("t1", "*", {c1 => 1, c2 => \"> t0.c0"}); $where = { foo => 1234, @@ -73,7 +71,7 @@ push @tests, { #5 -($sub_stmt, @sub_bind) +($sub_stmt, @sub_bind) = $sql->where({age => [{"<" => 10}, {">" => 20}]}); $sub_stmt =~ s/^ where //i; # don't want "WHERE" in the subclause $where = {