[GRASS-dev] [GRASS GIS] #1866: broken SQLite driver in winGRASS 7

[GRASS GIS]

#1866: broken SQLite driver in winGRASS 7
------------------------------+---------------------------------------------
 Reporter:  martinl           |       Owner:  grass-dev@…              
     Type:  defect            |      Status:  new                      
 Priority:  blocker           |   Milestone:  7.0.0                    
Component:  Database          |     Version:  unspecified              
 Keywords:  sqlite, wingrass  |    Platform:  MSWindows 2K             
      Cpu:  Unspecified       |  
------------------------------+---------------------------------------------

Comment(by mmetz):

 Replying to [comment:8 mmetz]:
 > Replying to [comment:7 martinl]:
 > > Replying to [comment:6 mmetz]:
 > >
 > > > I get exactly the same behaviour with the dbf driver: nothing
 happens, no error message and the driver hangs.
 > >
 > > strangely, in GRASS 6 both DBF and SQLite seems to work.
 >
 > Strangely, in GRASS 7 both DBF and SQLite driver seem to work. What is
 broken is the pipe for sending data back and forth between the module and
 the driver.

 I added some more debug info and get for `db.describe boundary_county`

 {{{
 D0/0: send column name: cat
 D0/0: D0/0: receive string of len: 4
 D0/0: string alloc: 0
 D0/0: string received: cat
 D0/0: column name: cat
 D0/0: receive string of len: 1
 D0/0: string alloc: 0
 D0/0: string received:
 send column name: AREA
 D0/0: D0/0: receive string of len: 5
 D0/0: string alloc: 0
 D0/0: string received: AREA
 D0/0: column name: AREA
 D0/0: receive string of len: 1
 D0/0: string alloc: 0
 D0/0: string received:
 send column name: PERIMETER
 D0/0: D0/0: receive string of len: 2573
 D0/0: string alloc: 0
 send column name: FIPS
 D0/0: send column name: NAME
 D0/0: send column name: NAME_LOCAS
 D0/0: send column name: DOT_DISTRI
 D0/0: send column name: DOT_DIVISI
 D0/0: send column name: DOT_COUNTY
 D0/0: send column name: COUNTY_100
 D0/0: send column name: DOT_GROUP_
 D0/0: send column name: ACRES
 D0/0: send column name: ABBR_5CHAR
 D0/0: send column name: ABBR_4CHAR
 D0/0: send column name: ABBR_2CHAR
 D0/0: send column name: Z_MEAN
 D0/0: send column name: Z_MIN
 D0/0: send column name: Z_MAX
 D0/0: send column name: Z_ZONE
 D0/0: send column name: CO_CENSUS
 D0/0: send column name: DIV_CONTAC
 D0/0: send column name: DIST_CONTA
 D0/0: send column name: CO_WIKIPED
 D0/0: send column name: Shape_Leng
 D0/0: send column name: Shape_Area
 }}}

 Apparently the receiving end of the pipe [0] is broken. Anybody has any
 idea how this could happen? There are no obvious differences in the code
 base between 6.4. and 7.0.

 Markus M

 [0]
 https://trac.osgeo.org/grass/browser/grass/trunk/lib/db/dbmi_client/start.c#L130

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