Dieter Becker writes:
> >Description:
> Update does not work correctly
> >How-To-Repeat:
> Don't know
> >Fix:
>
> Please look to the followin output:
>
> mysql> select * from hkt_op_anmeld where hktnr = 63833;
>
>+------------+-------+------------+------+------+------+------+------+------+------+------+------+----------+------------+--------------+------------+---------+------+------+-----------+------------+-----------+--------------+----------+-------+-----------+--------+--------------+
> | izahl | hktnr | blutspende | byp1 | byp2 | byp3 | byp4 | byp5 | byp6 | ak |
>mk | tk | op_sonst | indikation | versicherung | stationaer | doppler | hno |
>zmk | varikosis | agg_hemmer | anti_koag | niereninsuff | diabetes | p_avk |
>stat_arzt | bemerk | anmeld_datum |
>
>+------------+-------+------------+------+------+------+------+------+------+------+------+------+----------+------------+--------------+------------+---------+------+------+-----------+------------+-----------+--------------+----------+-------+-----------+--------+--------------+
> | SCH210536O | 63833 | NULL | 132 | 135 | 157 | 106 | NULL | NULL | E |
>NULL | NULL | NULL | E | NULL | NULL | NULL | NULL |
>NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL
> | NULL | 2001-03-21 |
>
>+------------+-------+------------+------+------+------+------+------+------+------+------+------+----------+------------+--------------+------------+---------+------+------+-----------+------------+-----------+--------------+----------+-------+-----------+--------+--------------+
> 1 row in set (0.01 sec)
>
> mysql> update hkt_op_anmeld set izahl = "SCH210536N" where izahl = "SCH210536O";
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> update hkt_op_anmeld set izahl = "SCH210536N" where izahl = "SCH210536O";
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> update hkt_op_anmeld set izahl = "SCH210536N" where izahl = "SCH210536O";
> Query OK, 1 row affected (0.01 sec)
> Datensätze gefunden: 1 Geändert: 1 Warnungen: 0
>
> the third call works. Nothing was done in between.
>
>
> >Submitter-Id: <submitter ID>
> >Originator: Dieter Becker
> >Organization:
> Dr. med. dipl.-math Dieter Becker Tel.: (0 / +49) 6841 - 16 3046
> Medizinische Universitaets- und Poliklinik Fax.: (0 / +49) 6841 - 16 3043
> Innere Medizin III
> D - 66421 Homburg / Saar Email: [EMAIL PROTECTED]
>
>
> >
> >MySQL support: email support
> >Synopsis:
> >Severity: critical
> >Priority:
> >Category: mysql
> >Class:
> >Release: mysql-3.23.35 (Source distribution)
> >Server: /usr/local/bin/mysqladmin Ver 8.18 Distrib 3.23.35, for sun-solaris2.6 on
>sparc
> 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.35-log
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 8 hours 25 min 53 sec
>
> Threads: 57 Questions: 87567 Slow queries: 0 Opens: 2328 Flush tables: 1275
>Open tables: 6 Queries per second avg: 2.885
> >Environment:
>
> System: SunOS ukh3029 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-2
> Architecture: sun4
>
> Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
>/d0/workshop/SUNWspro/bin/cc
> GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
> -rw-r--r-- 1 bin bin 1607728 Oct 19 1999 /lib/libc.a
> lrwxrwxrwx 1 root root 11 Feb 8 1998 /lib/libc.so -> ./libc.so.1
> -rwxr-xr-x 1 bin bin 1014088 Oct 19 1999 /lib/libc.so.1
> -rw-r--r-- 1 bin bin 1607728 Oct 19 1999 /usr/lib/libc.a
> lrwxrwxrwx 1 root root 11 Feb 8 1998 /usr/lib/libc.so -> ./libc.so.1
> -rwxr-xr-x 1 bin bin 1014088 Oct 19 1999 /usr/lib/libc.so.1
> Configure command: ./configure --with-charset=latin1 --with-extra-charsets=all
> Perl: This is perl, version 5.005_02 built for sun4-solaris
>
Hi!
I have just posted a patch that fixes the above problem.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
