Re: [BUGS] BUG #6314: The like command does not handle a long string of special chars

[Kevin Grittner]

<d.reri...@healthcareoss.com> wrote:
 
> Simply set a varchar field in your db to the following string:
> !&quot;#$%&#39;()*+,-/:;=?@[\]^_`{|}~0000&amp;&lt;&gt;
 
Do you have standard_conforming_strings = on?
 
> The like command works fine up with escapes up to:
> !&quot;#$%&#39;&#39;()*+,-/:;=?@[%
> Notice, I added the % to the end. However, if you go any further -
> no matches:
> !&quot;#$%&#39;&#39;()*+,-/:;=?@[\\%
> Strangely, this works and shouldn&#39;t:
> !&quot;#$%&#39;&#39;()*+,-/:;=?@[\%
 
It is always better to include a self-contained test case.  For
example:
 
test=# set standard_conforming_strings = on;
SET
test=# create table t (v text not null);
CREATE TABLE
test=# insert into t values
('!&quot;#$%&#39;()*+,-/:;=?@[\]^_`{|}~0000&amp;&lt;&gt;');
INSERT 0 1
test=# select * from t where v like
'!&quot;#$\%&#39;()*+,-/:;=?@[\\]^_`{|}~0000&amp;&lt;&gt%'
escape '\';
                           v                            
--------------------------------------------------------
 !&quot;#$%&#39;()*+,-/:;=?@[\]^_`{|}~0000&amp;&lt;&gt;
(1 row)
 
So this is not a bug on HEAD.  What do you get when you run it?
 
-Kevin

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs