Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.
Already on GitHub?
to your account
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-V220.127.116.1185 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
====== Test Details ======
Added also check for results of aggregating (for smallint, int and bigint) and ranging analytical functions.
The text was updated successfully, but these errors were encountered:
Fix Version: 3.0 Alpha 1 [ 10331 ]
Sorry, something went wrong.
assignee: Dmitry Yemanov [ dimitr ]
status: Open [ 1 ] => In Progress [ 3 ]
status: In Progress [ 3 ] => Open [ 1 ]
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
status: Resolved [ 5 ] => Closed [ 6 ]
status: Closed [ 6 ] => Closed [ 6 ]
QA Status: Done successfully
Test Details: Added also check for results of aggregating (for smallint, int and bigint) and ranging analytical functions.
No branches or pull requests