Hi,
Running isamchk -r did not help. Any other ideas, anybody ?
Tonu Samuel wrote:
>
> Mogens Melander wrote:
>
> > Could it be a bug in the 3.23.5 client ???
> > mysql> update transfer set yymmdd=(yy*10000)+(mm*100)+dd where yymmdd=0;
> > Query OK, 0 rows affected (48.76 sec)
> > Rows matched: 0 Changed: 0 Warnings: 0
> > mysql> select count(*) from transfer where yymmdd=0;
> > +----------+
> > | count(*) |
> > +----------+
> > | 1167765 |
> > +----------+
> > 1 row in set (15.69 sec)
>
> Try to recheck your tables with isamchk -r. This seems like something is
> broken.
>
> --
> +----------------------------------------------------------------+
> | TcX ____ __ _____ _____ ___ |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
> | /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +----------------------------------------------------------------+
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread26030@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-mogens=fumlersoft.dk@stripped>
--
Later
Mogens Melander mailto:mogens@stripped
http://www.fumlersoft.dk http://www.trader.dk
http://www.birkerod.dk http://tux.trader.dk
