Submitted by: Vasily Vasilkov (chand0s)

1) Create the following table

CREATE TABLE BIG (
ID BIGINT NOT NULL
);
ALTER TABLE BIG ADD CONSTRAINT PK_BIG PRIMARY KEY (ID);
CREATE UNIQUE DESCENDING INDEX BIG_ID_DESC ON BIG (ID);

2) Insert 4000000000 (four billion) sequential values from 1 to 4000000000

3) Connect to this database from Linux (may be it is important, I don't know) via isql.
The Firebird version on Linux is LI-V2.1.3.18185 Firebird 2.1

4) Run the following query:

select min(id), max(id), count(*) from big;

5) Get the results
MIN MAX COUNT
===================== ===================== ============
1 4000000000 -294967296

Commits: 00c415e

====== Test Details ======

Added also check for results of aggregating (for smallint, int and bigint) and ranging analytical functions.