[GRASS-dev] db.execute segfaults on simplest SQL query

[Moritz Lennert]

On Mon, October 8, 2007 22:08, Maciej Sieczka wrote:
> This works:
>
> $ v.db.select pts_out col=rast_val
> rast_val
> 108.3656
> 102.906
> 41.60993
>
> but, it's SQL counterpart segfaults:
>
> $ echo "SELECT rast_val FROM pts_out" | db.execute
> Segmentation fault
> dbmi: Protocol error
> ERROR: Error while executing: 'SELECT rast_val FROM pts_out
>        '

All select queries need to be sent via db.select. All other queries via
db.execute. I.e. try

$ echo "SELECT rast_val FROM pts_out" | db.select

Moritz