(embarasing subject line typo fixed)
On Tue, 10 Apr 2001, Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writes:
>
[snip]
>
> >> [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)
>
> <cut>
>
> Thanks for the clear test case; This enabled me to find a cast bug
> for 64 bit machines in the regex library.
>
> Here is a patch for this:
>
[snip]
Thankyou for the patch - it certainly improves the situation (and fixes
the test case I gave) but I seem to have found another problem with regexp
:(
The following test case results in the mysql server taking 100% CPU and
not returning. Unfortunatly I have not been able to isolate a simpler
regular expression that causes the problem yet. I will try again
tommorow.
mysql> create table test (xxx char(128));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test (xxx)
-> values('this is some text: to test - out.reg exp (22/45)');
Query OK, 1 row affected (0.00 sec)
mysql> select * from test where xxx REGEXP
-> '^this is some text: to test - out\\.reg exp
[[(][0-9]+[/\\][0-9]+[])][ ]*$' ;
(Note in the select it is "exp [[(" I inserted the line break)
Stephen
---------------------------------------------------------------------
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