Ok I get it now In drizzle, Memory engine is supported only for temporary tables. This works. drizzle> create temporary table t2(i int)engine=memory; Query OK, 0 rows affected (1.3 sec)
-- Thanks Prafulla On Fri, Aug 20, 2010 at 2:37 PM, Prafulla Tekawade <[email protected]> wrote: > Hi, > I am trying to create user table with memory storage engine > but I am getting following error. > Looking at heap engine code looks like, it is now allowed only > for temptable. > > drizzle> create table t2(i int)engine=memory; > ERROR 1005 (HY000): Can't create table 'test.t2' (errno: 138) > drizzle> create table t2(i int)engine=heap; > ERROR 1286 (42000): Unknown table engine 't2' > > Is this some bug or something we have decided ? > > -- > Thanks > Prafulla > _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
