[GRASS-user] Re: grass-user Digest, Vol 47, Issue 30
rchirgwin at ozemail.com.au
Sat Mar 13 14:45:29 EST 2010
Markus Neteler wrote:
> Hi Richard,
> On Fri, Mar 12, 2010 at 11:55 PM, Richard Chirgwin
> <rchirgwin at ozemail.com.au> wrote:
>> The Grass-GIS database driver doesn't implement support for the full MySQL
>> command set. In particular, I don't think joins are supported.
> Are you sure about this? I thought that the driver just hands over the SQL
> stuff to MySQL.
Well, maybe not the Grass-GIS driver - perhaps the MySQL driver - but
there are queries that always produce a MySQL error if they're attempted
in Grass-GIS, but work in MySQL.
I'll try to find one of them and report back ... I'd always just
shrugged and swapped to MySQL if I bumped into this, so I haven't
actually recorded any of them!
Right now, I've got Grass-GIS reprojecting a DEM from lat-long to
Lambert and it's taking quite some time, so I'm not sure when I'll get
to this ...
>> I'm pretty certain a complex join would end up beyond the Grass-GIS database
>> driver, though.
> If you know MySQL, please try and report - I am not familiar with it and it
> is somehow different from PostgreSQL which I know more.
More information about the grass-user