[GRASS-dev] v.extract break where condition

[Markus Metz]

On Tue, Sep 4, 2012 at 11:42 AM, Luca Delucchi <lucadeluge at gmail.com> wrote:
> 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.

Please try trunk r53079. If it works for you, it can be backported.

Markus M

>
> 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
> _______________________________________________
> grass-dev mailing list
> grass-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-dev