Hi,
Upgrading the server to ver. 3.23.8-alpha seems to fix the hickup.
Now i "just" has to rerun consolidations since 19991201 :(
Anyway, this do not account for the fact that the remote 3.22.x client
did not have the same problem against the 3.23.5-alpha server.
And, by the way. There was nothing wrong with the query or
the arithmetic, as my initial post did show :^P Nor with the table.
mysql> select distinct (yy*10000)+(mm*100)+dd as yymmdd
> from transfer where yymmdd=0 limit 20;
+----------+
| yymmdd |
+----------+
| 19991226 |
| 19991229 |
| 19991227 |
Anyway, thanks for your response.
sasha@stripped wrote:
>
> Mogens Melander wrote:
> >
> > Hi,
> >
> > Running isamchk -r did not help. Any other ideas, anybody ?
>
> It seems to me that on all the rows where yymmdd is 0 yy * 10000 + mm * 100 +
> dd also evaluates to 0 -- update will not report any affected rows if the value
> did not have to be changed.
>
> If the above does not sound right, post describe on your table, and it might
> shed some light -- you might have a type confict somewhere, and the arithmetic
> might not be working quite right.
>
> >
> > 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.
> <cut>
>
> --
> Sasha Pachev
>
> +------------------------------------------------------------------+
> | TcX ____ __ _____ _____ ___ == mysql@stripped |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
> | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +------------------------------------------------------------------+
--
Later
Mogens Melander mailto:mogens@stripped
http://www.fumlersoft.dk http://www.trader.dk
http://www.birkerod.dk http://tux.trader.dk
