> -----Original Message----- > From: Rick James [mailto:rja...@yahoo-inc.com] > Sent: September 17, 2012 3:04 PM > To: peter.braw...@earthlink.net; mysql@lists.mysql.com > 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, 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?
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql