>Description:
When i execute the following query on my database:
SELECT retaillastdone_.* FROM retaillastdone_ WHERE
(retaillastdone_.source_="mercury" AND retaillastdone_.timestamp_ BETWEEN
978649200000 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
978649200000 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 version 10
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 20000731 (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:
lrwxrwxrwx 1 root root 13 Jan 17 16:22 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 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
lrwxrwxrwx 1 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
