Hi,
Just a guess, but I expect that the first response will be to use gcc 2.95.2
or later
Quentin
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, 9 April 2001 1:30 p.m.
To: [EMAIL PROTECTED]
Subject: REXEXP in select only works with short expressions on Alpha
>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
---------------------------------------------------------------------
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
