Public bug reported:

SYSTEM DESCRIPTION:
~$ lsb_release -rd
Description:    Ubuntu 11.04
Release:        11.04

~$ apt-cache policy mysql-admin
mysql-admin:
  Installed: 5.0r14+openSUSE-2.2ubuntu1
  Candidate: 5.0r14+openSUSE-2.2ubuntu1
  Version table:
 *** 5.0r14+openSUSE-2.2ubuntu1 0
        500 http://in.archive.ubuntu.com/ubuntu/ natty/universe amd64 Packages
        100 /var/lib/dpkg/status


I have certain databases which have - in their database name 
when i try to delete those databases using mysql-admin gui tool... it fails
suppose the database name is "senior-year-project"
then the command passed for deleting it should be 

mysql> DROP SCHEMA `senior-year-project`

however i guess the command passed is

mysql> DROP SCHEMA senior-year-project

which results in an error.....

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: mysql-admin 5.0r14+openSUSE-2.2ubuntu1
ProcVersionSignature: Ubuntu 2.6.38-8.42-generic 2.6.38.2
Uname: Linux 2.6.38-8-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Sat May 21 16:40:48 2011
InstallationMedia: Kubuntu 11.04 "Natty Narwhal" - Release amd64 (20110426.3)
ProcEnviron:
 LANGUAGE=en_IN:en
 PATH=(custom, user)
 LANG=en_IN
 SHELL=/bin/bash
SourcePackage: mysql-gui-tools
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: mysql-gui-tools (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug natty

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/786137

Title:
  DROP SCHEMA does not work with `-` in the database name

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to