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

[Maciek Sieczka via RT]

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.
---

So what to do with it? Good to know it is not a bug in sqlite driver, but it
remains a bug in db.test. It may scare naive users and prevent from using
sqlite, too bad. Well, it scarred me. Gosh, I'm naive.

Maciek


-------------------------------------------- Managed by Request Tracker