This approach consists in treating each keys from the default group (the
one for sort on and select dict) as a left join if the key supports it, at
column mapping level.

Also update testERP5Catalog, the specification changed a bit.
Before, using a related key in select_dict had the side effect of not selecting
documents without related documents unless the key is explicitly passed in
select_dict. Now all documents are always returned.

MovementHistoryListBrain links must be pointing to the explanation of the
movement.

92aa42c378783603e90f7ff27208034bdfe5a5e5 reintroduced the random failure. This
restores the same workaround using the 3 item sort syntax

It should prevent a random failure

This way mysql will probably merge this with other constraints on
stock.portal_type when portal_type= is passed.

We were joining catalog for section, node and resource, mainly in order to
expose _title and _relative_url in brains. We just need to select the
corresponding uids and let brains do another catalog search to get the object
when accessed.
Note that erp5_banking_core is not updated

Change the person_view / career_view if ERP5 HR is installed so that a person's career only defines the relation to a position.
Display in position history the list of related person's careers.
Be able to assign a person to a position (in an assignment) like it is possible for a project.

Fix improper form's setting.

Revert "make whole cell in listbox clickable.", because it makes quite difficult to select a text (but still possible...).

This reverts commit ad1b0d2d.

proxy role is required in SQLCatalog_deferFullTextIndexActivity not in SQLCatalog_deferFullTextIndex.

it should be used to get SearchableText that should be static.