List:General Discussion« Previous MessageNext Message »
From:Dominik Klein Date:April 30 2008 11:01am
Subject:Bug: describe table show default NULL, but that's not true
View as plain text  
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
Thread
Bug: describe table show default NULL, but that's not trueDominik Klein30 Apr 2008