Commented by: @dyemanov

What should be returned:

- 2.1
- 2.1.0
- 2.1.0.14427
- WI-T2.1.0.14427 Firebird 2.1 Unstable

?

Commented by: Sean Leyne (seanleyne)

If we are talking about "RDB$EngineVersion" then I think "2.1.0" is appropriate.

If we are talking about "RDB$EngineFullVersion" then I think "WI-T2.1.0.14427 Firebird 2.1 Unstable" is appropriate. ;-)

Seriously, as long as the elements of the Version number (2.1.0) are maintained correctly, then that alone should be enough for most developers. The "full string" is a little much.

Commented by: @dyemanov

select rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database
-- returns: '2.1.0'

Commented by: Ain Valtin (ain)

I would like to see a solution which doesn't require user to parse some string. See report 1494 for (IMO) better solution. It is easy to concatenate several numbers together into complete version number, but it is much hareder to parse (in SQL!) "x.y.z" to separate numbers.

Commented by: @pmakowski

select rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database
is ok