X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14roundtrippin.t;h=3680b7378503730a9e1a5370e447340e9c7550dc;hb=reassembly-bugs;hp=a7d426937fc225f520f5d9e5b0d48cf95d5afcc0;hpb=bb2b3c697575825df289748a19e61cd407a492e8;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/14roundtrippin.t b/t/14roundtrippin.t index a7d4269..3680b73 100644 --- a/t/14roundtrippin.t +++ b/t/14roundtrippin.t @@ -39,6 +39,8 @@ my @sql = ( 'SELECT me.id, me.lsegcol FROM geomtest WHERE lsegcol \?-| ?', 'SELECT me.id, me.lsegcol FROM geomtest WHERE lsegcol \?|| ?', 'SELECT me.id, me.lsegcol FROM geomtest WHERE lsegcol \?# ?', + 'SELECT textsearch FROM textsearchtest WHERE foo = ? AND textsearch @@ plainto_tsquery(?)', + 'SELECT textsearch FROM textsearchtest WHERE foo = ? OR textsearch @@ plainto_tsquery(?)', # deliberate batshit insanity "SELECT foo FROM bar WHERE > 12", );