X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F05in_between.t;h=5bcbe554fa5fc159799ad20c79315bc47999a2a0;hb=c7e9c808fa4346e2c2692f107852626c0ccde404;hp=bb98f1175d1e14a4d5d4fb8a9363414feabf1162;hpb=eda178179da47ebe82abb81daedb3baa0ec83e80;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/05in_between.t b/t/05in_between.t index bb98f11..5bcbe55 100644 --- a/t/05in_between.t +++ b/t/05in_between.t @@ -310,15 +310,28 @@ my @in_between_tests = ( { where => { -in => [ - { -tuple => [ 'x', 'y' ] }, - { -tuple => [ 1, 2 ] }, - { -tuple => [ 3, 4 ] }, + { -row => [ 'x', 'y' ] }, + { -row => [ 1, 2 ] }, + { -row => [ 3, 4 ] }, ], }, stmt => ' WHERE (x, y) IN ((?, ?), (?, ?))', bind => [ 1..4 ], - test => 'Complex IN', + test => 'Complex top-level -in', }, + { + where => { -is => [ 'bob', undef ] }, + stmt => ' WHERE bob IS NULL', + bind => [], + test => 'Top level -is ok', + }, + { + where => { -op => [ in => x => 1, 2, 3 ] }, + stmt => ' WHERE x IN (?, ?, ?)', + bind => [ 1, 2, 3 ], + test => 'Raw -op passes through correctly' + }, + ); for my $case (@in_between_tests) {