MySQL Forums
Forum List  »  Memory Storage Engine

Advanced Search
New Topic

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

Hi,

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?

Cheers!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
problem with memory table used twice in select
5732
Neil Haslewood
October 10, 2006 07:34AM
Re: problem with memory table used twice in select
3843
Ingo Strüwing
October 13, 2006 11:38AM
Re: problem with memory table used twice in select
3719
delirii
November 15, 2006 06:37AM
Re: problem with memory table used twice in select
4066
Andrej Potocky
December 15, 2006 07:12PM
Re: problem with memory table used twice in select
4390
Ingo Strüwing
December 18, 2006 09:47AM


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.