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

Reply via email to