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

[Alexander Golovko]

On Tue, 29 May 2012 11:53:10 -0700, Corey Hickey wrote:
> 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;

I add your patch to master branch. thank you!


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

-- 
with best regards,
Alexander Golovko
email: alexandro at ankalagon.ru
xmpp: alexandro at ankalagon.ru