X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14roundtrippin.t;h=bfb713fb6f0c403b098391413c908fc9f1ae4926;hb=0ec2e26564ab5809a4b1c76ca7b3084c7a06fccd;hp=3b631d3cf751fac67f281041e813ab007ff2a19a;hpb=4247c384fc4291dab9ad93625b267e862b2c9906;p=scpubgit%2FQ-Branch.git diff --git a/t/14roundtrippin.t b/t/14roundtrippin.t index 3b631d3..bfb713f 100644 --- a/t/14roundtrippin.t +++ b/t/14roundtrippin.t @@ -27,6 +27,7 @@ my @sql = ( "SELECT * FROM foo WHERE foo.a @@ to_tsquery('word')", "SELECT * FROM foo ORDER BY name + ?, [me].[id]", "SELECT foo AS bar FROM baz ORDER BY x + ? DESC, baz.g", + "SELECT [me].[id], ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS [rno__row__index] FROM ( SELECT [me].[id] FROM [LogParents] [me]) [me]", # deliberate batshit insanity "SELECT foo FROM bar WHERE > 12", );