Date: 2012-05-29 16:31:55 +0200
From: Simon Brodt <<simon.brodt>>
To: SQL devs <>
Version: 11.3.3 (Apr2011-SP1) [obsolete]
CC: benjie, @njnes

Last updated: 2012-07-17 13:57:42 +0200

Comment 17297

Date: 2012-05-29 16:31:55 +0200
From: Simon Brodt <<simon.brodt>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0
Build Identifier: Apr2012-SP1 (MonetDB 5 server v11.9.1 "Apr2012" Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked)

Since the Apr2012-SP1 release the query contained in lines 955-2766 of the 20120528-235447-584-monetdb.log file produces several BAT errors (see lines 2767-2786).

Reproducable: always

Remarks: Happens also after deletig the MonetDB dbfarm folder, i.e. with a fully fresh installation

Reproducible: Always

Comment 17298

Date: 2012-05-29 16:34:47 +0200
From: Simon Brodt <<simon.brodt>>

Created attachment 111
Log file produced by the jdbc driver, where the error occurs

Attached file: 20120528-235447-584-monetdb.log (text/plain, 116883 bytes)
Description: Log file produced by the jdbc driver, where the error occurs

Comment 17344

Date: 2012-06-06 13:16:37 +0200
From: @njnes

With the given log we cannot debug this problem. Is it possible to create a small example script which triggers the problem.

Comment 17351

Date: 2012-06-06 23:29:14 +0200
From: Simon Brodt <<simon.brodt>>

This does it for me:

CREATE SCHEMA "meta";

CREATE TABLE "meta"."program_specs" (
"id" INT AUTO_INCREMENT PRIMARY KEY,
"namespace" CLOB NOT NULL,
"simple_name" CLOB NOT NULL,
"description" CLOB NOT NULL DEFAULT '',
"xml_spec" CLOB NOT NULL,
CONSTRAINT "program_spec_unique_name" UNIQUE ("namespace", "simple_name")
);

INSERT INTO "meta"."program_specs"
("namespace", "simple_name", "description", "xml_spec")
VALUES
( 'example', 'access-control', '', '' )
;

Client session:
sql>CREATE SCHEMA "meta";
operation successful (2.121ms)
sql>
sql>CREATE TABLE "meta"."program_specs" (
more> "id" INT AUTO_INCREMENT PRIMARY KEY,
more> "namespace" CLOB NOT NULL,
more> "simple_name" CLOB NOT NULL,
more> "description" CLOB NOT NULL DEFAULT '',
more> "xml_spec" CLOB NOT NULL,
more> CONSTRAINT "program_spec_unique_name" UNIQUE ("namespace", "simple_name")
more>);
operation successful (5.398ms)
sql>
sql>INSERT INTO "meta"."program_specs"
more> ("namespace", "simple_name", "description", "xml_spec")
more>VALUES
more> ( 'example', 'access-control', '', '' )
more>;
TypeException:user.s1_1[59]:'bat.reverse' undefined in: _89:any := bat.reverse(_86:wrd)
TypeException:user.s1_1[60]:'algebra.join' undefined in: _90:any := algebra.join(_80:bat[:oid,:wrd], _89:any)
TypeException:user.s1_1[62]:'algebra.markT' undefined in: _93:any := algebra.markT(_90:any, _91:oid)
TypeException:user.s1_1[63]:'bat.reverse' undefined in: _94:any := bat.reverse(_93:any)
TypeException:user.s1_1[70]:'algebra.leftjoin' undefined in: _105:any := algebra.leftjoin(_94:any, _104:bat[:oid,:str])
TypeException:user.s1_1[71]:'bat.reverse' undefined in: _106:any := bat.reverse(_90:any)
TypeException:user.s1_1[73]:'algebra.markT' undefined in: _108:any := algebra.markT(_106:any, _107:oid)
TypeException:user.s1_1[74]:'bat.reverse' undefined in: _109:any := bat.reverse(_108:any)
TypeException:user.s1_1[75]:'algebra.leftjoin' undefined in: _110:any := algebra.leftjoin(_109:any, _36:str)
TypeException:user.s1_1[79]:'algebra.semijoin' undefined in: _117:any := algebra.semijoin(_94:any, _116:bat[:oid,:void])
TypeException:user.s1_1[86]:'algebra.leftjoin' undefined in: _127:any := algebra.leftjoin(_117:any, _126:bat[:oid,:str])
TypeException:user.s1_1[87]:'algebra.semijoin' undefined in: _128:any := algebra.semijoin(_109:any, _116:bat[:oid,:void])
TypeException:user.s1_1[88]:'algebra.leftjoin' undefined in: _129:any := algebra.leftjoin(_128:any, _27:str)
TypeException:user.s1_1[92]:'algebra.semijoin' undefined in: _133:any := algebra.semijoin(_117:any, _132:bat[:oid,:void])
TypeException:user.s1_1[93]:'bat.reverse' undefined in: _134:any := bat.reverse(_133:any)
TypeException:user.s1_1[94]:'algebra.semijoin' undefined in: _135:any := algebra.semijoin(_128:any, _132:bat[:oid,:void])
TypeException:user.s1_1[95]:'algebra.join' undefined in: _136:any := algebra.join(_134:any, _135:any)
TypeException:user.s1_1[96]:'aggr.count' undefined in: _137:any := aggr.count(_136:any)
39000!program contains errors
sql>

Comment 17393

Date: 2012-06-28 22:08:10 +0200
From: Benjie Chen <>

Yes. I have this problem, and it's isolated to the following.

The following all works:

create table t30(
a varchar(100),
b varchar(100),
CONSTRAINT "t30_unique" UNIQUE ("a", "b")
);
insert into t30(a,b) values('x','y');

create table t31(
a varchar(100),
b varchar(100),
c varchar(100),
CONSTRAINT "t31_unique" UNIQUE ("a", "b")
);
insert into t31(a,b) values('x','y');

create table t32(
c varchar(100),
a varchar(100),
b varchar(100),
CONSTRAINT "t32_unique" UNIQUE ("a", "b")
);
insert into t32(c,a,b) values(NULL,'x','y');

But the following DOES NOT WORK:

insert into t32(a,b) values('x','y');

error message is

TypeException:user.s2_1[45]:'bat.reverse' undefined in: _67:any := bat.reverse(_64:wrd)
TypeException:user.s2_1[46]:'algebra.join' undefined in: _68:any := algebra.join(_58:bat[:oid,:wrd], _67:any)
TypeException:user.s2_1[48]:'algebra.markT' undefined in: _71:any := algebra.markT(_68:any, _69:oid)
...

Seems like when you insert w/o specifying all values for columns before the indexed column, the failure occurs.

Help!!!

Thanks.

(In reply to comment 2)

With the given log we cannot debug this problem. Is it possible to create a
small example script which triggers the problem.

Comment 17405

Date: 2012-07-04 15:08:28 +0200
From: @njnes

Changeset 6cd986132b9e 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=6cd986132b9e

Changeset description:

fixed bug #3091. Handle single value (value lists) properly.

Comment 17406

Date: 2012-07-04 15:09:19 +0200
From: @njnes

fixed the handling of single values

Comment 17481

Date: 2012-07-17 13:57:42 +0200
From: @grobian

Fix released in Jul2012