Re: HAVING strangeness in InnoDB

2001-07-06 Thread Heikki Tuuri
Hi! I will send you a special version of row0sel.c with which you can print a lot of trace info on SELECT execution. Those traces may reveal what is wrong. Regards, Heikki >Hi, this is a follow-up to the previous message. > >As far as I've understood when Innodb parses a Having clause it creat

Re: HAVING strangeness in InnoDB

2001-07-06 Thread nsabbi
Hi, this is a follow-up to the previous message. As far as I've understood when Innodb parses a Having clause it creates a temporary table where it stores the results of the query satisfying all the conditions except the HAVING clause, then it makes a SELECT * from ... WHERE having_clause on th