SEO

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