[GRASS-dev] [GRASS GIS] #1901: v.mkgrid near ", ": syntax error, no batch insert

GRASS GIS trac at osgeo.org
Fri Mar 1 06:20:44 PST 2013

#1901: v.mkgrid near ",": syntax error, no batch insert
 Reporter:  pertusus     |       Owner:  grass-dev@…              
     Type:  defect       |      Status:  new                      
 Priority:  normal       |   Milestone:  7.0.0                    
Component:  Vector       |     Version:  svn-trunk                
 Keywords:  v.mkgrid     |    Platform:  Linux                    
      Cpu:  Unspecified  |  

Comment(by mmetz):

 Replying to [comment:2 pertusus]:
 > I use a centos 6, by no mean an old platform, but sqlite here is
 sqlite-3.6.20, thus I think that relying, in the default case on that
 feature is not a good idea. Updating system sqlite is a very bad idea,
 using a non system sqlite for grass is very impractical (and prevents
 updating packages).
 > Also, I read the standard
 http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt, and it seems to
 me that the "63)Subclause 13.8" says that for "Entry SQL" there should
 only be one value, which explains why this feature is that badly
 implemented in SQL implementations. According to the sqlite news, sqlite
 3.7.11 dates from 2012-March-20!

 I have fixed r53891 in r55271. No more batch insert, but the module is now
 about 50x faster than the batch insert, using old-fashioned begin/commit

 Markus M

Ticket URL: <http://trac.osgeo.org/grass/ticket/1901#comment:3>
GRASS GIS <http://grass.osgeo.org>

More information about the grass-dev mailing list