Hello.

Look at this:

How-To-Repeat:"

mysql> create table ett (a int, b int, c int); Query OK, 0 row affected (0,03 sec)

mysql> insert into ett values(0,0,0); Query OK, 1 row affected (0,00 sec)

mysql> insert into ett values(1,1,1); Query OK, 1 row affected (0,00 sec)

mysql> insert into ett values(2,2,2); Query OK, 1 row affected (0,00 sec)

mysql> create table tva select a, b, 0 from ett; Query OK, 3 rows affected (0.03 sec) Records: 3 Duplicates: 0 Warnings: 0

mysql> create table tre select a, 0, 0 from ett; ERROR 1060: Duplicate column name '0' mysql>

(Ver 11.12 Distrib 3.23.33, for Win95/Win98 (i32))

Is this a bug? 'Describe tva' reveals that the third columns name is '0', (it is
really the number 0, not the letter O) but this is against the naming
conventions I think.

Database: cstest Table: tva Rows: 3 +-------+-----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges
| +-------+-----------+------+-----+---------+-------+---------------------------------+ | a | int(11) | YES | | | |
select,insert,update,references | | b | int(11) | YES | | | |
select,insert,update,references | | 0 | bigint(1) | | | 0 | |
select,insert,update,references | +-------+-----------+------+-----+---------+-------+---------------------------------+

Mvh från en i övrigt mycket nöjd användare.