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

Shinobu Kinjo shinobu.kj at gmail.com
Sat Mar 26 10:13:13 UTC 2016


Hi Vega,

Thank you for your quick action.

Cheers,
Shinobu


On Sat, Mar 26, 2016 at 6:39 PM, Vega Cai <luckyvega.g at gmail.com> wrote:
> Added a work item in phase 4 in our todo list:
>
> https://etherpad.openstack.org/p/TricircleToDo
>
> On 26 March 2016 at 17:31, joehuang <joehuang at huawei.com> wrote:
>>
>> Hi, Shinobu,
>>
>> This BP is a good entrance for Tricircle source code, this BP listed the
>> all basic patches building Tricircle from scratches.
>>
>> https://blueprints.launchpad.net/tricircle/+spec/implement-stateless
>>
>> 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
>>
>> __________________________________________________________________________
>> 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
>
>
>
> __________________________________________________________________________
> 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
>



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



More information about the OpenStack-dev mailing list