On Thu, Jan 8, 2015 at 7:28 AM, Steven Dake <sd...@redhat.com> wrote:
> On 01/07/2015 10:21 PM, Zhou, Zhenzan wrote: > >> Hi, >> >> Does anyone know why TripleO uses "regionOne" as default region name? A >> comment in the code says it's the default keystone uses. >> > > Zhenzan, > > I was going to point you here: > > https://bugs.launchpad.net/keystone/+bug/1400589 > > But I see you already had commented in that bug. > If we're expecting OpenStack to generally do case-sensitive comparisons, then we shouldn't be using the default MySQL collation for char columns[1]. Maybe the text columns should be BINARY rather than CHAR, or use a different collation. mysql> describe region; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | id | varchar(255) | NO | PRI | NULL | | | description | varchar(255) | NO | | NULL | | | parent_region_id | varchar(255) | YES | | NULL | | | extra | text | YES | | NULL | | | url | varchar(255) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) mysql> select collation(id) from region; +-----------------+ | collation(id) | +-----------------+ | utf8_general_ci | +-----------------+ 1 row in set (0.00 sec) It's not easy to alter the collation when it's a foreign key. mysql> alter table region convert to character set utf8 collate utf8_bin; ERROR 1025 (HY000): Error on rename of './keystone/#sql-3ffc_32' to './keystone/region' (errno: 150) [1] http://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html - Brant
_______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
