[TYPO3-core] RFC #8158: Bug: EM considers 0.8.0 to be have a higher number than 1.0.0

[Martin Kutschker]

Oliver Klee schrieb:
> This is an SVN patch request.
> 
> Type: Bugfix
> 
> Bugtracker references:
> http://bugs.typo3.org/view.php?id=8158
> 
> Branches:
> TYPO3_4-1 & TYPO3_4-2
> 
> Problem:
> The extension manager considers version 0.8.0 of the ameos_formidable
> extension as newer than version 1.0.0.
> 
> Solution:
> Sort the available extension updates by version number as well. For 
> this, the version number needs to be sorted by each x.y.z part 
> separately so that 0.4.11 will sort after 0.4.10 instead of between 
> 0.4.1 and 0.4.2.

-1

The code is Mysql-only. And even if it weren't DBAL's support for SQL 
functions is so limited you cannot really make use of them.

Masi

PS: PostgreSQL has something that is better for this purpose: split_part().

Descrtipition: Split string on delimiter and return the given field 
(counting from one)
Example expression: split_part('abc~@~def~@~ghi', '~@~', 2)
Example result: def