[GRASS-dev] lib/db/sqlp: how to activate "LIKE" for dbf?

[Glynn Clements]

Markus Neteler wrote:

> Hi,
> 
> I would like the SQL 'LIKE' to be functional for the
> dbf driver. While '~' is working, 'LIKE' is rejected.
> I assume (also tried a bit) that 'LIKE' needs to be
> mapped to '~' (COMPARISON_OPERATOR, SQL_MTCH) to be passed
> on to the dbf driver.
> 
> I didn't manage to implement it right in lib/db/sqlp.
> Ideas?

I would think that adding:

[Ll][Ii][Kk][Ee]	{
				yylval.strval = (char*)strdup("~");
				return COMPARISON_OPERATOR;
			}

to lib/db/sqlp/lex.l should suffice.

-- 
Glynn Clements <glynn at gclements.plus.com>