Collected from the PG bugs email list.
|OS||Linux, kernel 4.18.16-arch1-1-ARCH|
|Reported by||Nikolajs Arhipovs|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 15488 Logged by: Nikolajs Arhipovs Email address: (redacted) PostgreSQL version: 9.6.8 Operating system: Linux, kernel 4.18.16-arch1-1-ARCH Description: I am trying to do prefix search of emails using full text search. Emails sometimes contain dot symbols. Now, select to_tsquery('simple', 'thing.a:*'); returns a single term as expected but select to_tsquery('simple', 'the.thing.a:*') suddenly tokenizes my search expression into 'the.thing':* & 'a':*. At the same time select to_tsquery('simple', 'the.thing.aa:*'); tokenizes as expected into a single term. Also select to_tsquery('simple', 'firstname.lastname@example.org'); returns a single term as expected, but select to_tsquery('simple', 'the.thing@gma:*'); splits on @ char and returns two tokens. This behavior is not covered in the official documentation.
|2018-11-06 12:51:58+00||=?utf-8?q?PG_Bug_reporting_form?=||BUG #15488: Unexpected behaviour of to_tsverctor and ts_query|
|2018-11-07 11:20:55+00||Arthur Zakirov||Re: BUG #15488: Unexpected behaviour of to_tsverctor and ts_query|