joomla/joomla-cms — pull request #2811 by piotr-cz (2014-01-18 10:44:23+00:00)
Title: Extensions manager doesn't show correct long extension.

The problem is that the `version` column in the `#__updates` table is has type of varchar(10).

Let's say we have installed version `1.0.0-beta` and there's `1.0.0-beta.2` available. What happens when checking for new extension updates?

1) **Extesnion manager > Update** recognizes that there's new veresion
2) `JUpdater` stores information in `#__updates` table
3) **Extension Manager > Update** shows trucated version:
```
1.0.0-beta.2
1234567890|2
```

I suggest we change the limit to 32 characters to be safe ([semver.org](http://semver.org) doesn't recommend any particular size limit).

I've updated the **Installation SQL files** and **Update SQL files**, but would be grateful if somebody would revise the syntax for postgresql and sqlazure.

Workaround:
use `1.0.0-b.2`

This is a patch for staging branch