[Wikidata-bugs] [Maniphest] [Updated] T213213: Duplicate normalized triples for values

2019-01-14 Thread Smalyshev 
Smalyshev added a project: User-Smalyshev.Smalyshev added a comment.
I've cleaned up some of the bad values (looks like may be a fallout from float precision issue) but there are still a bunch of values with duplicate normalized values (as above) - 17398 to be exact.TASK DETAILhttps://phabricator.wikimedia.org/T213213EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Addshore, thiemowmde, WMDE-leszek, Aklapper, Smalyshev, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, D3r1ck01, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T213213: Duplicate normalized triples for values

2019-01-12 Thread Smalyshev 
Smalyshev added subscribers: WMDE-leszek, thiemowmde, Addshore.Smalyshev added a comment.
This seems to be a consequence of T167759: Reference hash is not stable - a lot of duplicates can be seen in:

SELECT * WHERE { 
  ?x wikibase:quantityNormalized ?v1 .
  ?x wikibase:quantityNormalized ?v2 .
  ?v1 wikibase:quantityAmount ?q1 .
  ?v2 wikibase:quantityAmount ?q2 .
  FILTER(?v1 != ?v2) .
  FILTER(?q1 = ?q2) .
} LIMIT 200

produces a lot of values which have same amounts but different hashes. I am not sure what to do with it or why it happens.

@Addshore @WMDE-leszek @thiemowmde do you have any idea why hashes are changing again? Can we do anything about it - it produces broken data now and I don't see any way to fix it on WDQS side.TASK DETAILhttps://phabricator.wikimedia.org/T213213EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Addshore, thiemowmde, WMDE-leszek, Aklapper, Smalyshev, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, D3r1ck01, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs