-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Can you please stick this in our bugzilla (bugs.monetdb.org)? Thanks. On 05/11/15 11:54, Sébastien RAILLARD (PASSMAN) wrote:
Dear all,
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 | +------+----------------------+
Sébastien
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJWO0EUAAoJEISMxT6LrWYgDxAH/0qibia1OPKIEpAFj3oJvAgR FQ7zQSjrqDQtbfjGXHyM68V8dPjPkzIc0kYXVfhCEBXM9v/gcn1Fw9J2Vy12pBJu 4Mvrve53988CpGz1VKZtTatLU/KqdjkxUtvqexC+VMlLQR4Z9/uCmVQPi+pb3GDw huFksEVDvT9qAoOswMvmQ12aPFR1w0dVCWMN7Vs9+PIiYdobZ8UN8uk5gGSyIoWU wOyRqbW9lc7V7EkJx5nxYMPLDV1Jop1R7rS6+UTvPjFD1puR7lo56Y75nDL0gQtO YTmxfrKawDYJ1k0OKkE4fNUYHIyCIFZ2sjhpt1u5U8dmKaA9nmv1n2tQCQKbmms= =vMyT -----END PGP SIGNATURE-----