root writes: > >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. >
Hi! Table has not arrived with your mail. It is possible that it got stripped away. Please upload your table to ftp://support.mysql.com:/pub/mysql/secret and let us know it's filename. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- 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