Thanks for the patch and the rapid response :)
My application has been running with this patch for 15 hours now - and has
done over 2 million regexp matches without problems :)
Stephen
On Wed, 11 Apr 2001, Michael Widenius wrote:
>
> >>>>> "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writes:
>
> Stephen> On Tue, 10 Apr 2001, Michael Widenius wrote:
>
> <cut>
>
> Stephen> Thankyou for the patch - it certainly improves the situation (and fixes
> Stephen> the test case I gave) but I seem to have found another problem with regexp
> Stephen> :(
>
> Stephen> The following test case results in the mysql server taking 100% CPU and
> Stephen> not returning. Unfortunatly I have not been able to isolate a simpler
> Stephen> regular expression that causes the problem yet. I will try again
> Stephen> tommorow.
>
> <cut>
>
> No need for that!
>
> Here is a tested patch for this:
>
> ===== regex/engine.c 1.2 vs edited =====
> *** /tmp/engine.c-1.2-28594 Wed Aug 30 22:42:05 2000
> --- edited/regex/engine.c Wed Apr 11 19:04:46 2001
> ***************
> *** 828,834 ****
> register sopno pc;
> register onestate here; /* note, macros know this name */
> register sopno look;
> ! register int i;
>
> for (pc = start, INIT(here, pc); pc != stop; pc++, INC(here)) {
> s = g->strip[pc];
> --- 828,834 ----
> register sopno pc;
> register onestate here; /* note, macros know this name */
> register sopno look;
> ! register onestate i; /* Changed from int by Monty */
>
> for (pc = start, INIT(here, pc); pc != stop; pc++, INC(here)) {
> s = g->strip[pc];
>
> Regards,
> Monty
>
---------------------------------------------------------------------
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