>Description:
If I submit a select with a grouping function in the select clause and a
where clause on the table below, mysql produces the error 1034. A select
without a where or without a group function works fine.
A myisamchk -r or -o couldn't fix the problem, a myisamchk -e didn't
report
a problem.
>How-To-Repeat:
CREATE TABLE test (
f1 int(11) DEFAULT '0' NOT NULL,
f2 varchar(16) DEFAULT '' NOT NULL,
f5 text,
KEY index_name (f1,f2,f5(16))
);
INSERT INTO test VALUES (0,'traktor','1111111111111');
INSERT INTO test VALUES (1,'traktor','1111111111111111111111111');
select count(*) from test where f2='traktor';
>Fix:
don't use the KEY ...
>Submitter-Id: <submitter ID>
>Originator: Michael Braunoeder
>Organization:
>MySQL support: none
>Synopsis: ERROR 1034: Incorrect key file for table: 'test'.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.23-beta (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS knoedel 5.6 Generic_105181-19 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/local/bin/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS=''
LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1608144 Feb 8 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Apr 18 17:29 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 bin bin 1014272 Feb 8 2000 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1608144 Feb 8 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Apr 18 17:29 /usr/lib/libc.so
-> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014272 Feb 8 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/var/apps/mysql
--with-mysqld-user=mysql
Perl: This is perl, version 5.005_02 built for sun4-solaris
--
++++++++++++++++++++++++++++++++++++++++++++++++++++
++ Ing. Michael Braunoeder KPNQwest tech staff ++
++ M.Braunoeder@stripped MB125 ++
++ Phone +43-1-899 33-0 Fax +43-1-899 33-533 ++
