Bug #6786

Persistence Query Orderings integers ordered like strings

Added by Georg Ortner over 5 years ago. Updated almost 5 years ago.

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

100%
Category:Persistence
Target version:TYPO3 Flow Base Distribution - 1.0 alpha 8 Estimated time:2.00 hours
PHP Version: Complexity:
Has patch: Affected Flow version:

Description

Code (property order is declared as INT):

$query->matching( $query->equals('parentUUID', ''))
    ->setOrderings(array('order' => \F3\FLOW3\Persistence\QueryInterface::ORDER_ASCENDING))

The result is:

1
10
12
17
2
29
3

If order was a string this would be fine but for an integer everyone would expect:

1
2
3
10
12
17
29

Associated revisions

Revision 469a1525
Added by Karsten Dambekalns over 5 years ago

[+BUGFIX] FLOW3 (Persistence): When ordering query results the ordering now works as expected for integers, fixes #6786.

History

#1 Updated by Karsten Dambekalns over 5 years ago

  • Status changed from New to Accepted
  • Assigned To set to Karsten Dambekalns
  • Target version deleted (1.0 alpha 8)
  • Estimated time set to 4.00

#2 Updated by Karsten Dambekalns over 5 years ago

  • Target version set to 1.0 alpha 8
  • Start date changed from 2010-03-11 to 2010-03-16
  • Estimated time changed from 4.00 to 2.00

#3 Updated by Karsten Dambekalns over 5 years ago

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

Applied in changeset r3966.

Also available in: Atom PDF