Useless when there are multiple tsvector fields for the same text field

[teohhanhui]

The first tsvector field that contains the field is used:

DoctrineFullTextPostrgres/src/ORM/Query/AST/Functions/TSFunction.php

Lines 59 to 62 in 86bca02

	if (in_array($this->ftsField->field,$annot->fields)) {
	$this->ftsField->field = $prop->name;
	break;
	}

To fix this, we have to allow the user to directly specify the tsvector field to use, instead of using the underlying field in the query.

Example:

tsquery(a.titleAndBodyFts, :searchQuery)

[jaimz22]

sorry, can you elaborate?

[teohhanhui]

Using the example in the README:

class Article
{
    /**
     * @var string
     * @Column(name="title", type="string", nullable=false)
     */
    private $title;

    /**
     * @TsVector(name="title_fts", fields={"title"})
     */
    private $titleFTS;

    /**
     * @var string
     * @Column(name="body", type="text", nullable=true)
     */
    private $body;

    /**
     * @TsVector(name="body_fts", fields={"body"})
     */
    private $bodyFTS;

    /**
     * @TsVector(name="title_and_body_fts", fields={"title", "body"})
     */
    private $titleAndBodyFTS;
}

We can never do the query against title_and_body_fts with the current design.

tsquery(a.title, :searchQuery) would use title_fts, and tsquery(a.body, :searchQuery) would use body_fts.

[teohhanhui]

I propose removing the text field -> tsvector field rewriting magic in the query.