Scott Wong writes:
> I'm not sure if this is a feature or not so i'll just report it as a possible bug.
> I couldnt find anything in the documentation.
>
>
> How to repeat:
>
> create table t1(id int);
> insert into t1 set id=0;
> select @a:max(id)+1 from t1;
> insert into t1 [EMAIL PROTECTED]
Hi,
...the sysntax it's not quite normal.You should try :
select @a:=max(id)+1 from t1;
To test if the variable @a is "loaded" with what you expect, you can do:
select @a;
...if the result is NULL something is working wrong.
Anyhow, i wonder how it works on the master ?
Regards,
Gelu
___
