List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 18 1999 1:22pm
Subject:Re: creating heap tables problem
View as plain text  
At 7:47 AM -0500 7/18/99, Cezary Ziemlicki wrote:
>Hi,
>I've installed MySQL-3.22.25-1.i386.rpm on RedHat 6.0 system
>and it seems to work fine except that the query like
>
>CREATE TABLE t1(a CHAR(10),b INT)  TYPE =HEAP
>SELECT name,COUNT(phone) as nb_ph
>FROM t2
>GROUP BY name;
>
>reports an error :
>Syntax error near 'select...' statement,
>but select itself (without CREATE ...)executes correctly.
>Also  CREATE TABLE t1(a CHAR(10),b INT) TYPE =HEAP;
>alone creates a table, but it is a regular table
>stored in database dir as files t1.ISM, t1.ISD,t1.frm.
>
>Looking on list of variables by mysqladmin variables
>there is no max_heap_table_size variable,
>and trying option mysqld -O max_heap_table_size=#
>gives an error 'no variable matches max_heap_table_size.
>
>Are heap tables removed from MySQL-3.22.25-1?
>If not how to get it work?
>Thanks for any help.
>Cezary.


The change notes in the MySQL manual indicate that
CREATE ... SELECT isn't supported until 3.23.

--
Paul DuBois, paul@stripped
Thread
creating heap tables problemCezary Ziemlicki18 Jul
  • Re: creating heap tables problemPaul DuBois18 Jul