Null in composite key
Reported by tinney | August 7th, 2008 @ 08:24 AM
When using the onduplicatekey_update option in AR-extentions composite keys that can contain NULL values will not work.
For example say you were to import a list of people. Your table used First Name, Middle Name and Last Name as your composite key. The entry “Bob Dole” would not match the person in the database with the First Name Bob, Middle Name NULL and Last Name Dole. This entry would be inserted again and your table will contain duplicates.
To work around this either change your composite key to exclude the NULL values or enter the values in as empty strings or something other than NULL.
No comments found
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
ActiveRecord::Extension (aka ar-extensions) is a plugin to extend and
enhance the functionality of ActiveRecord. It starts by adding better
find support for ActiveRecord. It then adds mass data import
capabilities which are highly efficient and lastly it supports to_csv
functionality.
It also introduces a cool concept of creating easily extendable pieces
of ActiveRecord functionality, so developers don't have to understand
ActiveRecord internals or have the fear of breaking ActiveRecord
itself.
tinney