ViewsQueryAlter incorrectly maps the revision base field

Changes look at identifying the revision key and making that part of the basis for the join to the base table, currently this is id but if we have a query that references something like node types (think an alter that applies on moderation views) it causes SQL errors as it falls over where it tries to join the base table on the id field where the revision key between them would be vid.

This looks at trying to be a bit more dynamic for the column that joins.

Closes #3219073

added 1 commit

• 1c14a161 - Inner join based on entity ID, not revision ID.

Compare with previous version

added 13 commits

• 1c14a161...9753df3f - 10 commits from branch project:8.x-1.x
• 2743abd0 - Make sure conditions in Views SQL mapping with the revision key stick to the revision table.
• 799531b5 - When joining the relation key can be incorrect.
• 219a1140 - Inner join based on entity ID, not revision ID.

Compare with previous version