When using this type schema tools always thinks that schema is not up-to-date

[jkuchar]

Then I create entity with you uuid type, for every use Doctrine schema tools generates this king of "update" SQL:

ALTER TABLE table ALTER id_table TYPE UUID;
ALTER TABLE table ALTER id_table DROP DEFAULT;

[ramsey]

@marijn or @WouterSioen, would either of you mind taking a look at this? Thanks!

[marijn]

Yeah, this is a bug in Doctrine itself if I'm not mistaken.

[marijn]

I think it's this one: http://www.doctrine-project.org/jira/browse/DBAL-63

[ramsey]

That looks like it was resolved in November 2010. Is it still an issue in Doctrine?

[marijn]

Not sure. What is the version of Doctrine you're on @jkuchar?

[WouterSioen]

Normally, the SQL Comment hint should fix this issue. @jkuchar what kind of database are you using this on?

[jkuchar]

Guys! I‘m sorry, my mistake. I was trying to override doctrine guid type with uuid and it exploded.

CONCLUSION: Do not mix GUID and UUID Doctrine types, they are NOT equal!

[WouterSioen]

glad you found it 👍