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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp