[openstack-dev] [Tricircle] Using the reserved keywords reserved as field name

joehuang joehuang at huawei.com
Sat Mar 26 09:25:27 UTC 2016


Yes, It would be better to avoid the field name duplicated with DB key words. These tables are ported from Nova and Neutron, it would be good to change the field name.

Best Regards
Chaoyi Huang ( Joe Huang )


-----Original Message-----
From: Shinobu Kinjo [mailto:shinobu.kj at gmail.com] 
Sent: Saturday, March 26, 2016 2:39 PM
To: OpenStack Development Mailing List (not for usage questions)
Subject: [openstack-dev] [Tricircle] Using the reserved keywords reserved as field name

Hi Team,

In the Tricircle database, there are three tables having a field name which the MySQL (MariaDB) has as one of the reserved keywords. [1]

 Table Name:
  aggregate_metadata
  instance_type_extra_specs
  quality_of_service_specs

 Field Name:
  key

I think it would not be best practice to use any reserved word by the any system because it could cause bug once the component is bigger.

What do you think?

[1] http://dev.mysql.com/doc/refman/5.0/en/keywords.html

Cheers,
Shinobu

--
Email:
shinobu at linux.com
GitHub:
shinobu-x
Blog:
Life with Distributed Computational System based on OpenSource

__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev



More information about the OpenStack-dev mailing list