[GRASS-dev] v.extract break where condition

[Luca Delucchi]

I find that v.extract break where condition after 985 characters. I
try it with grass 6.4svn and grass7 and in both I have an error. If
this is a bug I think we should try to fix before 6.4.3 release.

v.extract in=punti_trappole7 out=data_02_10_2009_7
where="(id='AUT-05a') OR (id='AUT-05b') OR (id='AUT-05i') OR
(id='AUT-06d') OR (id='CHI-02a') OR (id='CHI-03b') OR (id='CHI-04a')
OR (id='CHI-04b') OR (id='CHI-05b') OR (id='CHI-06b') OR
(id='CHI-07a') OR (id='CHI-08b') OR (id='CHI-09a') OR (id='CHI-09b')
OR (id='CHI-10a') OR (id='CHI-10b') OR (id='CHI-11b') OR
(id='CHI-14a') OR (id='CHI-15b') OR (id='CHI-16b') OR (id='CHI-17b')
OR (id='CHI-18a') OR (id='NOV-03a') OR (id='NOV-03b') OR
(id='NOV-04a') OR (id='NOV-05b') OR (id='NOV-06a') OR (id='NOV-10a')
OR (id='NOV-12a') OR (id='NOV-12b') OR (id='NOV-13a') OR
(id='NOV-14b') OR (id='NOV-16b') OR (id='NOV-17a') OR (id='STA-02b')
OR (id='STA-08a') OR (id='STA-20a') OR (id='VAC-01a') OR
(id='VAC-02a') OR (id='VAC-03a') OR (id='VAC-04a') OR (id='VAC-04b')
OR (id='VAC-05b') OR (id='VAC-06b') OR (id='VAC-07a') OR
(id='VAC-07b') OR (id='VAC-08b') OR (id='VAC-10a') OR (id='VAC-10b')
OR (id='VAC-12b') OR (id='VAC-13a') OR (id='VAC-13b') OR
(id='VAC-14a') OR (id='VAC-14b') OR (id='VAC-15b') OR (id='VAC-17a')
OR (id='VAC-17b') OR (id='MAS-10b')"
DBMI-SQLite driver error:
Error in sqlite3_prepare():
SELECT cat FROM punti_trappole7 WHERE (id='AUT-05a') OR (id='AUT-05b')
OR (id='AUT-05i') OR (id='AUT-06d') OR (id='CHI-02a') OR
(id='CHI-03b') OR (id='CHI-04a') OR (id='CHI-04b') OR (id='CHI-05b')
OR (id='CHI-06b') OR (id='CHI-07a') OR (id='CHI-08b') OR
(id='CHI-09a') OR (id='CHI-09b') OR (id='CHI-10a') OR (id='CHI-10b')
OR (id='CHI-11b') OR (id='CHI-14a') OR (id='CHI-15b') OR
(id='CHI-16b') OR (id='CHI-17b') OR (id='CHI-18a') OR (id='NOV-03a')
OR (id='NOV-03b') OR (id='NOV-04a') OR (id='NOV-05b') OR
(id='NOV-06a') OR (id='NOV-10a') OR (id='NOV-12a') OR (id='NOV-12b')
OR (id='NOV-13a') OR (id='NOV-14b') OR (id='NOV-16b') OR
(id='NOV-17a') OR (id='STA-02b') OR (id='STA-08a') OR (id='STA-20a')
OR (id='VAC-01a') OR (id='VAC-02a') OR (id='VAC-03a') OR
(id='VAC-04a') OR (id='VAC-04b') OR (id='VAC-05b') OR (id='VAC-06b')
OR (id='VAC-07a') OR (id='VAC-07b') OR (id='VAC-08b') OR
(id='VAC-10a') OR (id='VAC-10b') OR (id='VAC-12b') OR (id='VAC-13a')
OR (id='VAC-13b') OR (id='VAC-14a') OR (id='VAC-14b') OR (id='VAC-15b
unrecognized token: "'VAC-15b"

ERROR: Unable select records from table <punti_trappole7>

-- 
ciao
Luca

http://gis.cri.fmach.it/delucchi/
www.lucadelu.org