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

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




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