X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F01generate.t;h=4fa38edc6ac49dd39b589b44cef3810ed8ea876a;hb=2e6704698a31dc5281609064714f98d080f83971;hp=50e2f46dfcda497a9e1638b98ae47c2d9ef7afbd;hpb=c4ed66f4bd98994449fe7f34beb2820e2f8f2fcb;p=scpubgit%2FQ-Branch.git diff --git a/t/01generate.t b/t/01generate.t index 50e2f46..4fa38ed 100644 --- a/t/01generate.t +++ b/t/01generate.t @@ -16,7 +16,6 @@ use SQL::Abstract; # ################# - my @tests = ( { func => 'select', @@ -75,6 +74,14 @@ my @tests = ( bind => ['boom'] }, { + # this is maybe wrong but a single arg doesn't get quoted + func => 'select', + args => ['test', 'id', { a => { '!=', 'boom' } }], + stmt => 'SELECT id FROM test WHERE ( a != ? )', + stmt_q => 'SELECT id FROM `test` WHERE ( `a` != ? )', + bind => ['boom'] + }, + { func => 'update', args => ['test', {a => 'boom'}, {a => undef}], stmt => 'UPDATE test SET a = ? WHERE ( a IS NULL )',