Re: How to Raise Error ?

[Roland Bouman]

Hi Andrew,

yes, just as I was doing my groceries (after submitting the post, grrrr) I thought about that one too. I mean, I would rather like MySQL check my code for non-existing tables, columns, procs etc before accepting the code, and I would not be surprised if that feature would be implemented someday (have you put up a feature request?).

And of course, the proc should be flagged vaild or invalid just like in Oracle. To top it off, I would really like something like DBA_DEPENDENCIES view, or the equivalents defined in the standard.

I'm a bit confused as to what you mean by 'the table method'. I thought we established three flavours of work-arounds to fora an error:

1) violate unique constraint as documented at mysqldevelopment.com ('emulating check constraints')
2) reference non-existant procedure (Zigmunds suggestion)
3) UDF (as documented in my blog)