I think we manage enough of the schema via sqlalchemy that expecting a DBA to do this is unexpected. Also, it's nova,keystone and glance that want to ensure a behavior of key matching - if we leave this up to deployers, they will be more likely to get it wrong (and there isn't really a great argument as to why they'd ever want to do it the other way)
I think it's possible to get sqlalchemy to do db-engine specific properties in the case of the use of that engine... On 01/10/2012 05:16 PM, Jay Pipes wrote: > Not sure I would think that a migrate patch is the right approach > here... I kind of feel like this is a DBA or sysops responsibility. > > Thoughts? > > -jay > > On Tue, Jan 10, 2012 at 4:43 PM, Nachi Ueno > <ueno.na...@nttdata-agilenet.com> wrote: >> Hi Jay >> >> Thanks >> Is it possible to do it on sqlalchemy.migration ? >> >> >> 2012/1/10 Jay Pipes <jaypi...@gmail.com>: >>> +1 for Case Sensitive. For MySQL, this is a configuration issue. The >>> default character set and collation should use the *_cs variants. For >>> existing MySQL installations, an ALTER TABLE ... MODIFY COLUMN ... >>> CHARACTER SET ... COLLATION ... *_cs would need to be done for >>> affected tables. >>> >>> -jay >>> >>> On Tue, Jan 10, 2012 at 4:15 PM, Nachi Ueno >>> <ueno.na...@nttdata-agilenet.com> wrote: >>>> Hi folks >>>> >>>> Nova,Keystone,Glance uses RDBMS and they use unique key constraints. >>>> Nowadays, we can use Mysql,Sqlite,Postgresql. >>>> Unfortunately, the unique key behaviors of each DB are different. >>>> >>>> - Mysql : case-insensitive >>>> - Sqlite : case-sensitive >>>> - Postgresql : case-sensitive >>>> >>>> I wanna know the spec of OpenStack. >>>> Unique key is case-sensitive or *in*sensitive? >>>> >>>> Cheers >>>> Nati >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~openstack >>>> Post to : openstack@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~openstack >>>> More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > Mailing list: https://launchpad.net/~openstack > Post to : openstack@lists.launchpad.net > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp