Query doesn't work on temprorary table

2001-07-12 Thread ilya1
ght_col < p.right_col AND m.id IS NULL AND p.id = 1; SELECT will not work but print error: Can't reopen table: 'c' >Fix: No idea >Submitter-Id: ilya >Originator:Ilya Martynov >Organization: > >MySQL support: none >Synopsis: Query doesn't w

Re: Query doesn't work on temprorary table

2001-07-12 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > > Query doesn't work on temprory table while works on normal tables. > > Hi! This is documented in our manual. Aliasing of temporary tables will be enabled in MySQL 4.0. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. S