Project

General

Profile

Bug #79473

Updated by Josef Glatz over 7 years ago

Since the move to native Doctrine querybuilding in extbase with #77379, the comparing using calls like greaterThan,lessThan,... fail if a date field should be compared. 

 The error can easily be spotted by taking a look into the method @parseDynamicOperand@ "Github":https://github.com/TYPO3/TYPO3.CMS/blob/a522617e2a549e8165671be5a78586e885db66f4/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php#L439 

 <pre> 
 case QueryInterface::OPERATOR_LESS_THAN_OR_EQUAL_TO: 
                 $value = $this->queryBuilder->createNamedParameter($this->dataMapper->getPlainValue($value), \PDO::PARAM_INT); 
                 $expr = $exprBuilder->comparison($fieldName, $exprBuilder::LTE, $value); 
                 break; 
 </pre> 

 Using @PDO::PARAM_INT@ is wrong if in the DB an actual date or datetime type is used.

Back