[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

[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

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Status|RESOLVED|VERIFIED

[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 gerritad...@wikimedia.org --- 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 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

[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 gerritad...@wikimedia.org --- 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:

[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|

[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 gerritad...@wikimedia.org --- 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

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Gerrit Notification Bot gerritad...@wikimedia.org changed: What|Removed |Added Status|ASSIGNED

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #5 from Daniel Kinzler daniel.kinz...@wikimedia.de --- 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

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Whiteboard|u=dev c=backend p=0 |u=dev

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Status|NEW |ASSIGNED

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Whiteboard|u=dev c=backend p=13|u=dev

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added CC|

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Priority|Normal |High --

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added CC|

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added See Also|

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added See Also|

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added Blocks||43732 --

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #1 from Daniel Kinzler daniel.kinz...@wikimedia.de --- 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

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added Blocks||39150 --

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added Blocks||46217 --

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|Unprioritized |Normal

[Bug 58032] Allow page_props to be queried by value.

https://bugzilla.wikimedia.org/show_bug.cgi?id=58032 --- Comment #2 from Daniel Kinzler daniel.kinz...@wikimedia.de --- 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,