request problem will be resolved in next versions ?

------=_NextPart_000_0017_01C3BD6E.10547AD0
Content-Type: text/plain;
charset="windows-1256"
Content-Transfer-Encoding: quoted-printable

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 .
------=_NextPart_000_0017_01C3BD6E.10547AD0--

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
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs@m.gmane.org