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.braw...@earthlink.net]
> Sent: Monday, September 17, 2012 11:12 AM
> To: mysql@lists.mysql.com
> Subject: Re: function INTERVAL in view
> 
> n 2012-09-17 12:58 PM, h...@tbbs.net 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?
> 
> Looks like a bug. Report it?
> 
> PB
> www.artfulsoftware.com
> 
> >
> >
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to