[OODT-48] WildcardExpression in XMLPS generates incorrect SQL

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.1-incubating
• Component/s: xmlps

Environment

testing with CHLA

• Assignee: Chris A. Mattmann
• Reporter: Chris A. Mattmann
• Created: 15/Oct/10 22:36
• Updated: 15/Oct/10 23:02
• Resolved: 15/Oct/10 23:02

Description

As it turns out the WildcardExpression in XMLPS incorrectly generates SQL where clauses of the form:

WHERE
  <term> LIKE %'<value>'%

instead of:

WHERE
  <term> LIKE '%<value>%'

No one is screaming about it yet, but they will so I'll fix it.