Bug #19407 Test 'func_regexp' fails on Windows x64
Submitted: 27 Apr 2006 19:50 Modified: 22 Jun 2006 14:03
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.21 OS:Windows (Windows 2003 x64)
Assigned to: Iggy Galarza CPU Architecture:Any

[27 Apr 2006 19:50] Kent Boortz 
Description:
Test 'func_regexp' fails with

 *** r/func_regexp.result       Thu Apr 27 17:59:31 2006
 --- r/func_regexp.reject       Thu Apr 27 19:04:55 2006
 ***************
 *** 43,49 ****
   Note 1003    select `test`.`t1`.`xxx` AS `xxx` from `test`.`t1` where (`test`.`t1`.`xxx` regexp _latin1'is a test of some long text to')
   select * from t1 where xxx regexp('is a test of some long text to ');
   xxx
 - this is a test of some long text to see what happens
   select * from t1 where xxx regexp('is a test of some long text to s');
   xxx
   this is a test of some long text to see what happens
 --- 43,48 ----

How to repeat:
Run the test case on Windows x64
[20 Jun 2006 2:18] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7887
[20 Jun 2006 15:30] Elliot Murphy 
Discussed fix, approved.
[20 Jun 2006 20:54] Iggy Galarza 
Fix submitted for 5.0.23.
[22 Jun 2006 14:03] Paul DuBois 
Noted in 5.0.23 changelog.

On 64-bit Windows systems, REGEXP for regular expressions with
exactly 31 characters did not work.