On Mon, 9 Apr 2001, Sinisa Milivojevic wrote:
The problem still exists on gcc 2.95.3 (I was part way through installing
this when I recieved your mail - I can try 2.95.2 if you think that would
be usefull)
The new information captured from mysqlbug is as follows
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 min 39 sec
Threads: 1 Questions: 15 Slow queries: 0 Opens: 8 Flush tables: 1 Open tables: 1
Queries per second avg: 0.094
>Environment:
System: Linux rossem.octopus-technologies.co.uk 2.2.14-6.0 #1 Tue Mar 28 16:56:56 EST
2000 alpha unknown
Architecture: alpha
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc
GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-unknown-linux-gnu/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Apr 7 17:16 /lib/libc.so.6.1 ->
libc-2.1.3.so
-rwxr-xr-x 1 root root 8070122 Mar 27 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 18837112 Mar 27 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 180 Mar 27 2000 /usr/lib/libc.so
Configure command: ./configure
Perl: This is perl, version 5.005_03 built for alpha-linux
> [EMAIL PROTECTED] writes:
> > >Description:
> > When transfering a database application to use an Alpha Linux server
> > rather than intel Linux previously working regular expressions fail to work.
> > It appears to be due to a length limit. This effects both binary downloads
> > and home compiled distributions.
> > >How-To-Repeat:
> > Simple test case (with results)
> > mysql> create table test (xxx char(128));
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> insert into test (xxx) values('this is a test of some long text to see
>what happens');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> select * from test where xxx regexp('is a test of some long text to');
>+------------------------------------------------------+
> > | xxx |
> > +------------------------------------------------------+
> > | this is a test of some long text to see what happens |
> > +------------------------------------------------------+
> > 1 row in set (0.00 sec)
> >
> > mysql> select * from test where xxx regexp('is a test of some long text to ');
> > Empty set (0.00 sec)
> >
> > mysql> select * from test where xxx regexp('is a test of some long text to s');
> > Empty set (0.00 sec)
> >
> > mysql> select * from test where xxx regexp('is a test of some long text to se');
> > Empty set (0.00 sec)
> >
> > mysql> select * from test where xxx regexp('test of some long text to se');
>+------------------------------------------------------+
> > | xxx |
> > +------------------------------------------------------+
> > | this is a test of some long text to see what happens |
> > +------------------------------------------------------+
> > 1 row in set (0.00 sec)
> >
> >
> > >Fix:
> >
> > Unknown - I have revererted to the working Intel system - hopefully this a fix
> > will be found soon since the original move was due to capacity problems on the
> > intel hardware !
> >
> >
> > >Submitter-Id: <submitter ID>
> > >Originator: [EMAIL PROTECTED]
> > >Organization:
> >
> > >MySQL support: [none]
> > >Synopsis: on linux Alpha regexp does not work with long expressions
> > >Severity: critical
> > >Priority: high
> > >Category: mysql
> > >Class: sw-bug
> > >Release: mysql-3.23.36 (Source distribution)
> >
> > >Environment:
> >
> > System: Linux rossem.octopus-technologies.co.uk 2.2.14-6.0 #1 Tue Mar 28 16:56:56
>EST 2000 alpha unknown
> > Architecture: alpha
> >
> > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> > GCC: Reading specs from /usr/lib/gcc-lib/alpha-redhat-linux/egcs-2.91.66/specs
> > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> > Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> > LIBC:
> > lrwxrwxrwx 1 root root 13 Apr 7 17:16 /lib/libc.so.6.1 ->
>libc-2.1.3.so
> > -rwxr-xr-x 1 root root 8070122 Mar 27 2000 /lib/libc-2.1.3.so
> > -rw-r--r-- 1 root root 18837112 Mar 27 2000 /usr/lib/libc.a
> > -rw-r--r-- 1 root root 180 Mar 27 2000 /usr/lib/libc.so
> > Configure command: ./configure
> > Perl: This is perl, version 5.005_03 built for alpha-linux
> >
>
>
> Hi!
>
> Please try using gcc 2.95.2 and let us know if problem reccurs.
>
>
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
---------------------------------------------------------------------
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