re: Output of "DESCRIBE tbl_name" wrong for unique key on NULL column

2002-09-18 Thread Victoria Reznichenko
jwakely, Wednesday, September 18, 2002, 5:46:19 PM, you wrote: jamdc> The output of DESCRIBE tbl_name shows unique keys to be "MUL" for columns jamdc> defined as NULL. jamdc> The SQL shown is a minimal test case that creates a new database and two jamdc> tables, both with a unique key on the col

Output of "DESCRIBE tbl_name" wrong for unique key on NULL column

2002-09-18 Thread jwakely
g` ( `id` int NOT NULL default '0', `uni` int, PRIMARY KEY (`id`), UNIQUE KEY `uni` (`uni`) ) TYPE=MyISAM; EXPLAIN not_bug; EXPLAIN bug; >Fix: >Submitter-Id: >Originator: Jonathan Wakely >Organization: Mintel International Group Ltd. >MySQL support: