- One of our clients had a large production issue due to a long-standing bug in Rails with case sensitivity.
Here’s the situation: Rails validates_uniqueness_of has a flag called :case_sensitive. This flag defaults to ‘true’, but can be flipped.buy ultram online
MySQL’s default collation is case-insensitive. As a result, queries will, in general, ignore case unless specifically overridden.buy diazepam online without prescription
So one might imagine that setting :case_sensitive to false would be completely harmless in a standard MySQL application.valium online no prescription
One would be wrong. Setting case_sensitive to false changes the query to lowercase the field in question, causing the MySQL database to ignore any indices it may have and turning the validates_uniqueness_of operation from something cheap and quick to something requiring a full table scan.buy tramadol without prescription
The open Lighthouse ticket on this issue is:soma online no prescription
https://rails.lighthouseapp.com/projects/8994/tickets/2503-validates_uniqueness_of-is-horribly-inefficient-in-mysqlprovigil online pharmacyadipex online without prescription ativan online no prescription buy ambien without prescription buy klonopin online buy xanax online