X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14roundtrippin.t;h=7334d31f72192c84999c94f1de2191eb81489223;hb=1ec9b9e3261f37de1bd05b31fa3c88ab78ab1480;hp=4155cc5062a54dff46c9453ab63e83d0dc6bb3b5;hpb=87abf9bc3395870cef72a3f00b7d4cfe18abd980;p=scpubgit%2FQ-Branch.git diff --git a/t/14roundtrippin.t b/t/14roundtrippin.t index 4155cc5..7334d31 100644 --- a/t/14roundtrippin.t +++ b/t/14roundtrippin.t @@ -21,7 +21,7 @@ my @sql = ( "SELECT * FROM foo WHERE NOT EXISTS (SELECT bar FROM baz)", "SELECT * FROM (SELECT SUM (CASE WHEN me.artist = 'foo' THEN 1 ELSE 0 END AS artist_sum) FROM foobar) WHERE foo.a = 1 and foo.b LIKE 'station'", "SELECT COUNT( * ) FROM foo me JOIN bar rel_bar ON rel_bar.id_bar = me.fk_bar WHERE NOT EXISTS (SELECT inner_baz.id_baz FROM baz inner_baz WHERE ( ( inner_baz.fk_a != ? AND ( fk_bar = me.fk_bar AND name = me.name ) ) ) )", - "SELECT foo AS bar FROM baz ORDER BY x + ? DESC, baz.g", + "SELECT foo AS bar FROM baz ORDER BY x + ? DESC, oomph, y - ? DESC, unf, baz.g / ? ASC, buzz * 0 DESC, foo DESC, ickk ASC", ); # FIXME FIXME FIXME