Thanks. I thought that was the case, but I wanted to be sure.
On Fri, Mar 6, 2009 at 12:07 PM, Perrin Harkins <perrin@stripped> wrote:
> I'm afraid enums are useless for anything except compressing your
> data, since they don't reject bad values. If you want to limit a
> field to a set of values, you need to use a lookup table and a foreign
> key constraint.
> - Perrin
> On Fri, Mar 6, 2009 at 1:35 PM, David Karr <davidmichaelkarr@stripped>
> > If I define an enum parameter for a stored program, and the calling code
> > sends an invalid value, they get the less than useful "data truncated"
> > error. Is it possible to define the stored program to produce better
> > handling for that kind of error?
> > This is probably a FAQ, but in general, it appears that error diagnostics
> > stored programs are very primitive. Are there any plans in a roadmap to
> > improve this?