Re: 1.3 Migration Question re:NULL and Defaults

John-

Thank you for the reply. Yes indeed I am working on a copy of the DB - in fact I have cloned the entire domain including the DB etc, so I am able to compare things as well as test tweaks in the DB. Yes a default value of 0.00 is specified for the 'column' . The column definitions are:

column=amount   decimal(6,2) Null=No Default=0.00 all other fields are blank (extra, collation, attributes, etc)

other columns are decimal(4,2) but otherwise the same.

I am not sure if under the 1.2.0.5875 prebeta the original project utilized whether CakePHP is performing an insert with a NULL for the unset field and MySQL is taking care of the conversion to the default, or whether CakePHP itself performs the conversion based on schema prior to insert request.

It has always been my understanding that MySQL should handle it.

I have also purged all relevant tmp files, cache files etc.

I do have the ability to operate a copy of the old code and the migrated code simultaneously on the copy of the DB for testing purposes.

I have confirmed that using the same backup DB and same version of MySQL (same server) that cakephp 1.3.20 and 1.2.0.5875 are having different results on the same save operation at the controller level.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.