Re: unexpected result from to_tsvector - Mailing list pgsql-hackers

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">2016-02-23 20:53 GMT+03:00 Artur Zakirov <span
dir="ltr"><<ahref="mailto:a.zakirov@postgrespro.ru" target="_blank">a.zakirov@postgrespro.ru</a>></span>:<br
/><blockquoteclass="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hello,<br/><br /> Here is a little patch. It fixes this issue <a
href="http://www.postgresql.org/message-id/20160217080048.26357.49416@wrigleys.postgresql.org"rel="noreferrer"
target="_blank">http://www.postgresql.org/message-id/20160217080048.26357.49416@wrigleys.postgresql.org</a><br/><br />
Withoutpatch we get wrong result for the second email '<a href="mailto:test@123-reg.ro"
target="_blank">test@123-reg.ro</a>':<br/><br /> => SELECT * FROM ts_debug('simple', '<a
href="mailto:test@vauban-reg.ro"target="_blank">test@vauban-reg.ro</a>');<br />  alias |  description  |       token   
   | dictionaries | dictionary |       lexemes<br />
-------+---------------+--------------------+--------------+------------+----------------------<br/>  email | Email
address| <a href="mailto:test@vauban-reg.ro" target="_blank">test@vauban-reg.ro</a> | {simple}     | simple  | {<a
href="mailto:test@vauban-reg.ro"target="_blank">test@vauban-reg.ro</a>}<br /> (1 row)<br /><br /> => SELECT * FROM
ts_debug('simple','<a href="mailto:test@123-reg.ro" target="_blank">test@123-reg.ro</a>');<br />    alias   | 
 description   | token  | dictionaries | dictionary | lexemes<br />
-----------+------------------+--------+--------------+------------+----------<br/>  asciiword | Word, all ASCII  |
test  | {simple}     | simple     | {test}<br />  blank     | Space symbols    | @      | {}           |           
|<br/>  uint      | Unsigned integer | 123    | {simple}     | simple     | {123}<br />  blank     | Space symbols    |
-     | {}           |            |<br />  host      | Host             | <a href="http://reg.ro" rel="noreferrer"
target="_blank">reg.ro</a>| {simple}     | simple     | {<a href="http://reg.ro" rel="noreferrer"
target="_blank">reg.ro</a>}<br/> (5 rows)<br /><br /> After patch we get correct result for the second email:<br /><br
/>=> SELECT * FROM ts_debug('simple', '<a href="mailto:test@123-reg.ro" target="_blank">test@123-reg.ro</a>');<br />
 alias|  description  |      token      | dictionaries | dictionary |       lexemes<br />
-------+---------------+-----------------+--------------+------------+----------------------<br/>  email | Email
address| <a href="mailto:test@123-reg.ro" target="_blank">test@123-reg.ro</a> | {simple}     | simple  | {<a
href="mailto:test@123-reg.ro"target="_blank">test@123-reg.ro</a>}<br /> (1 row)<br /><br /> This patch allows to parser
workwith emails '<a href="mailto:test@123-reg.ro" target="_blank">test@123-reg.ro</a>', '<a
href="mailto:123@123-reg.ro"target="_blank">123@123-reg.ro</a>' and '<a href="mailto:test@123_reg.ro"
target="_blank">test@123_reg.ro</a>'correctly.<span class=""><font color="#888888"><br /><br /> -- <br /> Artur
Zakirov<br/> Postgres Professional: <a href="http://www.postgrespro.com" rel="noreferrer"
target="_blank">http://www.postgrespro.com</a><br/> Russian Postgres Company<br /></font></span><br /><br /> --<br />
Sentvia pgsql-hackers mailing list (<a href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br
/>To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-hackers"
rel="noreferrer"target="_blank">http://www.postgresql.org/mailpref/pgsql-hackers</a><br /><br /></blockquote></div><br
/></div><divclass="gmail_extra">Hello,<br /><br /></div><div class="gmail_extra">Should we added tests for this
case?<br/><br /><a href="http://123_reg.ro">123_reg.ro</a> is not valid domain name, bacause of symbol "_"<br
/></div><divclass="gmail_extra"><br /><a
href="https://tools.ietf.org/html/rfc1035">https://tools.ietf.org/html/rfc1035</a>page 8.<br /><br /></div><div
class="gmail_extra">DmitriiGolub<br /></div></div>