Re: GROUP BY fails on TEXT fields in 4.0.1 (could not create /root/tmp/#sql...) - Sinisa Milivojevic - com.mysql.lists.bugs

7 messages in com.mysql.lists.bugsRe: GROUP BY fails on TEXT fields in ...

From	Sent On	Attachments
Vladimir V. Kolpakov	26 Feb 2002 00:31
Sergei Golubchik	26 Feb 2002 02:52
Michael Widenius	26 Feb 2002 07:22
Sinisa Milivojevic	04 Mar 2002 04:23
Vladimir V. Kolpakov	04 Mar 2002 13:41
Michael Widenius	05 Mar 2002 03:54
Sinisa Milivojevic	08 Mar 2002 04:37

Subject:	Re: GROUP BY fails on TEXT fields in 4.0.1 (could not create /root/tmp/#sql...)
From:	Sinisa Milivojevic (sin...@mysql.com)
Date:	03/04/2002 04:23:42 AM
List:	com.mysql.lists.bugs

Vladimir V. Kolpakov writes:

Description:

4.0.1 fails on grouping of TEXT fields: -------------- ERROR 1 at line 16: Can't create/write to file '/root/tmp/#sql72a6_f4_2.MYI'
(Errcode: 13) --------------

How-To-Repeat:

Set root environment (not sure which one used, so set both vars) export TMPDIR=/root/tmp export TMP=/root/tmp

Restart mysql /etc/rc.d/init.d/mysql restart

Run test mysql test -fvt <<EoD CREATE TABLE IF NOT EXISTS test ( id INT AUTO_INCREMENT PRIMARY KEY, product VARCHAR(20), url TEXT ); DELETE FROM test; INSERT INTO test SET product='dbms', url='www.mysql.com'; INSERT INTO test SET product='web', url='www.sfgate.com';

#--- text field is not involved, -- result is ok SELECT product,url FROM query; SELECT DISTINCT product FROM query; SELECT product FROM query GROUP BY product;

#--- text field used with grouping, -- query fails SELECT DISTINCT url FROM query; SELECT product,url FROM query GROUP BY product; SELECT product,url FROM query GROUP BY url; SELECT url FROM query GROUP BY product; EoD

Every of last 4 SELECT-s fails with message like this: -------------- ERROR 1 at line 16: Can't create/write to file '/root/tmp/#sql72a6_f4_2.MYI'
(Errcode: 13) --------------

Hi!

The above does not seem to be our bug.

It seems that you have problems with UNIX permissions on /root/tmp directory.