>Description: I am using MySQL 5.x on FreeBSD 5.4-PRE together with libpthread. These are the knobs I did provide to make (to compile the actual FreeBSD port):
FORCE_PKG_REGISTER=yes \ WITH_OPENSSL=yes \ BUILD_OPTIMIZED=yes \ WITH_PROC_SCOPE_PTH=yes If executing the following SQL query, mysqld will quit with a SIGSEGV signal. SELECT post_urltitle FROM evo_posts WHERE post_urltitle REGEXP '^erster_eintrag(_[0-9]+)?$' AND ID <> 0; >How-To-Repeat: Just execute the just provided SQL expression on the same FreeBSD system. >Fix: No idea. >Submitter-Id: <submitter ID> >Originator: Daniel S. Haischt >Organization: Daniel S. Haischt Mit freundlichen Gruessen / With kind regards DAn.I.El S. Haischt Want a complete signature??? Type at a shell prompt: $ > finger -l [EMAIL PROTECTED] >MySQL support: none >Synopsis: MySQL coredumps on FreeBSD if the SQL query contains a regexp >expression >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-5.0.2-alpha (FreeBSD port: mysql-client-5.0.2) >C compiler: cc (GCC) 3.4.2 [FreeBSD] 20040728 >C++ compiler: c++ (GCC) 3.4.2 [FreeBSD] 20040728 >Environment: System: FreeBSD abyssone.abyssworld.de 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE #4: Fri Mar 4 15:10:39 CET 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/ABYSSONE i386 Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.4.2 [FreeBSD] 20040728 Compilation info: CC='cc' CFLAGS='-O -pipe -O2 -O3 -fno-omit-frame-pointer -fno-gcse' CXX='c++' CXXFLAGS='-O -pipe -O2 -O3 -fno-omit-frame-pointer -fno-gcse -O2 -felide-constructors -fno-exceptions -fno-rtti -O -pipe -O2 -O3 -fno-omit-frame-pointer -fno-gcse -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=' -rpath=/usr/local/lib' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 883816 Mar 3 17:16 /lib/libc.so.5 -r--r--r-- 1 root wheel 1876040 Mar 3 17:16 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 14 Mar 3 17:16 /usr/lib/libc.so -> /lib/libc.so.5 lrwxr-xr-x 1 root wheel 16 Dec 1 13:13 /usr/lib/libc.so.4 -> /usr/lib/libc.so Configure command: ./configure '--localstatedir=/var/db/mysql' '--with-debug' '--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-client-5.0.2' '--enable-thread-safe-client' '--with-openssl=/usr/local' '--enable-assembler' '--with-berkeley-db' '--with-named-thread-libs=-pthread' '--without-server' '--prefix=/usr/local' '--build=i386-portbld-freebsd5.4' 'LDFLAGS= -rpath=/usr/local/lib' 'CFLAG S=-O -pipe -O2 -O3 -fno-omit-frame-pointer -fno-gcse' 'CXX=c++' 'build_alias=i386-portbld-freebsd5.4' 'CC=cc' 'CXXFLAGS=-O -pipe -O2 -O3 -fno-omit-frame-pointer -fno-gcse -O2 -felide-constructors -fno-exceptions -fno-rtti -O -pipe -O2 -O3 -fno-omit-frame-pointer -fno-gcse -felide-constructors -fno-rtti -fno-exceptions' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]