X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F01generate.t;h=a32fbe6b73f6965cdceba17fd739f4bb641e28f0;hb=7732c37a;hp=1f305bb10d1da4664073b592cc396ce0436ad912;hpb=ed821a87ef7ccfa615ee304aa2a5bcecff48a73c;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/01generate.t b/t/01generate.t index 1f305bb..a32fbe6 100644 --- a/t/01generate.t +++ b/t/01generate.t @@ -78,6 +78,13 @@ my @tests = ( }, { func => 'select', + args => [[\'test1', 'test2'], '*', { 'test1.a' => { 'In', ['boom', 'bang'] } }], + stmt => 'SELECT * FROM test1, test2 WHERE ( test1.a IN ( ?, ? ) )', + stmt_q => 'SELECT * FROM test1, `test2` WHERE ( `test1`.`a` IN ( ?, ? ) )', + bind => ['boom', 'bang'] + }, + { + func => 'select', args => ['test', '*', { a => { 'between', ['boom', 'bang'] } }], stmt => 'SELECT * FROM test WHERE ( a BETWEEN ? AND ? )', stmt_q => 'SELECT * FROM `test` WHERE ( `a` BETWEEN ? AND ? )',