← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1305950] [NEW] Inconsistency with handling of unique constraints

 

Public bug reported:

We have many unit tests (simple example[1]) that check to see that indexes are case insensitive. The problem is that our current implementation doesn't explicitly make the index case insensitive. That's left up the the RDBMS. This is problematic because in my testing I have seen different results:
  - SQLite - is case sensitive
  - MySQL - is case insensitive[2]
  - PostgreSQL - is case sensitive

My goal was to get the unit tests working on MySQL/PostgreSQL, so I
would like to figure out a direction. Should we drop those tests and
leave it up to the environment? It's also possible to get SQLAlchemy
create the proper index. I've never done it, but I'm sure it's possible.


[references]
1. http://git.openstack.org/cgit/openstack/keystone/tree/keystone/tests/test_backend.py#n1791
2. http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1305950

Title:
  Inconsistency with handling of unique constraints

Status in OpenStack Identity (Keystone):
  New

Bug description:
  We have many unit tests (simple example[1]) that check to see that indexes are case insensitive. The problem is that our current implementation doesn't explicitly make the index case insensitive. That's left up the the RDBMS. This is problematic because in my testing I have seen different results:
    - SQLite - is case sensitive
    - MySQL - is case insensitive[2]
    - PostgreSQL - is case sensitive

  My goal was to get the unit tests working on MySQL/PostgreSQL, so I
  would like to figure out a direction. Should we drop those tests and
  leave it up to the environment? It's also possible to get SQLAlchemy
  create the proper index. I've never done it, but I'm sure it's
  possible.

  
  [references]
  1. http://git.openstack.org/cgit/openstack/keystone/tree/keystone/tests/test_backend.py#n1791
  2. http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1305950/+subscriptions


Follow ups

References