Fix missing backticks in MySQL "DROP DATABASE" statement

Bug #1624672 reported by MatthiasP
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
dbconfig-common (Debian)
Fix Released
Unknown
dbconfig-common (Ubuntu)
Fix Released
Low
Unassigned

Bug Description

When trying to purge a database that contains a "-" in its name, the uninstallation fails because the "DROP DATABASE" statement generated does not use backticks to escape the name.

Tags: patch
Revision history for this message
MatthiasP (mpdude) wrote :
Revision history for this message
Ubuntu Foundations Team Bug Bot (crichton) wrote :

The attachment "Patch against Version: 2.0.4~bpo8+1" seems to be a patch. If it isn't, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are a member of the ~ubuntu-reviewers, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issues please contact him.]

tags: added: patch
Revision history for this message
MatthiasP (mpdude) wrote :

Version "2.0.4~bpo8+1" does not make sense, as I intended to report this for Debian :(.

Does it make sense to keep this report here? If not, feel free to close.

Revision history for this message
Paul Gevers (paul-climbing) wrote :

@MatthiasP: no problem, it is a bug in the Ubuntu version as well. I liked this bug to the Debian bug.

Joshua Powers (powersj)
Changed in dbconfig-common (Ubuntu):
importance: Undecided → Low
Changed in dbconfig-common (Debian):
status: Unknown → New
Nish Aravamudan (nacc)
Changed in dbconfig-common (Ubuntu):
status: New → Triaged
Changed in dbconfig-common (Debian):
status: New → Fix Committed
Changed in dbconfig-common (Debian):
status: Fix Committed → Fix Released
Revision history for this message
Paul Gevers (paul-climbing) wrote :

dbconfig-common (2.0.7) unstable; urgency=medium

  * Let dbconfig-mysql Depends/Suggests default-mysql-* instead of
    mysql/mariadb (Closes: #848468)
  * Bump compat level to 10
  * Add backticks to MySQL DROP command (Closes: #838159)
  * Improve debconf question about administrative password (Closes:
    #831726)
  * Minor tweaks to documentation (Closes: #844614)
  * Update translations, thanks to:
    - Adriano Rafael Gomes (Closes: #848870)
    - Benedict Verheyen
    - Changwoo Ryu (Closes: #848176)
    - Helge Kreutzmann (Closes: #848495)
    - Innocent De Marchi (Closes: #849006)
    - Ivan Masár (Closes: #848226)
    - Javier Fernandez-Sanguino
    - Joe Dalton (Closes: #848376)
    - Yuri Kozlov (Closes: #848248)
    - victory

 -- Paul Gevers <email address hidden> Wed, 21 Dec 2016 21:27:37 +0100

Changed in dbconfig-common (Ubuntu):
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.