X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F15placeholders.t;h=55731a84aaf4b5826b6bf0aaf42d05e14541bcd8;hb=cf5b7ab163f8ac123ebc9bb1156e79646cd5bd2f;hp=a82b66809c22d423a6707f35db1f139f2d54f2bf;hpb=e4570c8e06ddb929c5ae0322cb2e42ef523a6ed4;p=scpubgit%2FQ-Branch.git diff --git a/t/15placeholders.t b/t/15placeholders.t index a82b668..55731a8 100644 --- a/t/15placeholders.t +++ b/t/15placeholders.t @@ -33,8 +33,8 @@ use SQL::Abstract::Tree; placeholder_surround => [qw(' ')], }); - is $sqlat->format('SELECT ? as x, ? as y FROM Foo WHERE t > ? and z IN (?, ?, ?) ', [qw/frew ribasushi 2008-12-12 1 2 3/]), - q[SELECT 'frew' as x, 'ribasushi' as y FROM Foo WHERE t > '2008-12-12' AND z IN ('1', '2', '3')], 'Complex placeholders work'; + is $sqlat->format('SELECT ? AS x, ? AS y FROM Foo WHERE t > ? and z IN (?, ?, ?) ', [qw/frew ribasushi 2008-12-12 1 2 3/]), + q[SELECT 'frew' AS x, 'ribasushi' AS y FROM Foo WHERE t > '2008-12-12' AND z IN ( '1', '2', '3' )], 'Complex placeholders work'; } done_testing;