Page MenuHomePhabricator
Create Task
Maniphest T73027

RegExp search and replace doesn't work with MS Sql SERVER
Closed, DeclinedPublic
Actions

Description

Author: emadelwany

Description:
MS SQL Server doesn't support the REGEXP operator which causes queries to fail with the following error:

SQL ERROR: [SQLSTATE 42000][Error Code 102][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'REGEXP'.
[SQLSTATE 42000][Error Code 8180][Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.
[SQLSTATE 01000][Error Code 16954][Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.

Version: REL1_23-branch
Severity: normal

Details

Reference
bz71027

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:55 AM
• bzimport added a project: MediaWiki-extensions-ReplaceText.
• bzimport set Reference to bz71027.
• bzimport added a subscriber: Unknown Object (MLST).
• bzimport created this task.Sep 18 2014, 11:13 PM
Aklapper triaged this task as Low priority.Apr 2 2015, 2:48 PM
Aklapper subscribed.
labster subscribed.Aug 7 2016, 1:59 AM

As far as I can tell, SQL Server does not support regular expressions -- or at least not without using a CLR function.

In theory, we could just add LIKE '%$target%' as the operation for this, and it would work on some simple searches (including basic character classes), but that would be pretty non-optimal.

tstarling added a project: MSSQL.May 19 2017, 10:11 AM
tstarling removed a parent task: T11767: [DO NOT USE] Microsoft SQL Server/MSSQL support (tracking).May 19 2017, 10:15 AM
Aklapper added a comment.Sep 26 2019, 8:28 AM

Heads-up: As per RFC discussion in August 2019, the previously experimental support for using Oracle or MSSQL as database backends in MediaWiki core has been removed in MediaWiki 1.34.

Kghbln closed this task as Declined.Feb 2 2021, 3:14 PM
Kghbln subscribed.

MediaWiki and its extensions no longer support MSSQL.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits