Add failing tests for PostgreSQL's @@ text search operator

[dbsrgits/SQL-Abstract.git] / t / 14roundtrippin.t

diff --git a/t/14roundtrippin.t b/t/14roundtrippin.t
index a7d4269..3680b73 100644 (file)
--- 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",
 );