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>
On Tue, Sep 4, 2012 at 11:42 AM, Luca Delucchi <lucadeluge@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>
2012/9/4 Markus Metz <markus.metz.giswork@gmail.com>:
On Tue, Sep 4, 2012 at 11:42 AM, Luca Delucchi <lucadeluge@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.
On Tue, Sep 4, 2012 at 1:48 PM, Luca Delucchi <lucadeluge@gmail.com> wrote:
2012/9/4 Markus Metz <markus.metz.giswork@gmail.com>:
On Tue, Sep 4, 2012 at 11:42 AM, Luca Delucchi <lucadeluge@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.
it works, thanks a lot
There are also other differences (look like bugfixes), I guess there is
even more to backport in that file.
On Thu, Sep 6, 2012 at 10:33 AM, Markus Neteler <neteler@osgeo.org> wrote:
On Tue, Sep 4, 2012 at 1:48 PM, Luca Delucchi <lucadeluge@gmail.com> wrote:
2012/9/4 Markus Metz <markus.metz.giswork@gmail.com>:
On Tue, Sep 4, 2012 at 11:42 AM, Luca Delucchi <lucadeluge@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.
it works, thanks a lot
There are also other differences (look like bugfixes), I guess there is
even more to backport in that file.
All bugfixes have been backported in r53109 and r53110, devbr6 and
relbr64, respectively.