Re: update fails... any suggestions?

[Warren Young]

On 7/14/2011 12:10 PM, Jay Sprenkle wrote:
> If you don't grant permission for update to the user used in the connection
> the library crashes instead of throwing an exception.

That's not what I see here, using examples/tquery4.  I created a user 
that only has SELECT permissions, and on running it, I get this:

> Query: update stock set num = 70 where num < 70
> Query error: UPDATE command denied to user 'jay'@'mongo' for table 'stock'

The second line is a caught exception.

If I get rid of the BadQuery catch clause, forcing it to use the more 
generic mysqlpp::Exception clause to be more like your case, it still 
works as expected.