ivh/VAMDC-VALD — Issue #53: LIKE not implemented completely
Author: xnx
Created: 2012-02-24 09:52:18+00:00
State: open

In the node software (sqlparse.py, restriction2Q), LIKE clauses are mapped to Django's __contains, __endswith, and __startswith methods. This does not completely implement the SQL LIKE clause (e.g. the single-character '_' wildcard is not implemented, multiple '%' wildcards are not implemented).
Misha's Java node software does implement SQL LIKE, so he likes the idea of allowing it. I'm not so sure.
One (major!) problem is that nowhere in the VSS2 standards does it state explicitly which SQL relations are permitted or how they will be interpreted.