Package: mysql-client-5.0 Version: 5.0.51a-24+lenny3 Severity: normal Hi,
I've a table with the name Spaß (encoded in latin1). A dump of this
table stopps in the middle of the create table statement:
CREATE TABLE `test_v1` (
`testid` int(11) NOT NULL auto_increment,
`spieleid` text NOT NULL,
`grafik` text NOT NULL,
`sound` text NOT NULL,
`tiefe` text NOT NULL,
`steuer` text NOT NULL,
`atmos` text NOT NULL,
`gesamt` text NOT NULL,
`lan` text NOT NULL,
`spa<DF>;
SET character_set_client = @saved_cs_client;
Looking with strace what's going on, I saw this:
write(3, "\34\0\0\0\3show create table `test_v1`"..., 32) = 32
read(3,
"\1\0\0\1\2\33\0\0\2\3def\0\0\0\5Table\0\f?\0\25\0\0\0\375\1\0\37\0\0\"\0\0\3\3def\0\0\0\fCreate
Table\0\f?\0U\1\0\0\375\1\0\37\0\0\5\0\0\4\376\0\0\2\0B\2\0\5\7test_v1\3747\2CREATE
TABLE `test_v1` (\n `testid` int(11) NOT NULL auto_increment,\n `spieleid`
text NOT NULL,\n `grafik` text NOT NULL,\n `sound` text NOT NULL,\n `tiefe`
text NOT NULL,\n `steuer` text NOT NULL,\n `atmos` text NOT NULL,\n `gesamt`
text NOT NULL,\n `lan` text NOT NULL,\n `spa\337\0` text NOT NULL,\n
`pcgames` text NOT NULL,\n `gamestar` text NOT NULL,\n `gamigo` text NOT
NULL,\n `text` text NOT NULL,\n `datum` int(11) NOT NULL default '0',\n
`reporter` int(3) NOT NULL default '1',\n PRIMARY KEY (`testid`)\n)
ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1\5\0\0\6\376\0\0\2\0"...,
16384) = 674
In the answer of the server, you can see `spa\337\0`. The answer of the
server should go out to the dump via fprintf() in line 1785 in
mysqldump.c:
if (path)
my_fclose(sql_file, MYF(MY_WME));
seen_views= 1;
DBUG_RETURN(0);
}
row= mysql_fetch_row(result);
(*) fprintf(sql_file, "%s;\n", row[1]);
check_io(sql_file);
mysql_free_result(result);
}
my_snprintf(query_buff, sizeof(query_buff), "show fields from %s",
result_table);
if (mysql_query_with_error_report(mysql, &result, query_buff))
But fprintf() stopps at the \0. Hence, the cutted create table statement.
Maybe, also the server is to be blamed to not send \0, but at least the
client has to respect this (and work around this bug).
Bye, Jörg.
-- System Information:
Debian Release: unstable/experimental
APT prefers unstable
APT policy: (900, 'unstable'), (700, 'experimental')
Architecture: powerpc (ppc)
Kernel: Linux 2.6.33-rc7
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
signature.asc
Description: Digital signature http://en.wikipedia.org/wiki/OpenPGP
