Task #8299

Clean up handling of NULL in queries

Added by Karsten Dambekalns about 5 years ago. Updated almost 5 years ago.

Status:Resolved Start date:2010-06-16
Priority:Should have Due date:
Assigned To:Karsten Dambekalns % Done:

100%

Category:Persistence
Target version:TYPO3 Flow Base Distribution - 1.0 alpha 10 Estimated time:4.00 hours
Sprint: Has patch:
PHP Version: Complexity:

Description

  • When using equals() comparison against NULL should work as expected.
  • For collections we need isEmpty().
  • contains() with a NULL operand should never match.

Related issues

related to TYPO3.Flow - Task #6520: Differentiate between NULL and empty array/SplObjectStorage Resolved 2010-06-18

Associated revisions

Revision 4499b4ba
Added by Karsten Dambekalns about 5 years ago

[~TASK] FLOW3 (Persistence): When persisting NULL values are now recorded and collection (array, SplObjectStorage) properties are restored as NULL if they contained NULL, resolves #6520.
[~TASK] FLOW3 (Persistence): Equality comparison in a query now works correctly when comparing against NULL, relates to #8299.
[+API] FLOW3 (Persistence): Query::isEmpty() has been added and can check for empty collection properties, relates to #8299.
[~TASK] FLOW3 (Persistence): The like() constraint now can be used case-insensitive (like equals); constraints do stricter checks on property and operand types.

Revision 741b038d
Added by Karsten Dambekalns about 5 years ago

[~TASK] FLOW3 (Persistence): When persisting NULL values are now recorded and collection (array, SplObjectStorage) properties are restored as NULL if they contained NULL, resolves #6520.
[~TASK] FLOW3 (Persistence): Equality comparison in a query now works correctly when comparing against NULL, relates to #8299.
[+API] FLOW3 (Persistence): Query::isEmpty() has been added and can check for empty collection properties, relates to #8299.
[~TASK] FLOW3 (Persistence): The like() constraint now can be used case-insensitive (like equals); constraints do stricter checks on property and operand types.

History

#1 Updated by Karsten Dambekalns about 5 years ago

  • Status changed from Accepted to Resolved
  • % Done changed from 0 to 100

Also available in: Atom PDF