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
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
