[Info-ingres] E_QE0310 is not super-helpul is it?

[Karl and Betty Schendel]

> On Feb 2, 2018, at 9:25 AM, Roy Hann <specially at processed.almost.meat> wrote:
> 
> I just spent fully 30 minutes banging my head on this:
> 
>  select * from fooproc(1) \g
> 
> yields "E_QE0310 Unsupported procedure statement type: MSG".
> 
> Of course what it wants to tell me--and utterly fails--is that I
> have a MESSAGE statement (not a "MSG" statement) lurking in my
> table procedure.
> 
> BTW, I don't recall seeing any documentation that MESSAGE is not allowed
> in a table procedure. Common sense tells me it can't work very well. I
> don't have a problem that MESSAGE is not allowed.

I'd log a bug.  We should be detecting this sooner, I should think.
I don't think I can see a MESSAGE statement working well in any row
returning procedure, whether it's used as a table procedure or not.

The QE0310 error is using the action header type and looking it
up in a table meant for the QE90 trace point (I think), hence the
abbreviation.  

It's also a doc bug that we don't say you can't do that.

Karl