Re: Bacula 15.0.2 update

On 5/10/24 12:15, Phil Stracchino wrote:
> On 5/10/24 07:40, Martin Simmons wrote:
>> No, FileIndex is signed in the File table at least (-ve is used to mark
>> deleted files in an accurate backup).
> 
> Then should it not be signed *everywhere*?  Or are these just a group of
> disparate columns not used outside their tables that just HAPPEN to all
> have the same name?
> 
> And should it be allowed to be NULLable?


And FileMedia.FileIndex in particular is just broken.  It is currently 
declared INT UNSIGNED NOT NULL with no DEFAULT.  When no DEFAULT is 
specified and STRICT mode is in use the implicit default is NULL, which 
gives NOT NULL DEFAULT NULL, which, well ....  at least doesn't actually 
*crash mysqld* any more.  (It used to, in 5.1.)



-- 
   Phil Stracchino
   Fenian House Publishing
   [email protected]
   [email protected]
   Landline: +1.603.293.8485
   Mobile:   +1.603.998.6958