| 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. |
Generated at 2013-05-21 12:12:08 by $Id: //info.ravenbrook.com/infosys/cgi/issue.cgi#476 $
Copyright © Ravenbrook Limited. This document is provided "as is", without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this document. You may make and distribute verbatim copies of this document provided that you do not charge a fee for this document or for its distribution.