Re: function INTERVAL in view

2012-09-18 Thread hsv
2012/09/17 13:11 -0500, Peter Brawley Looks like a bug. Report it? It was reported: Bug #45346 VIEW containing INTERVAL(...) can be created but does not work Submitted: 5 Jun 2009 10:00 Modified: 5 Jun 2009 10:16 Severity:S3 (Non-critical) Version:6.0, 5.4, 5.1 OS:Any Seems

RE: function INTERVAL in view

2012-09-17 Thread Steven Staples
> -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 h

RE: function INTERVAL in view

2012-09-17 Thread Rick James
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: fu

Re: function INTERVAL in view

2012-09-17 Thread Peter Brawley
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 wron