Description:
When i execute the following query on my database:
SELECT retaillastdone_.* FROM retaillastdone_ WHERE
(retaillastdone_.source_=mercury AND retaillastdone_.timestamp_ BETWEEN
97864920 AND 978735599099) ORDER BY
retaillastdone_.owner_,retaillastdone_.timestamp_ ASC ;
I get the error
ERROR 1030: Got error 22275 from table handler
however, I am sure my tables arent corrupted as I ran myisamchk on it.
The interesting thing is that the following query executes without any problems
SELECT retaillastdone_.* FROM retaillastdone_ WHERE
(retaillastdone_.source_=mercury AND retaillastdone_.timestamp_ BETWEEN
97864920 AND 978735599099) ORDER BY
retaillastdone_.owner_,retaillastdone_.timestamp_ ASC limit 10;
I used the email-support and got a reply from Sergei that its bug. Thus, Iam sending
this testcase.
How-To-Repeat:
I am attaching the table retaillastdone with the bug. If you run the same query, that
gives problems to me, the bug can be reproduced.
Fix:
Appened limit 10 at the end of the query as I did above, it will work fine.
Submitter-Id: maarten4688
Originator:maarten4688
Organization: IMC. B.V
MySQL support: email support
Synopsis: The problem is mentioned above .
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.39 (Official MySQL binary)
Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.39
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 20 hours 53 min 2 sec
Threads: 11 Questions: 12871549 Slow queries: 0 Opens: 887 Flush tables: 1 Open
tables: 64 Queries per second avg: 171.205
Environment:
System: Linux goofy2 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/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/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx1 root root 13 Jan 17 16:22 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root 1282588 Sep 4 21:49 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 Sep 4 21:34 /usr/lib/libc.a
-rw-r--r--1 root root 178 Sep 4 21:34 /usr/lib/libc.so
lrwxrwxrwx1 root root 10 Jan 17 16:38 /usr/lib/libc-client.a -
c-client.a
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
-
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