[DDC-2045] Unit of work use all columns for insert Created: 27/Sep/12 Updated: 13/May/13 Resolved: 23/Jan/13
|Project:||Doctrine 2 - ORM|
|Reporter:||Covie X||Assignee:||Marco Pivetta|
PHP 5.4.7--pl0-gentoo mysql Ver 14.14 Distrib 5.5.22, for Linux (x86_64)
I use MySQL. And I'm OK with default values that will be assigned by DB for columns which values I don't set explicitly. But Doctrine seems to unable to skip some columns when building insert SQL query.
People suggest to use nullable flag to enable desired behaviour. And I don't see how it could help. I checked UnitOfWork.php and BasicEntityPersister.php. There is nothing about nullable.
So why not track changes for unsaved entities as well, and don't force applications to generate more traffic with more SQL text and developers to set default values in entity constructors?
I would be glad if I'm mistaken and this feature is already implemented and you describe how to resolve the issue. Thanks
|Comment by Marco Pivetta [ 23/Jan/13 ]|
Covie X the `nullable` flag is a mapping used in columns. See http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/annotations-reference.html#annref-column
Also, Doctrine does not skip columns since default DB-side values are not supported by the ORM. To have default values, you usually set them in the entity's constructor.
|Comment by Covie X [ 13/May/13 ]|
Marco, you should be ashamed of the way you treat issues.