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

[GRASS GIS]

#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  |  
-------------------------+--------------------------------------------------
Changes (by marisn):

  * keywords:  => v.mkgrid


Comment:

 Multirow inserts are valid since SQL-92. I would still stay on side, that
 this feature should be left as is as speed difference on large grids is
 enormous but non-SQL-92 RDBMSes are disappearing.

 According to Wikipedia: "This feature is supported by DB2, SQL Server
 (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL,
 sqlite (since version 3.7.11) and H2". Solution - upgrade sqlite.

 Second option - add extra logic to switch to slingle row inserts if
 multirow fails. Still I have no time now to implement it.

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