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
> -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
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
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
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?
--
MySQL Gene
