Ok, upon installing this at work, I noticed that I couldn't login or logout of drupal. After about 5 hours of searching, I finally came to the conclusion that there is a problem with mysql 4.1.3-beta-log on RH Es3 Taroon 2. http://bugs.mysql.com/bug.php?id=5533 Is the bug report I filed.

Now, what the problem is that sid had a key length of 4 in a 32 char column. This is fine normally, but on some compilations of mysql on certain systems, this would not return any matches. this is reason one.

Reason two is because using a fulltext index is very fast and not to mention not that costly to impliment for systems that contain this bug.

CommentFileSizeAuthor
keys-database.mysql.patch.txt174 bytescrackerjackmack
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Dries’s picture

Committed to HEAD.

Anonymous’s picture