request problem will be resolved in next versions ?

"lamjoun" <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
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='2003' and month='10');

after execution I have this error 

[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 .
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.