Ramesh <[EMAIL PROTECTED]> wrote: > > In mysql 4.014, the below INSERT statement works fine: > INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10 > > But in mysql 4.1, it fails, I get a message: > Error Code : 1066 > Not unique table/alias: 'TEST_TABLE' > (10 ms taken) > > Question: Is this a problem with 4.1 or is it supposed to fail?
4.1.0 was released before 4.0.14. Upgrade MySQL server to 4.1.1. > > Table is: > CREATE TABLE TEST_TABLE (id mediumint(9) NOT NULL, name varchar(255)) > TYPE = InnoDB > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
