This project is archived and is in readonly mode.

#617 ✓resolved
Tarmo Tänav

changed_column_default losing null for mysql

Reported by Tarmo Tänav | July 14th, 2008 @ 07:57 AM | in 2.x

This is a forward-port of the patch in http://dev.rubyonrails.org/ticke... "change_column_default loses NOT NULL setting in MySQL and SQL Server" and also adds change_column_null to the mysql and sqlite adapters to keep feature-parity with postgresql.

I could separate the patches but since my implementation of change_column_null in mysql depends on the rest of the changes I've decided to keep them in one patch. Let me know if this is a problem.

Tested on mysql 5.0.60 with both strict mode on and off. Also tested on sqlite 3.5.9 and postgresql 8.3.1 (though for postgresql the only change is the addition of a test).

Comments and changes to this ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>

People watching this ticket

Attachments

Pages