>>>> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql