Hello, I have a native update query using some variables and so one. It works great when I am using it via phpMyAdmin. Executing the same sql query via doctrine results into a slighty different result.
I haven't found out what is wrong with the query: UPDATE leaderboard lb, > > ( > > SELECT > > l.id, @points:= l.field1 + l.field2, > > @curRank:=if(@points <> @lastPoints, @curRank + 1, @curRank) AS rank, > > @lastPoints:=@points as points > > FROM leaderboard l, (SELECT @curRank := 0) r, (SELECT @lastPoints := >> 0) lp, (SELECT @points := 0) pts, players p IGNORE INDEX >> (IDX_264E43A6BEFCA0A4) > > WHERE l.id = p.id AND p.gameRound_id = 3 > > ORDER BY l.field1 + l.field2 DESC > > ) c > > SET lb.rank = c.rank WHERE lb.id = c.id > > Can you help me to debug this issue? Is there any possibility to activate some more detailed log of the dbal? Cheers, Marcel -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
