>Description:
Using MATCH in select-clauses returns:
ERROR 1030: Got error -1 from table handler
>How-To-Repeat:
Table:
CREATE TABLE files
(id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
filename BLOB,
comment BLOB,
size INT(10),
cd INT(10),
date_entered TIMESTAMP);
create fulltext index sepeindex on files (filename,comment);
And then a:
SELECT * from files where MATCH filename AGAINST ('david gray');
>Fix:
Not known.
>Submitter-Id: <submitter ID>
>Originator: hjalmar wåhlander
>Organization:
Private
>MySQL support: none
>Synopsis: Matching errors.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.37 (Source distribution)
>Environment:
System: Linux r2d2.myspys 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown
Architecture: i586
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 31 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
