Maniphest T199506

Investigate possible issues with PostgreSQL
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	matej_suchanek
	Jul 13 2018, 7:36 AM

Description

At the top of the file, there is a note in abusefilter.tables.pg.sql.

abusefilter.tables.pg.sql

-- Note: This does not currently work, as the extension generates queries
-- like this: SELECT af_hidden FROM abuse_filter WHERE af_id = 'new' LIMIT 1
-- Which makes no sense as af_id is a BIGINT in the MySQL version of the schema

Investigate if this is still truth, and if so, fix it.

Details

	Subject	Repo	Branch	Lines +/-
	Remove obsolete comment from abusefilter.tables.pg.sql	mediawiki/extensions/AbuseFilter	master	+0 -4

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Resolved	None	T254646 Reconsidering how we name things
Open	None	T281536 Schema:EditAttemptStep uses non-inclusive language.
Open	None	T279275 Move all the functionality of {Spam,Title}Blacklist extensions into AbuseFilter and retire them
Resolved	None	T290934 Expand the set of bundled extensions and skins in MediaWiki 1.38
Resolved	Daimona	T191740 Bundle AbuseFilter extension with MediaWiki
Resolved	Daimona	T199544 Make AbuseFilter work on PostgreSQL and SQLite (epic)
Resolved	matej_suchanek	T199506 Investigate possible issues with PostgreSQL

Event Timeline

matej_suchanek created this task.Jul 13 2018, 7:36 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 13 2018, 7:36 AM

matej_suchanek updated the task description. (Show Details)Jul 13 2018, 7:42 AM

Daimona added a parent task: T199544: Make AbuseFilter work on PostgreSQL and SQLite (epic).Jul 13 2018, 2:52 PM

I guess this was fixed in rEABF942a95e80e95466b49f9ac9c14e1e1a249d5a507?

Change 445961 had a related patch set uploaded (by Matěj Suchánek; owner: Matěj Suchánek):
[mediawiki/extensions/AbuseFilter@master] Remove obsolete comment from abusefilter.tables.pg.sql

https://gerrit.wikimedia.org/r/445961

gerritbot added a project: Patch-For-Review.Jul 16 2018, 9:27 AM

Daimona assigned this task to matej_suchanek.Jul 16 2018, 10:09 AM

Change 445961 merged by jenkins-bot:
[mediawiki/extensions/AbuseFilter@master] Remove obsolete comment from abusefilter.tables.pg.sql

https://gerrit.wikimedia.org/r/445961

Daimona closed this task as Resolved.Jul 16 2018, 10:07 PM