MySQL Forums
Forum List  »  Memory Storage Engine

problem with memory table used twice in select
Posted by: Neil Haslewood
Date: October 10, 2006 07:34AM


I found a problem with using a memory temporary table twice in the same select, ie:

from results, name n1, name n2

As an unsatisfactory workaround in 5.0.18 I had to create a 2nd name table.

Does anyone know if this problem is resolved?


Options: ReplyQuote

Written By
problem with memory table used twice in select
October 10, 2006 07:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.