Page MenuHomePhabricator

MediaWiki-extensions-ReplaceText causes SQL Error on Ubuntu 2020 using mySQL 8.0.22
Closed, DuplicatePublicBUG REPORT

Description

Steps to Reproduce:

On line 54 in src/ReplaceTextSearch.php, the sql query assembled triggers an syntax error.
After changing it from:

'CAST(SUBSTRING(content_address, 4) AS INTEGER) = old_id'

to:

'CAST(SUBSTRING(content_address, 4) AS SIGNED) = old_id'

it worked.

Actual Results:
Syntax Error

Expected Results:
No Syntax Error :-/

I wrote also a comment on github, but since github isnt't an official channel, I filed a report here as well.

Kind Regards