MySQL 4.1 on Win2K: Minor and major bug
am 14.05.2003 22:27:16 von Stefan HinzHow-to-repeat:
I installed MySQL 4.0.12 and 4.1.0 on a Win2K
machine. They have different my.ini's, different datadirs, different
InnoDB tablespace files etc. I copied the databases and the InnoDB
tablespace files to the servers' datadirs (when both servers were
down), so they are exact copies of the databases I ran before with
MySQL 4.0.10 (I had only a single server on that machine before). The
servers never run at the same time.
For 4.0.12, everything works fine and as expected. With 4.1.0, I get
the following:
mysql> status
--------------
c:\mysql41\bin\mysql.exe Ver 13.5 Distrib 4.1.0-alpha, for Win95/Win98 (i32)
Connection id: 1
Current database: world
Current user: superuser@localhos <--- Bug #1
SSL: Not in use
Server version: 4.1.0-alpha-max-nt-log
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1_swedish_ci
Server characterset: latin1_swedish_ci
TCP port: 3306
Uptime: 11 sec
Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tabl
--------------
mysql> show table status;
+-----------------+--------+------------+------+------------ ----+-------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
+-----------------+--------+------------+------+------------ ----+-------------+
| City | MyISAM | Fixed | 4079 | 67 | 273293 |
| Country | NULL | NULL | NULL | NULL |NULL | <--- Bug #2
| CountryLanguage | NULL | NULL | NULL | NULL | NULL |
| t | InnoDB | Fixed | 3 | 5461 | 16384 |
+-----------------+--------+------------+------+------------ ----+-------------+
4 rows in set (0.39 sec)
There are two problems I experience:
(1) STATUS reports the host as 'localhos', with the last character
missing. I tried this with another hostname, same effect (MySQL seems
to cut off the last character of the hostname):
mysql> grant all on *.* to 'test'@'athene';
Query OK, 0 rows affected (0.00 sec)
C:\mysql41\bin>mysql -hathene -utest -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.1.0-alpha-max-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> status
--------------
mysql Ver 13.5 Distrib 4.1.0-alpha, for Win95/Win98 (i32)
Connection id: 9
Current database:
Current user: test@ATHEN
....
(2) Some MyISAM tables are being reported as 'NULL' (table type etc.).
Trying to view the definition or contents of those tables results in:
mysql> describe Country;
ERROR 22: Character set '#31' is not a compiled character set and is not specified in the
'c:\mysql41\share\charsets\Index.xml' file
mysql> select * from Country;
ERROR 22: Character set '#31' is not a compiled character set and is not specified in the
'c:\mysql41\share\charsets\Index.xml' file
(1) seems to be a display bug only, while (2) will prevent any Win2K
user from using some of his/her tables as they are not accessible any
more. That issue seems to affect MyISAM tables only, and only those
tables that use the latin1_de charset.
Regards,
--
Stefan Hinz
iConnect GmbH
Taunusstr. 27, 12161 Berlin (Germany)
+49 30 8270294-0 Fax: +49 30 8270294-1
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org