>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