>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
---------------------------------------------------------------------
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