Hi
I upgraded from 5.0.45 to 5.0.51b yesterday.
After installing the files, I just copied the var directory and started
the database.
mysql> show create table cc\G
*************************** 1. row ***************************
Table: cc
Create Table: CREATE TABLE `cc` (
`id` varchar(255) collate latin1_german1_ci NOT NULL,
`max` int(11) NOT NULL,
`available` int(11) NOT NULL,
`version` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci
1 row in set (0.00 sec)
mysql> desc cc;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| id | varchar(255) | NO | PRI | NULL | |
| max | int(11) | NO | | NULL | |
| available | int(11) | NO | | NULL | |
| version | int(11) | NO | | NULL | |
+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> delete from cc;
Query OK, 3 rows affected (0.00 sec)
mysql> insert into cc values("asd",30,50,123);
Query OK, 1 row affected (0.00 sec)
mysql> insert into cc (id,max) values("asdf",30);
Query OK, 1 row affected, 2 warnings (0.00 sec)
mysql> select * from cc;
+------+-----+-----------+---------+
| id | max | available | version |
+------+-----+-----------+---------+
| asd | 30 | 50 | 123 |
| asdf | 30 | 0 | 0 |
+------+-----+-----------+---------+
2 rows in set (0.00 sec)
That's kind of misleading and feels inconsistent. Should I file a bug
about this?
Regards
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]