X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=xt%2Fclauses.t;h=4e934f86b234d5113c69cc79219ebb587b990ebb;hb=93253a11f1f3e0ad2479e38f50963593394c9afc;hp=d47e113f3c8dc662ebbf0b022721f52280f12389;hpb=f8d50921370b4bbdf550737442f9fa9e8b4e9d8d;p=scpubgit%2FQ-Branch.git diff --git a/xt/clauses.t b/xt/clauses.t index d47e113..4e934f8 100644 --- a/xt/clauses.t +++ b/xt/clauses.t @@ -99,9 +99,20 @@ is_same_sql( is_same_sql( $sqlac->insert({ into => 'foo', - values => { -select => { select => '*', from => 'bar' } } + select => { select => '*', from => 'bar' } }), q{INSERT INTO foo SELECT * FROM bar} ); +($sql, @bind) = $sqlac->insert({ + into => 'eh', + rowvalues => [ [ 1, 2 ], [ 3, 4 ], [ 5, 6 ] ] +}); + +is_same_sql_bind( + $sql, \@bind, + q{INSERT INTO eh VALUES (?, ?), (?, ?), (?, ?)}, + [ 1..6 ], +); + done_testing;