> -----Original Message-----
> From: Rick James [mailto:rjames@stripped]
> Sent: September 17, 2012 3:04 PM
> To: peter.brawley@stripped; mysql@stripped
> Subject: RE: function INTERVAL in view
>
> INTERVAL is a keyword. This is probably the root of the hiccup.
> Is that your Stored Function? Or UDF?
>
> on 2012-09-17 12:58 PM, hsv@stripped wrote:
> > My MySQL is of version 5.5.8-log. I find I cannot save a query with
> > INTERVAL in a view: redundant round brackets are added. If the query is
> >
> > SELECT INTERVAL(1, 2, 3, 4)
> >
> > within the frm file there is the expression
> >
> > interval((1, 2, 3, 4))
> >
> > which is wrong.
> >
> > What is known about this?
It is also a function:
http://dev.mysql.com/doc/refman/5.5/en/comparison-operators.html#function_in
terval
as for why it does that? I have no idea.
