X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F02where.t;h=204a8fd52ddadac0188cff031271863e004e8501;hb=03e6883c5f3918df6a5b6cb7fad8e1e5131e3876;hp=1b0ac9214d9c82af072d01fcb51eee40a22a31ce;hpb=0536821b0ba2caca9fdc96c6f8c256f924d8a577;p=scpubgit%2FQ-Branch.git diff --git a/t/02where.t b/t/02where.t index 1b0ac92..204a8fd 100644 --- a/t/02where.t +++ b/t/02where.t @@ -335,12 +335,12 @@ my @handle_tests = ( # Op against random functions (these two are oracle-specific) { where => { timestamp => { '!=' => { -trunc => { -year => \'sysdate' } } } }, - stmt => " WHERE ( timestamp != TRUNC (YEAR sysdate) )", + stmt => " WHERE ( timestamp != TRUNC(YEAR(sysdate)) )", bind => [], }, { where => { timestamp => { '>=' => { -to_date => '2009-12-21 00:00:00' } } }, - stmt => " WHERE ( timestamp >= TO_DATE ? )", + stmt => " WHERE ( timestamp >= TO_DATE(?) )", bind => ['2009-12-21 00:00:00'], }, @@ -408,6 +408,11 @@ my @handle_tests = ( stmt => '', bind => [ ], }, + { + where => { '=' => \'bozz' }, + stmt => 'WHERE = bozz', + bind => [ ], + }, ); for my $case (@handle_tests) {