| Title | MySQL 5.0 breaks P4DTI |
| Status | closed |
| Priority | essential |
| Assigned user | Nick Barnes |
| Organization | Ravenbrook |
| Description | The 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. |
| Analysis | Check all our queries. |
| How found | manual_test |
| Evidence | I just know |
| Observed in | 2.3.5 |
| Created by | Nick Barnes |
| Created on | 2007-07-30 09:34:12 |
| Last modified by | Nick Barnes |
| Last modified on | 2009-03-03 14:47:15 |
| History | 2007-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. |