Opened 19 years ago

Closed 9 years ago

#899 closed enhancement (fixed)

lack of ESCAPE support in the LIKE

Reported by: bartvde@… Owned by: warmerdam
Priority: normal Milestone:
Component: OGR_SF Version: unspecified
Severity: normal Keywords: OGRSQL
Cc:

Description (last modified by warmerdam) 

OGR SQL does not support ESCAPE for LIKE filters.

>   The sql like operator is defined something like this :
>     string LIKE pattern [ESCAPE escape-character]
>
>   The escape character is used to escape special characters such as %
> and underscore.  It should be valid in both postgres and orcale sql from
> waht I know. I have tested it with postgres and it seemns to be valid
> (http://www.postgresql.org/docs/8.0/interactive/functions-matching.html).

Change History (2)

comment:1 by warmerdam, 16 years ago

Description: modified (diff)
Keywords: OGRSQL added
Priority: high → normal
Type: defect → enhancement

comment:2 by Jukka Rahkonen, 9 years ago

Resolution: → fixed
Status: new → closed

Seems to be implemented and documented in ​http://www.gdal.org/ogr_sql.html "An optional ESCAPE escape_char clause can be added so that the percent or underscore characters can be searched as regular characters, by being preceded with the escape_char."

Because it looks like I have enough rights for closing tickets I will use my power in this trivial case.

Note: See TracTickets for help on using tickets.