X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14roundtrippin.t;h=2dd026b2d737f428a36fbd812cbc27b2eebeffcd;hb=b011372e0f96a4cbad8d03efb12bbff11ae9d53a;hp=3b631d3cf751fac67f281041e813ab007ff2a19a;hpb=1f00df9fde149ba81f014d6fa1a7d304ac2e4b08;p=dbsrgits%2FSQL-Abstract.git

diff --git a/t/14roundtrippin.t b/t/14roundtrippin.t
index 3b631d3..2dd026b 100644
--- a/t/14roundtrippin.t
+++ b/t/14roundtrippin.t
@@ -27,8 +27,11 @@ 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",
+  'SELECT ilike_any_or FROM bar WHERE ( baz ILIKE ANY(?) OR bat ILIKE ANY(?) )',
+  'SELECT regexp_or FROM bar WHERE ( baz REGEXP ? OR bat REGEXP ? )',
 );
 
 # FIXME FIXME FIXME