TYPO3 Core

Patch set 2 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/16535

Patch set 1 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/16537

This error still appears in the current stable release (6.1.1) with this simple setup:

Domain model

namespace TEST\RelationQueryTest\Domain\Model;
class Element extends \TYPO3\CMS\Extbase\DomainObject\AbstractEntity {
  /**
   * @var \string
   * @validate NotEmpty
   */
  protected $title;
  /**
   * @var \TEST\RelationQueryTest\Domain\Model\Element
   */
  protected $relatedElement;
  /* getters/setters ommitted */
}

Domain repository

namespace TEST\RelationQueryTest\Domain\Repository;
class ElementRepository extends \TYPO3\CMS\Extbase\Persistence\Repository {
  /**
   * @param \string $title
   * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
   */
  public function findByRelatedElementTitle($title) {
    $query = $this->createQuery();
    return $query->matching($query->equals('relatedElement.title', $title))->execute();
  }
}

TCA configuration

$TCA['tx_relationquerytest_domain_model_element'] = array(
  /* ctrl, interface, types omitted */
  'columns' => array(
    'title' => array(
      'exclude' => 0,
      'label' => 'Title',
      'config' => array(
        'type' => 'input',
        'size' => 30,
        'eval' => 'trim,required'
      ),
    ),
    'related_element' => array(
      'exclude' => 0,
      'label' => 'Related element',
      'config' => array(
        'type' => 'inline',
        'foreign_table' => 'tx_relationquerytest_domain_model_element',
        'minitems' => 0,
        'maxitems' => 1,
        'appearance' => array(
          'collapseAll' => 0,
          'levelLinksPosition' => 'top',
          'showSynchronizationLink' => 1,
          'showPossibleLocalizationRecords' => 1,
          'showAllLocalizationLink' => 1
        ),
      ),
    ),
  ),
);

The error again:

#1247602160: Not unique table/alias: 'tx_relationquerytest_domain_model_element':
SELECT COUNT(DISTINCT tx_relationquerytest_domain_model_element.uid)
FROM tx_relationquerytest_domain_model_element
LEFT JOIN tx_relationquerytest_domain_model_element
ON tx_relationquerytest_domain_model_element.related_element=tx_relationquerytest_domain_model_element.uid
WHERE tx_relationquerytest_domain_model_element.title = 'A'
AND tx_relationquerytest_domain_model_element.deleted=0
AND tx_relationquerytest_domain_model_element.t3ver_state<=0
AND tx_relationquerytest_domain_model_element.pid<>-1
AND tx_relationquerytest_domain_model_element.hidden=0
AND tx_relationquerytest_domain_model_element.starttime<=1374245400
AND (tx_relationquerytest_domain_model_element.endtime=0
  OR tx_relationquerytest_domain_model_element.endtime>1374245400
)
AND (tx_relationquerytest_domain_model_element.sys_language_uid IN (0,-1))
AND tx_relationquerytest_domain_model_element.pid IN (7)

There is no passthrough in the TCA configuration anywhere as mentioned in the commit message. How can one fix this error?

I stumbled over the same issue and as far as I can see the patch from Alex did not resolve it.

This can be easily reproduces with a functional test (see first patch in the review system).

@Mathias: does the patch from http://review.typo3.org/33956 resolve the issue for you?

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 9 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 10 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956

Patch set 11 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/33956