There is also www.materialized.info http://www.materialized.info/ ,
providing a simpler example of creating a MV, including triggers to maintain
it.
Still more to this saga
Comment 1:
... HAVING x;
The expression ( x ) is evaluated as a true/false value, based on whether x is
nonzero (true) or zero (false). Your 'x' is MIN(date_time) , which is very
likely to be nonzero, hence TRUE. That is, the HAVING does nothing useful.
Comment
I
Sent from my D
- Reply message -
From: Rick James rja...@yahoo-inc.com
To: Larry Martell larry.mart...@gmail.com, shawn green
shawn.l.gr...@oracle.com
Cc: mysql mailing list mysql@lists.mysql.com
Subject: Problem with having
Date: Thu, Sep 26, 2013 12:11 PM
Still more to this