>Description:
MySQL crashes after issueing the following command :
UPDATE BGW_Master, ICA_1_SplitInter
SET ICA_1_SplitInter.I1_Proc_Dt = BGW_Master.I1_Proc_Dt
WHERE BGW_Master.I1_FileName = ICA_1_SplitInter.I1_FileName
AND BGW_Master.I1_runDate = ICA_1_SplitInter.I1_runDate
AND ICA_1_SplitInter.I1_Proc_Dt is null;
This is wierd since it not such a complex SQL after all...
>How-To-Repeat:
Resumbit the SQL above....
>Fix:
Not found a workaround yet...
>Submitter-Id: Bas van Ritbergen
>Originator: Super-User
>Organization: O2 the Netherlands
Haaksbergweg 75
1101 BR Amsterdam ZO
+31-20-2004365
>MySQL support: none
>Synopsis: MySQL crashes
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.4-beta-max (Official MySQL-max binary)
>Environment:
System: SunOS amBGw1 5.7 Generic_106541-17 sun4u sparc SUNW,Ultra-Enterprise
Architecture: sun4
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld
--disable-nls
Thread model: posix
gcc version 3.2
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1707532 Oct 16 2001 /lib/libc.a
lrwxrwxrwx 1 root root 11 Sep 5 2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1125056 Oct 16 2001 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1707532 Oct 16 2001 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Sep 5 2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1125056 Oct 16 2001 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared
--with-berkeley-db CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3
-fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc
---------------------------------------------------------------------
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
