I am trying to execute an sql command using MySQL client in Bamboo. As an argument, I've provided the following line:
--port=${bamboo.DB_PORT} --host=${bamboo.DB_HOST} --user=${bamboo.DB_USER} --password=${bamboo.DB_PASS} --execute='CREATE DATABASE testDB;'
It gives following error when executing the task:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''DROP DATABASE IF EXISTS testDB;’’ at line 1
However, if I provide the same argument using inline script, it executes correctly. I've already tried escaping the quotes, providing double quotes but none worked. Please suggest what can I do to fix it?
Hi everyone,
We have recently reviewed this issue and the overall interest in the problem. As the issue hasn't collected votes, watchers, comments, or support cases from many customers during its lifetime, it's very low on our priority list, and will not be fixed in the foreseeable future. That's why we've decided to resolve it as Time Out.
Although we're aware the issue is still important to those of you who were involved in the conversations around it, we want to be clear in managing your expectations. The Bamboo team is focusing on issues that have broad impact and high value, reflected by the number of comments, votes, support cases, and customers interested. Please consult the Atlassian Bugfix Policy for more details.
We understand how disappointing this decision may be but we want to be fully transparent when communicating with our users.
Atlassian will continue to watch this issue for further updates, so please feel free to share your thoughts in the comments.
Thank you,
Bamboo Team