[GRASS-user] Re: grass-user Digest, Vol 47, Issue 30

[Richard Chirgwin]

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 ...

Richard
> ...
>   
>> 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.
>
> Markus
>
>