MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:hsv Date:September 18 2012 2:33am
Subject:Re: function INTERVAL in view
View as plain text  
>>>> 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.

function INTERVAL in viewhsv17 Sep
  • Re: function INTERVAL in viewPeter Brawley17 Sep
    • RE: function INTERVAL in viewRick James17 Sep
      • RE: function INTERVAL in viewSteven Staples17 Sep
    • Re: function INTERVAL in viewhsv19 Sep