[前][次][番号順一覧][スレッド一覧]

mysql:2935

From: Tatsuhiko Miyagawa <Tatsuhiko Miyagawa <miyagawa@xxxxxxxxxx>>
Date: Thu, 28 Dec 2000 15:24:10 +0900
Subject: [mysql 02935] Re: 3.23.29 で update が効かない!?

宮川です。

On Mon, 18 Dec 2000 07:11:20 +0900
Hiroyuki Hasegawa <admin@xxxxxxxxxx> wrote:
> 
> > 
> > matchがそもそもrowなのです。
> > エラーなどはでません。
> 
> matchするrowがゼロで、エラーなしということです。
> 
> たとえば、
> 
> mysql> update ○○ set flag=0 where no=1031874;
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 0  Changed: 0  Warnings: 0
> 
> こんな感じです。
> selectでそのnoを打つともちろん認識します。

こちら解決されたでしょうか?
本家ML でこんなメールが流れてましたので、ご参考まで。



----------------------- Original Message -----------------------
 From:    "Vadim P." <vadim@xxxxxxxxxx>
 To:      len@xxxxxxxxxx
 Cc:      mysql@xxxxxxxxxx
 Date:    Wed, 27 Dec 2000 14:38:24 -0500
 Subject: Re: UPDATE ... WHERE ...    problems
----

Upgrade to 3.23.29a or build it from source. This issue has already been
discussed and addressed here some time ago. The '3.23.29' binaries had
some bugs, which were taken care of in the '3.23.29a'.

Cheers,
Vadim.

len@xxxxxxxxxx wrote:
> 
> >Description:
>         UPDATE ... WHERE  ... doesn't works well in MySQL 3.23.29-gamma
> >How-To-Repeat:
>         create database test_db;
>         CREATE TABLE t (
>           id int(11) NOT NULL default '0' auto_increment,
>           name varchar(128),
>           PRIMARY KEY (id)
>         );
> 
>         INSERT INTO t VALUES (1,'asdf');
>         INSERT INTO t VALUES (2,'ASDF');
> 
>         # now we are ready to test update...
> 
>         update t set name="some_other" where id=2;
> 
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 0  Changed: 0  Warnings: 0
> 
>         It's wrong behaviour... The same code works well in MySQL 2.22.32.
> Note that update works when there are any other condition in 'where clause'.
> But doesn't work if there are comparing with value from key column...
> 
> >Fix:
> 
> >Submitter-Id:  <submitter ID>
> >Originator:    Eugene Lineitzev
> >Organization:
> 
> >MySQL support: none
> >Synopsis:      UPDATE ... WHERE ...    seems be broken in MySQL 2.23.29-gamma
> >Severity:      critical
> >Priority:      high
> >Category:      mysql
> >Class:         sw-bug
> >Release:       mysql-3.23.29-gamma (Official MySQL RPM)
> >Server: /usr/bin/mysqladmin  Ver 8.13 Distrib 3.23.29-gamma, for pc-linux-gnu on i686
> 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.29-gamma
> Protocol version        10
> Connection              Localhost via UNIX socket
> UNIX socket             /var/lib/mysql/mysql.sock
> Uptime:                 26 min 42 sec
> 
> Threads: 1  Questions: 17  Slow queries: 0  Opens: 8  Flush tables: 1  Open tables: 1 Queries per second avg: 0.011
> >Environment:
> 
> System: Linux Main.Dark.Tsk.Ru 2.2.16-3 #1 Sun Aug 13 23:52:44 TSD 2000 i586 unknown
> Architecture: i586
> 
> 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/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='egcs'  CFLAGS=' -O6 -fomit-frame-pointer'  CXX='egcs'  CXXFLAGS=' -O6 -fomit-frame-pointer                  -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
> LIBC:
> lrwxrwxrwx    1 root     root           13 Aug 14 03:31 /lib/libc.so.6 -> libc-2.1.3.so
> -rwxr-xr-x    1 root     root      4101324 Mar  1  2000 /lib/libc-2.1.3.so
> -rw-r--r--    1 root     root     20272704 Mar  1  2000 /usr/lib/libc.a
> -rw-r--r--    1 root     root          178 Mar  1  2000 /usr/lib/libc.so
> Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db '--with-comment=Official MySQL RPM'
> Perl: This is perl, version 5.005_03 built for i386-linux
> 



--
Tatushiko Miyagawa              Bulknews http://bulknews.net/
mailto:miyagawa@xxxxxxxxxx    Perl Lib http://bulknews.net/lib/


[前][次][番号順一覧][スレッド一覧]

      2877 2000-12-18 06:57 [Hiroyuki Hasegawa <a] 3.23.29 で update が効かない!?        
      2878 2000-12-18 07:11 ┗[Hiroyuki Hasegawa <a]                                       
->    2935 2000-12-28 15:24  ┗[Tatsuhiko Miyagawa <]                                     
      2936 2000-12-28 19:05   ┣[Hiroyuki Hasegawa <a]                                   
      2943 2001-01-04 10:20   ┗[Hiroyuki Hasegawa <a] Re: 3.23.29 で update が効かない!? ( 解決)