Modify

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#2778 closed Feature Request (Rejected)

include REGEXP function in to SQLite

Reported by: anonymous Owned by:
Milestone: Component: Standard UDFs
Version: Severity: None
Keywords: Cc:

Description

documentation on sqlite site said:
The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally result in an error message. If an application-defined SQL function named "regexp" is added at run-time, then the "X REGEXP Y" operator will be implemented as a call to "regexp(Y,X)".
so i went ahead and try but (obviously) get :

--> Error:    no such function: REGEXP

so - can regexp be included in you compilation of sqlite x86/x64 dll?

Attachments (0)

Change History (4)

comment:1 Changed 5 years ago by TicketCleanup

  • Version Other deleted

Automatic ticket cleanup.

comment:2 Changed 5 years ago by jchd18

Regexp operator isn't very useful because it is so slow and contrary to LIKE and GLOB, can't benefit from any index. That's why no regexp function comes as standard.

However a simple (non-PCRE) implementation is available in the source tarball of the official website, under directory .\ext\misc\regexp.c which is ready to be compiled into an SQLite extension DLL.

comment:3 Changed 5 years ago by guinness

  • Resolution set to Rejected
  • Status changed from new to closed

Guidelines for posting comments:

  • You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
  • In-depth discussions should take place on the forum.

For more information see the full version of the ticket guidelines here.

Add Comment

Modify Ticket

Action
as closed The ticket will remain with no owner.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.