yahoo-eng-team team mailing list archive

[Ionuț Arțăriși <iartarisi@xxxxxxx>]

Public bug reported:

Keystone uses a reserved SQL keyword for one of its tables: 'group'.

http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html
http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html

This makes querying the database awkward.

** Affects: keystone
     Importance: Undecided
         Status: New

** Description changed:

- Keystone uses a reserved postgresql keyword[1] for one of its tables:
- 'group'. This makes querying in postgresql awkward.
+ Keystone uses a reserved SQL keyword for one of its tables: 'group'.
  
+ http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html
+ http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html
  
- [1] http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html
+ This makes querying the database awkward.

** Summary changed:

- keystone uses a reserved postgresql keyword 'group'
+ keystone uses a reserved SQL keyword 'group'

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

Title:
  keystone uses a reserved SQL keyword 'group'

Status in OpenStack Identity (Keystone):
  New

Bug description:
  Keystone uses a reserved SQL keyword for one of its tables: 'group'.

  http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html
  http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html

  This makes querying the database awkward.

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