Date: 2010-12-07 14:17:34 +0100
From: @grobian
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]
CC: @njnes

Last updated: 2011-03-28 17:31:29 +0200

Comment 15298

Date: 2010-12-07 14:17:34 +0100
From: @grobian

CREATE TABLE "a" (
"id" INT PRIMARY KEY
);

CREATE TABLE "b" (
"ref" BIGINT REFERENCES "a" NOT NULL
);

INSERT INTO "a" VALUES('1');

INSERT INTO "b" VALUES('1');

result:

TypeException:user.s1_1[8]:'algebra.uselect' undefined in: _15:any := algebra.uselect(_10:bat[:oid,:int], _5:lng)
TypeException:user.s1_1[10]:'algebra.kdifference' undefined in: _18:any := algebra.kdifference(_15:any, _16:bat[:oid,:int])
TypeException:user.s1_1[11]:'algebra.uselect' undefined in: _19:any := algebra.uselect(_16:bat[:oid,:int], _5:lng)
TypeException:user.s1_1[12]:'algebra.kunion' undefined in: _20:any := algebra.kunion(_18:any, _19:any)
TypeException:user.s1_1[14]:'algebra.uselect' undefined in: _23:any := algebra.uselect(_21:bat[:oid,:int], _5:lng)
TypeException:user.s1_1[15]:'algebra.kunion' undefined in: _24:any := algebra.kunion(_20:any, _23:any)
TypeException:user.s1_1[18]:'algebra.kdifference' undefined in: _27:any := algebra.kdifference(_24:any, _26:bat[:oid,:oid])
TypeException:user.s1_1[20]:'algebra.markT' undefined in: _30:any := algebra.markT(_27:any, _28:oid)
TypeException:user.s1_1[21]:'bat.reverse' undefined in: _31:any := bat.reverse(_30:any)
TypeException:user.s1_1[22]:'aggr.count' undefined in: _32:any := aggr.count(_31:any)
SQLException:SQLengine:Program contains errors

Comment 15328

Date: 2010-12-10 16:07:26 +0100
From: @njnes

Changeset f8f1dd270926 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

fix for bug #2745

(added missing type checkes)

Comment 15329

Date: 2010-12-10 16:07:27 +0100
From: @njnes

Changeset 1ef7206912ed made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

added test for Bug #2745

Comment 15625

Date: 2011-03-28 17:31:29 +0200
From: @sjoerdmullender

The Mar2011 version has been released.