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
