[Koha] koha or mysql 5 bug?

[Wojciech Zatorski]

Hello Wojciech,

Tuesday, February 7, 2006, 4:31:23 PM, you wrote:

ok this is KOHA problem:

 http://bugs.mysql.com/bug.php?id=14047

Yes, this is new, but correct behaviour ob 5.0.12 and newer versions. It is
documented (http://dev.mysql.com/doc/refman/5.0/en/join.html):

"This means that some queries that appeared to work correctly prior to 5.0.12
must be rewritten to comply with the standard. For example, a query of the form 

SELECT t1.id,t2.id,t3.id
    FROM t1,t2 
    LEFT JOIN t3 ON (t3.id=t1.id)
    WHERE t1.id=t2.id;

will be interpreted in MySQL 5.0.12 and later as

SELECT t1.id,t2.id,t3.id 
    FROM t1,(  t2 LEFT JOIN t3 ON (t3.id=t1.id)  )
    WHERE t1.id=t2.id;

Such a query must now be written like so:

SELECT t1.id,t2.id,t3.id 
    FROM (t1,t2) 
    LEFT JOIN t3 ON (t3.id=t1.id)
    WHERE t1.id=t2.id;"

-- 
<wojciech at zatorski.net>
tel. +48 509-855-239; GG: 1500861; Skype: zatorski
http://www.Zatorski.Net
--
You cannot kill time without injuring eternity.  -- Thoreau