From: hsv
Date: September 18 2012 2:33am
Subject: Re: function INTERVAL in view
List-Archive: http://lists.mysql.com/mysql/228191
Message-Id: <B0117322127@mailhome.tbbs.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

>>>> 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 little interest. I ask meself whether to add my complaint to it. Turns out that for my problem it is enough to add 24 and divide by 20 and round down--but that is much moare opaque than INTERVAL(Mean, 6, 18, 36, 72).
Actually, I hav to include 0, too: the yet opaquer function
FLOOR(.4 + SQRT(Mean/5)). Ugh.