Repository navigation
Full text query parse issue #282
Description
Activity
@jjxtra NpgsqlTsQuery.Parse aims to be a compatible C# implementation of the PostgreSQL parsing logic. This is something that Npgsql used to do, which we generally no longer believe is a good idea: the database driver should not be replicating complex database textual representation parsing logic, and this kind of bug is a good example why.
We've generally been removing client-side parsing (e.g. see #4902), I believe we should remove this as well. In the meantime, I highly recommend avoiding NpgsqlTsQuery.Parse and only using ToTsQuery, which ensures that PostgreSQL is the one doing the parsing.
I am comparing behavior of the
NpgsqlTypes.NpgsqlTsQuery.Parse(_query);vs just passing in my raw query string usingEF.Functions.ToTsQuery(_query).The short of the problem is that
EF.Functions.ToTsQuery(_query)behaves as expected, whileNpgsqlTypes.NpgsqlTsQuery.Parse(_query)seems to be stacking terms separated by|operators in a weird way and does not retrieve expected results on the server.Is the syntax for
NpgsqlTypes.NpgsqlTsQuery.Parse(_query)different fromEF.Functions.ToTsQuery(_query)?