[GRASS5] Re: [bug #4056] (grass) db.test fails on sqlite driver

[Markus Neteler]

On Fri, Feb 17, 2006 at 06:04:33PM +0100, Maciek Sieczka via RT wrote:
> Radim wrote to the grasslist on 2006.02.17:
> 
> ---
> select c1 from grass_test1 where d1 < 500 / 2 and i1 <> 2  and c1 ~ 'bc'
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():select c1 from grass_test1 where d1 < 500 / 2 and
> i1 <> 2  and c1 ~ 'bc'
> near "~": syntax error
> EXECUTE: ******** ERROR ********
> 
> '~' is not SQL standard, this is not a bug.
> ---
> 

I consider it as bug as SQLite supports '~':

http://www.sqlite.org/lang_expr.html

"Supported unary operators are these:

 -    +    !    ~
"

Question is if it is probably not passed correctly to sqlite?

Markus