Tracker: Bugs

5 SQL: LIKE doesn't ignore invalid escapes - ID: 2830900
Last Update: Comment added ( mr-meltdown )

SELECT 'be_r' LIKE 'b_e__r' ESCAPE '_' AS "true";

returns false, because it doesn't ignore the invalid '_e' (compare to '\e')
escape.

test in pg_regress/strings_like


Fabian ( mr-meltdown ) - 2009-08-01 19:49

5

Closed

Fixed

Fabian

SQL/Core

SQL "stable"

Public


Comment ( 1 )

Date: 2009-08-02 09:25
Sender: mr-meltdown

fixed in Stable, will first appear in next feature release


Attached File

No Files Currently Attached

Changes ( 3 )

Field Old Value Date By
status_id Open 2009-08-02 09:25 mr-meltdown
resolution_id None 2009-08-02 09:25 mr-meltdown
close_date - 2009-08-02 09:25 mr-meltdown