Re: bk commit into 6.0 tree (davi:1.2618) BUG#23032

[Davi Arnaut]

Konstantin Osipov wrote:

[..]

>> diff -Nrup a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result
>> --- a/mysql-test/r/trigger.result	2008-02-12 09:44:24 -02:00
>> +++ b/mysql-test/r/trigger.result	2008-04-18 08:39:05 -03:00
>> @@ -1422,8 +1422,6 @@ create table t2 (j int);
>>  insert into t2 values (1), (2);
>>  set @a:="";
>>  create table if not exists t1 select * from t2;
>> -Warnings:
>> -Note	1050	Table 't1' already exists
> 
> Hmm, this is very interesting. I would double check it with PeterG
>  -- it turns out a trigger may silence warnings in the outer
> statement now. Is it really the intended effect of the standard? 

It's actually a MySQL note and what is kicking in here is the MySQL rule
that the message list is reseted if the statement uses a table. Anyway,
let's check with PeterG.

Regards,

-- 
Davi Arnaut, Software Engineer
MySQL Server Runtime Team
Database Group, Sun Microsystems