[debian-mysql] Bug#486684: mysql-server: corrupt check fails in hyphenated table names.

[oryn]

Package: mysql-server
Version: 5.0.51a-7
Severity: normal

The corrupt check that is run on startup does not handle hyphenated table names, it seems to chop off anything before the hypen, resulting in errors like this:

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 '-items' at line 1

Annoyingly the debian supplied jabberd2 package includes hypenated table names in its default mysql database schema.

It seems that this error can be fixed by inclosing the table names in quotes. I would have ago at fixing this if I could figure out how it works, but after looking I'm totally baffled.


-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.25.4 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server depends on:
pi  mysql-server-5.0              5.0.51a-6  MySQL database server binaries

mysql-server recommends no packages.

-- no debconf information