HI Rafal, Thava,
Rafal Somla, 09.11.2009 09:44:
> Hi Thava, Ingo,
>
> Thava proposes a solution where possible warnings generated when
> execute_direct() is used will not be shown to user if thd->killed is set.
>
> I think that such warnings (other than ER_QUERY_INTERRUPTED) should be
> shown to the user. Thava thinks it is acceptable that they are ignored.
>
> Ingo: could you state your position here. If you agree with Thava, I'll
> approve this as well.
IMHO the user has a reason to abort. He either is aware of problems, so
that he aborts, or he is out of time and won't check additional errors
anyway. Or he isn't interested in the outcome at all.
Since the user cannot know, in which phase the operation is at every
moment, it is unlikely that he aborts, just to check what problems have
been detected so far.
OTOH there could be cases where the operation takes an unusual long
time. The user might see that the objects are not created or populated
in the way he expects. So he is aware of problems (as I said above), but
still would like to know, what the cause is. In that case additional
messages could be useful.
Summary: In most cases the user can live with a simple "interrupted"
message. And most users will probably accept that they don't get more if
they interrupt an operation, even if that would be handy.
So I think that it is not absolutely necessary to invest the effort to
report all problems, we could. OTOH, I have to do almost the same for
the TRUNCATE operation. Once we have a template, how to filter unwanted
messages, and copy the rest, we could easily do the same for
"interrupted" too. So either Thava investigates on this, and I can
profit from it later, or I investigate later and can change this as
well. Anyway, it would be great, if Thava could do it, but it is not a
requirement from me.
Regards
Ingo
--
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring HRB München 161028
