Deploy of MySql application fails with error if reserved MySQL word is used in DB name

[Victor Ryzhenkin]

ISO: {"build_id": "2014-12-17_03-38-09", "ostf_sha": "a9afb68710d809570460c29d6c3293219d3624d4", "build_number": "50", "auth_required": true, "api": "1.0", "nailgun_sha": "dc621c96e30f0dd284998e975f3b800afe9fc082", "production": "docker", "fuelmain_sha": "fb89876812320464ebad60e7ca34b433d6b1d815", "astute_sha": "16b252d93be6aaa73030b8100cf8c5ca6a970a91", "feature_groups": ["mirantis"], "release": "6.0", "release_versions": {"2014.2-6.0": {"VERSION": {"build_id": "2014-12-17_03-38-09", "ostf_sha": "a9afb68710d809570460c29d6c3293219d3624d4", "build_number": "50", "api": "1.0", "nailgun_sha": "dc621c96e30f0dd284998e975f3b800afe9fc082", "production": "docker", "fuelmain_sha": "fb89876812320464ebad60e7ca34b433d6b1d815", "astute_sha": "16b252d93be6aaa73030b8100cf8c5ca6a970a91", "feature_groups": ["mirantis"], "release": "6.0", "fuellib_sha": "484f53f586c084cc38c88615b0594d9c48882c5a"}}}, "fuellib_sha": "484f53f586c084cc38c88615b0594d9c48882c5a"}

HOW TO REPRODUCE:
1. Deploy OpenStack with Neutron GRE and Murano simple mode(1 controller 1 compute)
2. Create Murano Environment.
3. Add MySql application.
4. Provide database name, user name and password.
5. Send env to deploy.

Actual result:
Deployment fails with errors.

[ruhe (ruhe)]

Root cause analysis:

Error occurs only if user specifies MySQL reserved word as the name of MySQL database.

[Serg Melikyan (smelikyan)]

User shouldn't use reserved words as database identifier. Won't Fix

[Serg Melikyan (smelikyan)]

http://stackoverflow.com/questions/23446377/syntax-error-due-to-using-a-reserved-word-as-a-table-or-column-name-in-mysql

[Timur Nurlygayanov (tnurlygayanov)]

we probably can check it and deny to use it?

[Serg Melikyan (smelikyan)]

It's around of 100 reserved words that you can't use as a name for database

[Ekaterina Chernova (efedorova)]

Release notes:

If 'MySql' is entered as database name during murano application creation (Mysql app for example) the deploymnt will failed since it's a reserved word in mysql database and it's forbidden to use such kid of name for a database name