X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F02where.t;h=572d502a3413ffe5ef029c9a268047f4429f2bd5;hb=46dc2f3e47d514cd376003cea2df63222c492b0b;hp=ee5dbd8ab4f04caf4907548d2352f18597b43433;hpb=2fadf08e171ee68c239cec896075428ae21f2232;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/02where.t b/t/02where.t index ee5dbd8..572d502 100644 --- a/t/02where.t +++ b/t/02where.t @@ -1,5 +1,3 @@ -#!/usr/bin/perl - use strict; use warnings; use Test::More; @@ -8,9 +6,6 @@ use SQL::Abstract::Test import => [qw(is_same_sql_bind diag_where) ]; use SQL::Abstract; -# Make sure to test the examples, since having them break is somewhat -# embarrassing. :-( - my $not_stringifiable = bless {}, 'SQLA::NotStringifiable'; my @handle_tests = ( @@ -81,9 +76,6 @@ my @handle_tests = ( completion_date => { 'between', ['2002-10-01', '2003-02-06'] }, }, order => \'ticket, requestor', -#LDNOTE: modified parentheses -# -# acked by RIBASUSHI stmt => "WHERE ( ( completion_date BETWEEN ? AND ? ) AND status = ? ) ORDER BY ticket, requestor", bind => [qw/2002-10-01 2003-02-06 completed/], }, @@ -139,9 +131,6 @@ my @handle_tests = ( requestor => { 'like', undef }, }, order => \'requestor, ticket', -#LDNOTE: modified parentheses -# -# acked by RIBASUSHI stmt => " WHERE ( ( priority BETWEEN ? AND ? ) AND requestor IS NULL ) ORDER BY requestor, ticket", bind => [qw/1 3/], }, @@ -155,15 +144,11 @@ my @handle_tests = ( '>' => 10, }, }, -# LDNOTE : modified test below, just parentheses differ -# -# acked by RIBASUSHI stmt => " WHERE ( id = ? AND ( num <= ? AND num > ? ) )", bind => [qw/1 20 10/], }, { -# LDNOTE 23.03.09 : modified test below, just parentheses differ where => { foo => {-not_like => [7,8,9]}, fum => {'like' => [qw/a b/]}, nix => {'between' => [100,200] },