>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
