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