forwarded 397233 http://bugs.mysql.com/bug.php?id=23992 stop
Hi Dan On 2006-11-06 Dan Jacobson wrote: > $ mysql < q.sql > ERROR 1114 (HY000) at line 1: The table 't1' is full > $ nl q.sql > 1 CREATE TABLE IF NOT EXISTS t1 (INDEX(HROAD,AREA1)) > TYPE=MEMORY 2 SELECT DISTINCT AREA1,HROAD,ROAD > 3 FROM rall1 ; #WHERE AREA1='台北市'; > 4 SELECT DISTINCT * FROM t1 AS a JOIN t1 AS b > USING(AREA1,HROAD) 5 WHERE a.ROAD != b.ROAD GROUP BY AREA1,HROAD; > > If table t1 is full, that means it EXISTS. > That means IF NOT EXISTS was ignored. Bug. Verified, the SELECT does indeed fill a pre-existing table `t1`. bye, -christian-
