The id for base table commerce_order was order_number. This affects any joins that try to relate to this table. It also causes really long queries on big tables, as a side-effect of joining with the wrong [non-indexed] column.

Simple patch fixes it after clearing Views cache.

CommentFileSizeAuthor
commerce_views-order-id.patch639 bytesfranz

Comments

rszrama’s picture

rszrama commented
Status: Needs review » Fixed

Thanks, committed!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.