HUEGINT incorrect value
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 -- Parc d'activité Tolstoï 4 rue Edouard Aynard 69100 Villeurbanne Tél. +33 (0)4 78 95 05 80 Fax +33 (0)4 78 95 00 17 www.passman.fr www.passman-hotels.com www.passman-camping.com www.passman-sante.com https://www.facebook.com/PASSMAN-187787814053/
-----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-----
-9223372036854775808 is nil:lng, so this might be the origin of the bug ----- On Nov 5, 2015, at 12:44 PM, Sjoerd Mullender sjoerd@acm.org wrote:
-----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----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (3)
-
Sjoerd Mullender -
Stefan Manegold -
Sébastien RAILLARD (PASSMAN)