P4DTI issue job001697

TitleMySQL 5.0 breaks P4DTI
Assigned userNick Barnes
DescriptionThe SQL syntax understood by MySQL changes between MySQL 4.x and MySQL 5.x. In particular, it is now sensitive to the order of tables in a LEFT JOIN statement (SELECT ... FROM a, b LEFT JOIN c ... is now different from SELECT ... FROM b, a LEFT JOIN c ...). A couple of SQL queries made by the P4DTI (one in the replicator, one in the Bugzilla patch) fall foul of this change.
AnalysisCheck all our queries.
How foundmanual_test
EvidenceI just know
Observed in2.3.5
Created byNick Barnes
Created on2007-07-30 09:34:12
Last modified byNick Barnes
Last modified on2009-03-03 14:47:15
History2007-07-29 NB Created.


Change Effect Date User Description
165234 closed 2008-06-11 17:27:32 Nick Barnes Additional fixes to address test suite issues on unicode branch.
162999 closed 2007-07-29 22:06:06 Nick Barnes Some fixes to the P4DTI patch for Bugzilla 3.0.