Date: 2015-11-05 12:56:54 +0100
From: sebastien.raillard
To: Merovingian devs <>
Version: 11.21.11 (Jul2015-SP1)

Last updated: 2016-01-15 11:37:44 +0100

Comment 21463

Date: 2015-11-05 12:56:54 +0100
From: sebastien.raillard

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
Build Identifier:

The value -9223372036854775808 isn't correctly inserted in HUGEINT column, the result of the insertion is a "nil" value.

Steps to reproduce the issue:

CREATE TABLE "seb"."test_hugeint" (
"ID" INTEGER NOT NULL AUTO_INCREMENT,
"cHUGEINT" HUGEINT,
CONSTRAINT "pkey2" PRIMARY KEY ("ID")
);

INSERT INTO "seb"."test_hugeint" ("cHUGEINT") VALUES (-9223372036854775807); INSERT INTO "seb"."test_hugeint" ("cHUGEINT") VALUES (-9223372036854775808); INSERT INTO "seb"."test_hugeint" ("cHUGEINT") VALUES (-9223372036854775809);

And the result of SELECT * FROM "seb"."test_hugeint"; is:

+------+----------------------+
| ID | cHUGEINT |
+======+======================+
| 1 | -9223372036854775807 |
| 2 | nil |
| 3 | -9223372036854775809 |
+------+----------------------+

Reproducible: Always

Comment 21465

Date: 2015-11-05 14:35:47 +0100
From: MonetDB Mercurial Repository <>

Changeset e10b4706429d made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=e10b4706429d

Changeset description:

Test for bug #3849.

Comment 21466

Date: 2015-11-05 14:36:30 +0100
From: @sjoerdmullender

Fixed with changeset cccaf3bbbb5b