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

From: d(dot)rericha(at)healthcareoss(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6314: The like command does not handle a long string of special chars
Date: 2011-12-01 17:40:24
Message-ID: E1RWAcS-0007Qi-OD@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6314
Logged by: David Rericha
Email address: d(dot)rericha(at)healthcareoss(dot)com
PostgreSQL version: 8.4.5
Operating system: OpenSuSE 11.4 64-bit
Description:

Simply set a varchar field in your db to the following string:
!"#$%'()*+,-/:;=?(at)[\]^_`{|}~0000&<>

I know, I know, who would do this, right? Well, its for a certification.
The like command works fine up with escapes up to:
!"#$%''()*+,-/:;=?(at)[%
Notice, I added the % to the end. However, if you go any further - no
matches:
!"#$%''()*+,-/:;=?(at)[\\%
Strangely, this works and shouldn't:
!"#$%''()*+,-/:;=?(at)[\%

Thanks.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-12-01 17:53:56 Re: 9.1.1 hot standby startup gets sigbus
Previous Message Tom Lane 2011-12-01 16:54:28 Re: BUG #6313: Deadlock reporting contains not enought details