Issue Bug Closed

#104548An error occurs if includeAllVersionedRecords(WorkspaceRestriction) is set to true while joining another table.

Hidefumi OKUMURA 08/05/24, 09:34 updated 12/02/25, 14:33

Description

line 104. in sysext/core/Classes/Database/Query/Restriction/WorkspaceRestriction.php
forgot $tableAlias variables?

                $constraints[] = $expressionBuilder->and(
                    $workspaceIdExpression,
                    $expressionBuilder->neq(
                        't3ver_state',
                        VersionState::DELETE_PLACEHOLDER
                    )
                );
                $constraints[] = $expressionBuilder->and(
                    $workspaceIdExpression,
                    $expressionBuilder->neq(
                        $tableAlias .'.t3ver_state',
                        VersionState::DELETE_PLACEHOLDER
                    )
                );

Reviews 2

History 37

  1. Christian Kuhn commented and changed status Under Review Resolved done 0 % 100 % <span data-processor="relativetime" data-value="2025-06-25T21:55:07+00:00" > 06/25/25, 21:55 </span>

    Applied in changeset commit:74934abfa0077e9b3a243079e606123ff4146a23.