[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