Since we updated to the newest MySQL version (Windows) some of our queries do not work any more.
It's reproducable by this (dummy) query:
SELECT B.ID from ((SELECT * from A) AS T1
INNER JOIN B a ON B.ID = T1.ID);
This works with 4.1.7, but not with 4.1.11, unless the parentheses are removed:
SELECT B.ID from (SELECT * from A) AS T1
INNER JOIN B a ON B.ID = T1.ID;
Does anybody know why MySQL changed its behaviour that way?
I know the parentheses in the first query are not necessary, but it would be quite difficult to search through all our queries for unnecessary parentheses.
Thank you very much,
Anne
It's reproducable by this (dummy) query:
SELECT B.ID from ((SELECT * from A) AS T1
INNER JOIN B a ON B.ID = T1.ID);
This works with 4.1.7, but not with 4.1.11, unless the parentheses are removed:
SELECT B.ID from (SELECT * from A) AS T1
INNER JOIN B a ON B.ID = T1.ID;
Does anybody know why MySQL changed its behaviour that way?
I know the parentheses in the first query are not necessary, but it would be quite difficult to search through all our queries for unnecessary parentheses.
Thank you very much,
Anne