Re: request problem will be resolved in next versions ?

Hi,
I have a problem with this request.

insert into table month_var (year,month,var_cd,val)  select =
'2003','10',var_cd,0 from var and
var_cd not in (select var_cd from month_var where year=3D'2003' and =
month=3D'10');

after execution I have this error=20

[Mysql][ODBC 3.51 Driver][mysqld-4.1.0-alpha-max-nt] you can't specify =
target table 'month_var' for update in from clause.


My configuration is

windows XP pro, Mysql-4.1-alpha.

Question

This problem can be resolved with the next version of mysql ?

Thank you .



You should test the above with 4.1.1 which is already out.

-- 

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]