From: hsv
Date: September 17 2012 5:58pm
Subject: function INTERVAL in view
List-Archive: http://lists.mysql.com/mysql/228170
Message-Id: <B0117232553@mailhome.tbbs.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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?