X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F05in_between.t;h=2ae90cf66e267ac218c0e64fbd8997124315cbba;hb=279eb282a990f9527912613255df2c81dff8b05b;hp=22218c02ac721b6c0cbfabbb0286625f0250eaef;hpb=5e5cbf5124ea9704c01824f32b70072c39f69179;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/05in_between.t b/t/05in_between.t index 22218c0..2ae90cf 100644 --- a/t/05in_between.t +++ b/t/05in_between.t @@ -172,6 +172,18 @@ my @in_between_tests = ( bind => [qw/A c/], test => '-in with an array of function array refs with args', }, + { + where => { x => { -in => [ 1, undef ] } }, + stmt => " WHERE ( x IN ( ?, NULL ) )", + bind => [ 1 ], + test => '-in with undef as an element', + }, + { + where => { x => { -in => [ 1, undef, 2, 3, undef ] } }, + stmt => " WHERE ( x IN ( ?, NULL, ?, ?, NULL ) )", + bind => [ 1, 2, 3 ], + test => '-in with undef as an element', + }, ); plan tests => @in_between_tests*4;