[openstack-dev] [nova] solving API case sensitivity issues

Sean Dague sean at dague.net
Thu Feb 25 11:18:27 UTC 2016

On 02/24/2016 06:56 PM, Chris Friesen wrote:
> On 02/24/2016 02:34 PM, Sean Dague wrote:
>> There are no urls stored here. This is content coming through the body.
>> While I do appreciate many folks weighing in that haven't read the bug
>> yet, I would be even better if people did read the bug first.
>> We have the ability to decide at the API level what the behavior is of
>> payloads in POST / GET. Given the majority of our users are on mysql,
>> they've never had access to case sensitive overlapping metadata on
>> aggregates before. Doing so seems odd and potentially confusing.
> On the other hand, coming from a UNIX environment where case sensitivity
> is the default, it seems odd that we'd intentionally become
> case-insensitive.
> For option 2 do we need to actually update the DB column description? 
> Or is there a way to alter the query to be case-insensitive without
> altering the column itself (using collate maybe)?

Collate is a change in the way the data is stored, it's a real alter.
The data structures look different if they are designed to be searched
with case folding or as binary.


Sean Dague

More information about the OpenStack-dev mailing list