[p4] p4dti + bugzilla 2.22 + MySQL 5.0

[Nick Barnes]

At 2006-08-01 21:52:29+0000, "Leo Zelevinsky" writes:

> How painful is it to downgrade an existing MySQL 5.0 db to version
> 4.1? I have already done some bugzilla setup work and would prefer not
> to lose it. Is it possible to downgrade it and still keep the
> database?
> 
> Any chance 5.0 will become supported by p4dti?

Yes, this is likely to happen in future.  I'm away on vacation at the
moment, and don't have access to my notes on this subject, but as I
recall there is a problem related to the SQL parsing in MySQL 5.x; one
of the P4DTI's queries, which appears to be legitimate SQL and works
fine in MySQL 3.22 and 4.x, triggers a syntax error in 5.0.

MySQL 5.1 is still in beta and I don't suppose we'll support it until
that changes.  But there's no deep fundamental reason why the P4DTI
shouldn't work with MySQL 5.0, and it's on my list of things to work
on.

Nick Barnes
P4DTI Project
Ravenbrook Limited