[Bacula-devel] Bug#2584: MySQL schema broken for MariaDB 10.5

2020-11-28 Thread Sven Hartge
Hallo .*, This references https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=975970 and https://bugs.bacula.org/view.php?id=2584, both filed by Radoslav Bodó, the latter on my request. It seems MariaDB 10.5 has stricter schema checking when using foreign keys and references. (Yes, I know, MariaDB

Re: [Bacula-devel] Bug#2584: MySQL schema broken for MariaDB 10.5

2020-11-28 Thread Radoslav Bodó
> 3) Referenced Columns need to exist. > > BaseFiles.BaseJobId REFERENCES Job, but table Job does not contain > BaseJobId, so this fails as well. It's not important for the root issue, but Sven insisted to comment that anyway. To be complete I think that point of BaseFiles.BaseJobId is to referen

Re: [Bacula-devel] Bug#2584: MySQL schema broken for MariaDB 10.5

2020-11-28 Thread Phil Stracchino
On 11/28/20 2:14 PM, Radoslav Bodó wrote: >> 3) Referenced Columns need to exist. >> >> BaseFiles.BaseJobId REFERENCES Job, but table Job does not contain >> BaseJobId, so this fails as well. > > It's not important for the root issue, but Sven insisted to comment that > anyway. To be complete I th