[DC-617] migration problem Created: 06/Apr/10 Updated: 22/Jun/12
|Reporter:||MichalKJP||Assignee:||Jonathan H. Wage|
Symfony 1.4.3, Linux, PostgreSQL, Pgpool II
I attached a testcase that reproduces all problem that I noticed (previously reported in "serious symfony doctrine:migrate issues - symfony 1.4" on symfony-dev)
There is a problem with an empty ON UPDATE when migrate to version 5
When migrateing from 5 to 3
|Comment by Ludo [ 08/Sep/10 ]|
My own Quick Fix for DROP INDEX (into Export class)
|Comment by MichalKJP [ 08/Sep/10 ]|
I already tested this solution and I can confirm that also works for me.
I am afraid that Johnatan spends much time on the new version and did not have time to correct these bugs for the old version. So we still repair migrations manualy.
|Comment by James Bell [ 22/Jun/12 ]|
We've had this issue for a while - while Ludo's fix does work, there is an SQL injection issue in that the '$name' doesn't get escaped.
You can do this: $name = $this->conn->quoteIdentifier($name); which also steps around the issue for now.
The problem appears to be that the indexes aren't being created with the _idx string on the end when using the migrations. This is probably down to the index creation process rather than the index removal process.