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 it arouses
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
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
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
-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