[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