Year- and Month- precision date queries return wrong results for "before" relation
Closed, ResolvedPublicBUG REPORT
Actions

Assigned To

Authored By

	Michael
	Apr 13 2021, 2:52 PM

Description

List of steps to reproduce (step by step, including full links if applicable):

Query for a date value consisting of only a year and a year and a month and property-value-relation "before"
e.g. https://w-beta.wmflabs.org/Hx

What happens?:

if "before" is selected then one sees results after the given date

What should have happened instead?:

one sees items with a date before the date that one entered

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Don't show dates after the given date when selecting "before"	wikidata/query-builder	master	+95 -2

Customize query in gerrit

Related Objects

Mentioned In: T272697: (MS 6) Query for date values

Event Timeline

Michael created this task.Apr 13 2021, 2:52 PM

Restricted Application added a project: Wikidata. · View Herald TranscriptApr 13 2021, 2:52 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Michael renamed this task from Year- and Month- precision date queries have before/after swapped to Year- and Month- precision date queries return wrong results for "before" relation.Apr 13 2021, 2:57 PM

Michael updated the task description. (Show Details)

Change 678865 had a related patch set uploaded (by Michael Große; author: Michael Große):

[wikidata/query-builder@master] Don't show dates after the given date when selecting "before"

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

gerritbot added a project: Patch-For-Review.Apr 13 2021, 3:02 PM

Fixed issue and moved to peer review according to the "small things" experiment. This fix consists of swapping two lines. That's it. (+added autogenerated tests)

Maintenance_bot moved this task from incoming to in progress on the Wikidata board.Apr 13 2021, 3:15 PM

Change 678865 merged by jenkins-bot:

[wikidata/query-builder@master] Don't show dates after the given date when selecting "before"

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

Maintenance_bot removed a project: Patch-For-Review.Apr 14 2021, 3:10 PM

• Tonina_Zhelyazkova_WMDE moved this task from Peer Review to Test (Verification) on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)) board.Apr 14 2021, 4:03 PM

• Sarai-WMDE mentioned this in T272697: (MS 6) Query for date values.Apr 14 2021, 4:09 PM