Hi!
On Jul 07, Mattias Jonsson wrote:
> #At file:///Users/mattiasj/clones/bzrroot/b32430-60-bugteam/
>
> 2691 Mattias Jonsson 2008-07-07
> Bug#32430 'show innodb status' causes errors Invalid (old?)
> table or database name in logs
>
> Problem was the function filename_to_tablename in conjuction with
> partitions, since partitions intentionally uses the '#' character,
> which is not included in the filename charset.
>
> Solution was to implement the unescape filename function that
> allows the '#' character and only converts the filename from
> filename charset to system_charset_info.
It results in table names like
> +`test`.`t1#p#p0#sp#sp0`
which don't exist, aren't really table names.
I suggest to implement "explain_filename" function, that would print
"subpartition 0 of partition 0 of table t1"
or, for example, "table t1 partition 0 subpartition 0", or whatever.
(note that it would need to take "table %s partition %d subpartition %d"
message from errmsg.txt, it should not be hard-coded.
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect
/_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028
<___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring