|
|
Posted by Henri Schomδcker on 12/10/05 17:37
Ian Pawson wrote:
> I have had a similar problem with joins in 5 that work ok in 4. From the
> 5 help file this would seem to be due the a change in the optimization
> used to make it standards compliment. In your case it is dropping your
> column. In my case moving the position of the join in the query got it
> working in 5 but not in 4.
Hi Ian,
Fortunately, I got a similar answer in a german mysql newsgroup.
In my queries, there were two left joins and the other table mappings were
made by where statements.
I got the hint to replace the where mappings by inner joins which have to
stand before the left joins and NOT to separate the joins by kommata.
These queries now also work on mysql 4 & 5.
I also read the statement, that this new behaviour should/would be made
backwards-compatible again so old queries would work again. I directly
tried it with the newest mysql version but my queries didn't work.
So I edited the queries like I wrote and now everything is fine.
Many thanks for your answer.
Yours Henri
Navigation:
[Reply to this message]
|