Page MenuHomePhabricator

hebrew wikipedia tools databases in tools
Closed, InvalidPublic

Description

Author: orenbochman

Description:
When running the following query on the a query on the Hebrew language database in tool labs there are some Unexpected results.

SELECT rev_user_text, page_title FROM revision
JOIN page ON page_id = rev_page
JOIN user_groups ON ug_user = rev_user
WHERE page_namespace = '3'
AND page_is_redirect = '0'
AND ug_group != 'bot'
AND page_title NOT LIKE '%/%';

Methinks This may be a collation issue or something to do with slash definition.


Version: unspecified
Severity: normal
Whiteboard: aklapper-moreinfo

Details

Reference
bz52151

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 1:55 AM
bzimport added a project: Cloud-VPS.
bzimport set Reference to bz52151.

What's the expected output, what do you get instead?

Oren:

(In reply to Tim Landscheidt from comment #1)

What's the expected output, what do you get instead?

Also, is this still a problem?

Unfortunately closing this report as no further information has been provided.

orenbochman: Please feel free to reopen this report if you can provide the information asked for in comment 1 and comment 2, and if this still happens. Thanks!