From: Rick James
Date: September 17 2012 7:03pm
Subject: RE: function INTERVAL in view
List-Archive: http://lists.mysql.com/mysql/228172
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148B889C0B@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

INTERVAL is a keyword.  This is probably the root of the hiccup.
Is that your Stored Function?  Or UDF?

> -----Original Message-----
> From: Peter Brawley [mailto:peter.brawley@stripped]
> Sent: Monday, September 17, 2012 11:12 AM
> To: mysql@stripped
> Subject: Re: function INTERVAL in view
>=20
> n 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?
>=20
> Looks like a bug. Report it?
>=20
> PB
> www.artfulsoftware.com
>=20
> >
> >
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql