grass

grass copied to clipboard

Describe the bug

Opening attribute table manager with DBF database backend for a vector map:

DBMI-DBF driver error:
SQL parser error (syntax error, unexpected $end, expecting NAME or '*' processing '') in statement:
SELECT "cat","AREA","PERIMETER","NMGEOL_DD_","NMGEOL_DD1","ORIG_LABEL","SGMC_LABEL","UNIT_LINK","SOURCE","UNIT_AGE","ROCKTYPE1","ROCKTYPE2","GRASSRGB","Rocktype1c" FROM nmgeol_dd_polygon
Unable to open cursor.

I believe the quotes are the problem here, looks like DBF doesn't support that, but I haven't found anything specific about this. Introduced in #3634.

Expected behavior

It behaves fine when data is connected to sqlite through v.db.reconnect.all

Additional context

DBF is legacy but it is still supported, no? Originally reported by David Farris