Fwd: #747 [NEW]: using an index on some regular expressions

Hi,

PeterG,

Could you please comment this bug and the bug #746.

Thank you in advance.


>Date: 28 Jun 2003 13:44:25 -0000
>To: dev-bugs@mysql.com
>Subject: #747 [NEW]: using an index on some regular expressions
>From: Bug Database



From: Daniel Penning
>Priority: Low
>Status: Open
>Severity: Feature request
>Category: Server
>Reported by: User
>Reported at:
>Email subject:
>Email date:
>Release:
>Operating system:
>
>Bug description: using an index on some regular expressions
>
>Description:
>regular expressions starting with constant characters and those starting
>with a small character range (e.g. [a-d].*) should be able to use an index
>to speed up the search.
>
>while this performance improvement is not implemented a workarround should
>be mentionend into the documentation:
>
>SELECT * FROM foo WHERE bar RLIKE 't[aeiou].*'
>should be changed to
>SELECT * FROM foo WHERE bar LIKE 't%' AND bar RLIKE 't[aeiou].*'
>
>How to repeat:
>-
>
>Suggested fix:




--=20
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: Fwd: #747 [NEW]: using an index on some regular expressions

Hi Miguel,


On Mon, 2003-07-07 at 22:45, miguel solorzano wrote:
> Hi,
>
> PeterG,
>
> Could you please comment this bug and the bug #746.
>
> Thank you in advance.
>
>


I have replied to BUG#746 (adding "SIMILAR TO" as an alias
for RLIKE), and closed it on the grounds that SIMILAR TO
is inappropriate as an alias for RLIKE, with explanations.
At the same time, without informing the complainer, I added
a new worklog raw idea bin entry: WL#1059 "SIMILAR predicate".

I have replied to BUG#747, which is a feature request for
indexing for RLIKE (i.e. REGEXP), and closed it on the
grounds that one can get use of indexes with LIKE. We
in fact have a worklog entry WL#353 "faster REGEXP package"
so I cautiously hinted that we'll do something someday.

I rarely do this. So you might want to check the replies
and ensure that I haven't done something terrible.


Regards,
PeterG
2003-07-14


--
Peter Gulutzan, Software Architect
MySQL AB, www.mysql.com
Office: +1 780 472-6838

Are you MySQL certified? www.mysql.com/certification


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org