[pkg-bacula-devel] Bug#674809: Bug#674809: (bacula-director-mysql: failure with mysql 5.5: MaxValue is now a keyword)

[Corey Hickey]

On 2012-05-29 07:28, Alexander Golovko wrote:
> Hi!
>
> Thank you for bugreport!
> Can you say, what is wrong with upstream patch (bug 5104 in upstream
> bugtracker)?

Assuming you mean bug 1504, that patch is incomplete--it fixes table 
creation, but not access.

As for the problem with the patch in the URL I originally sent, the 
issue is that mysql considers columns to be "identifiers", and the way 
to quote an identifier is to use backticks.

wrong: select "MaxValue" from Counters;
right: select `MaxValue" from Counters;

An alternative (which looks to have gone into the source upstream) is to 
fully qualify the column names.

right: select Counters.MaxValue from Counters;

> bacula-director-mysql can be sucessfully installed after building with
> upstream patch.
>
> Are your package building problems with mysql 5.5 covered by bug
> 672765?
> If so, this was already fixed in git repo.

Yes, that looks like it. Thanks!

-Corey