List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:February 2 2000 12:05am
Subject:Re: Update wierdness
View as plain text  
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
Thread
Update wierdnessMogens Melander1 Feb
  • Re: Update wierdnessTonu Samuel1 Feb
  • Re: Update wierdnessMogens Melander1 Feb
  • Re: Update wierdnesssasha1 Feb
  • Re: Update wierdnessMogens Melander2 Feb