Bug #81056
closedQuery Builder fails on greater / less comparisons on string fields
100%
Description
I upgraded a TYPO3 7.6.18 system to 8.7.1 and now in an extbase repository class in a custom finder method if i do this, i get results:
$query = $this->createQuery(); $result = $query ->matching( $query->like('quote', '%It was a pleasure%') ) ->execute();
Whereas if i do this, i get no results:
$query = $this->createQuery(); $result = $query ->matching( $query->greaterThan('quote', '') ) ->execute();
Even though there obviously do exist records with field "quote" being non empty as proven by the first query. With TYPO3 CMS 7.6.18 the $query->greaterThan('quote', '') comparison worked fine on the same data / system, returnin results. I guess there is internal problem in v8 with forming this query / comparison in the doctrine query builder.
Updated by Riccardo De Contardi over 7 years ago
- Related to Bug #79473: Typo3DbQueryParser fails since Doctrine by comparing date fields added
Updated by Gerrit Code Review over 7 years ago
- Status changed from New to Under Review
Patch set 10 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52802
Updated by Morton Jonuschat over 7 years ago
- Related to Bug #81487: Quoting error for date field when building query in extbase repository added
Updated by Gerrit Code Review over 7 years ago
Patch set 11 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52802
Updated by Gerrit Code Review over 7 years ago
Patch set 12 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52802
Updated by Gerrit Code Review over 7 years ago
Patch set 13 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52802
Updated by Gerrit Code Review over 7 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53244
Updated by Ian Solo over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 0bd1746384980d9f6f7387d8638d280443ee843b.