X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14roundtrippin.t;h=2dd026b2d737f428a36fbd812cbc27b2eebeffcd;hb=60f3fd3f62543eeefdf2ec711b085e360fe89c6e;hp=bfb713fb6f0c403b098391413c908fc9f1ae4926;hpb=0ec2e26564ab5809a4b1c76ca7b3084c7a06fccd;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/14roundtrippin.t b/t/14roundtrippin.t index bfb713f..2dd026b 100644 --- a/t/14roundtrippin.t +++ b/t/14roundtrippin.t @@ -30,6 +30,8 @@ my @sql = ( "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