Re: Flaky MySQL?
Still looking...
Say, does it matter at all if you move the non-joining conditions from the on clause to the WHERE clause?
I mean things like :
INNER JOIn ....
ON cd.RIC = eq.RIC
..
..
WHERE ...
AND (
cd.Div_Feature NOT IN (10, 30, 33)
OR (cd.Div_Feature IN (10, 30, 33)
AND NOT EXISTS (
SELECT *
FROM corax_dividends cd2
WHERE cd.RIC = cd2.RIC
AND cd.Div_PILC = cd2.Div_PILC
AND cd.Div_Pay_Date = cd2.Div_Pay_Date
AND cd.Ex_Dividend_Date = cd2.Ex_Dividend_Date
AND cd2.Div_Feature IN (11, 31, 34)
)
)
)
in favour of:
INNER JOIN ...
ON cd.RIC = eq.RIC
AND (
cd.Div_Feature NOT IN (10, 30, 33)
OR (cd.Div_Feature IN (10, 30, 33)
AND NOT EXISTS (
SELECT *
FROM corax_dividends cd2
WHERE cd.RIC = cd2.RIC
AND cd.Div_PILC = cd2.Div_PILC
AND cd.Div_Pay_Date = cd2.Div_Pay_Date
AND cd.Ex_Dividend_Date = cd2.Ex_Dividend_Date
AND cd2.Div_Feature IN (11, 31, 34)
)
)
)
...
...
WHERE