2 messages in com.mysql.lists.clusterCannot execute CREATE TEMPORARY TABLE
FromSent OnAttachments
phil...@bt.com30 Jun 2005 08:14 
Jonathan Miller30 Jun 2005 08:48 
Subject:Cannot execute CREATE TEMPORARY TABLE
From:phil...@bt.com (phil@bt.com)
Date:06/30/2005 08:14:17 AM
List:com.mysql.lists.cluster

Hello,

I'm using MySQL 4.1.8 Cluster and am trying to run this statement "CREATE TEMPORARY TABLE (i int)" but it gave me this error ERROR 1 (HY000): Can't create/write to file './tmp/#sql28fe_3_2.ndb' (Errcode: 2)

whilst I do have Create_tmp_table_priv=Y privilege for the user executing this statement.

Can anyone tell me whether this is supported with NDBCLUSTER and how I can fix this.

Thanks in advance.

Philong