CAST AS INTEGER not supported by MySQL 5.6 and 5.7
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Kghbln
	Oct 2 2020, 12:03 PM

Description

Originally reported on mediawiki.org with this topic.

It appears that CAST AS INTEGER is not supported by MySQL 5.6 and 5.7 introduced with bcd6b2f732824d26a55ff3892442e143df7994a6

As a fix it is suggested to replace CAST(SUBSTRING(content_address, 4) AS INTEGER) = old_id' with 'CAST(SUBSTRING(content_address, 4) AS SIGNED) = old_id' in "/ReplaceTextSearch.php"

Related Objects

Mentioned In: T280102: Special:ReplaceText throws DB error on Postgres
Mentioned Here: rERPTbcd6b2f73282: Fix for 7f823dfccbc4 - restore support for PostgreSQL

Event Timeline

Kghbln created this task.Oct 2 2020, 12:03 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 2 2020, 12:03 PM

Hi, thanks for opening this ticket. My teammate created a patch for this on gerrit.

Tenbergen subscribed.Oct 5 2020, 3:41 AM

Reedy merged a task: T269006: MediaWiki-extensions-ReplaceText causes SQL Error on Ubuntu 2020 using mySQL 8.0.22.Nov 30 2020, 4:05 PM

Reedy added subscribers: Bugger2020, Yaron_Koren.

The aforementioned patch has been merged. This issue can now be closed!

Thanks a ton. Probably an idea to back-port to 1.35.

In T264433#6704610, @Kghbln wrote:

Thanks a ton. Probably an idea to back-port to 1.35.

Yes please do, as example on the Extension talk page MW 1.35 Replace Text 1.4.1 many are trying to figure this out.

Tiffany352 mentioned this in T280102: Special:ReplaceText throws DB error on Postgres.Apr 14 2021, 1:52 AM

CAST AS INTEGER not supported by MySQL 5.6 and 5.7Closed, ResolvedPublicActions

Description

Related Objects

Event Timeline

CAST AS INTEGER not supported by MySQL 5.6 and 5.7
Closed, ResolvedPublic
Actions