[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Bug 58032 depends on bug 64411, which changed state. Bug 64411 Summary: Deploy pp_sortkey schema change to all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64411 What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher changed: What|Removed |Added Status|RESOLVED|VERIFIED -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 tobias.gritschac...@wikimedia.de changed: What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED Resolution|--- |FIXED --- Comment #8 from tobias.gritschac...@wikimedia.de --- Created bug 64949 as a follow-up. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Sean Pringle changed: What|Removed |Added Depends on||64411 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #7 from Gerrit Notification Bot --- Change 122349 merged by jenkins-bot: Introducing pp_sortkey. https://gerrit.wikimedia.org/r/122349 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #6 from Gerrit Notification Bot --- Change 122349 had a related patch set uploaded by Aaron Schulz: Introducing pp_sortkey. https://gerrit.wikimedia.org/r/122349 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 tobias.gritschac...@wikimedia.de changed: What|Removed |Added Whiteboard|u=dev c=backend p=13|u=dev c=backend p=13 |s=2014-04-01|s=2014-04-23 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 tobias.gritschac...@wikimedia.de changed: What|Removed |Added CC||tobias.gritschacher@wikimed ||ia.de Whiteboard|u=dev c=backend p=13|u=dev c=backend p=13 |s=2014-03-18|s=2014-04-01 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #5 from Daniel Kinzler --- Change I217c4265 introduces the pp_sortkey field, and automatically uses it to index any property values that are int, float or bool. Pending: * a maintenance script for populating pp_sortkey (this will be sloppy, because when reading pp_value from the database, we don't know the original type - the value will always be a string). * an API module for querying pages by property value. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Gerrit Notification Bot changed: What|Removed |Added Status|ASSIGNED|PATCH_TO_REVIEW -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #4 from Gerrit Notification Bot --- Change 122349 had a related patch set uploaded by Daniel Kinzler: (bug 58032) introducing pp_sortkey. https://gerrit.wikimedia.org/r/122349 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher changed: What|Removed |Added Whiteboard|u=dev c=backend p=13|u=dev c=backend p=13 ||s=2014-03-18 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher changed: What|Removed |Added Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher changed: What|Removed |Added Whiteboard|u=dev c=backend p=0 |u=dev c=backend p=13 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher changed: What|Removed |Added Priority|Normal |High -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher changed: What|Removed |Added CC||lydia.pintscher@wikimedia.d ||e Whiteboard||u=dev c=backend p=0 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler changed: What|Removed |Added CC||daniel.kinz...@wikimedia.de --- Comment #3 from Daniel Kinzler --- After some discussion with Roan and Tim, it's seems the easiest approach is to add a new column to page_props, containing a float value to be used as a sort key. This would allow for exact matches as well as the typical "top k" queries often used on special pages. The column should be nullable so no value would be provided for page props that do not represent a quantity (such as a display title or redirect target). Querying for strings would not be possible this way, a partial index on the value blob could be used for that. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #2 from Daniel Kinzler --- We should also consider that the order of values may be relevant, not only equality. For numeric values, this would mean we'd need a padded version of the number in pp_value_id, so the alphanumeric order of the index can be used. Alternatively, we need separate columns or even tables for different types of values. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Andre Klapper changed: What|Removed |Added Priority|Unprioritized |Normal Version|unspecified |1.23-git -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler changed: What|Removed |Added Blocks||46217 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler changed: What|Removed |Added Blocks||39150 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #1 from Daniel Kinzler --- Oh, while we are messing with the table, that would probably be a good time to introduce a surrogate primary key. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler changed: What|Removed |Added Blocks||43732 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=15441 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58032] Allow page_props to be queried by value.
https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=40157 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l