Re: ERROR 1066: Not unique table/alias: 'A'

Roger Larsson (RRLN) writes:
> Hello!
> 
> Following insert works on Oracle 7,8,9 and MS SQLServer 6,7,2000 (without
> 'TYPE=INNODB').
> Is it posible to get MySQL to understand this insert also?
> 
> Version used:
> D:\mysql\bin>mysqld-max-nt.exe -V
> mysqld-max-nt.exe  Ver 4.1.0-alpha-max-nt for NT on i32
> 
> ---
> mysql> DROP TABLE IF EXISTS A;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> CREATE TABLE A (a1 INT) TYPE=INNODB;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> INSERT INTO A (a1) VALUES (1);
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> COMMIT;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> SELECT * FROM A;
> +------+
> | a1   |
> +------+
> |    1 |
> +------+
> 1 row in set (0.00 sec)
> 
> mysql> INSERT INTO A (a1) SELECT max(a1)+1 FROM A;
> ERROR 1066: Not unique table/alias: 'A'
> ---
> 
> Regards/
> Roger Larsson
> 
> 
> 

Already fixed in 4.1.1 to be out in few weeks.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]