Date: 2010-08-15 14:46:01 +0200
From: @skinkie
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]
CC: @romulogoncalves

Last updated: 2012-11-27 16:31:11 +0100

Comment 14683

Date: 2010-08-15 14:46:01 +0200
From: @skinkie

User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.55 Safari/533.4
Build Identifier:

mserver5: ../../../src/server/rel_select.mx:712: rel_project_add_exp: Assertion `(rel->op == op_project || rel->op == op_groupby || (rel->op == op_union || rel-

op == op_inter || rel->op == op_except))' failed.

After:
update kvk set website = (select distinct website from kvk_extra_nieuw WHERE kvk.kvk = kvk_extra_nieuw.kvk and kvk_extra_nieuw.website is not null);

CREATE TABLE "sys"."kvk" (
"id" INTEGER NOT NULL DEFAULT next value for "sys"."seq_5700",
"kvk" BIGINT,
"bedrijfsnaam" VARCHAR(256),
"adres" VARCHAR(256),
"postcode" VARCHAR(10),
"plaats" VARCHAR(32),
"type" VARCHAR(14),
"kvks" INTEGER,
"sub" INTEGER,
"bedrijfsnaam_size" SMALLINT,
"adres_size" SMALLINT,
"website" VARCHAR(255),
CONSTRAINT "kvk_id_pkey" PRIMARY KEY ("id")
);

CREATE TABLE "sys"."kvk_extra_nieuw" (
"kvk" BIGINT,
"bedrijfsnaam" VARCHAR(256),
"straat" VARCHAR(256),
"nummer" INTEGER,
"toevoeging" VARCHAR(16),
"postcode" VARCHAR(10),
"plaats" VARCHAR(32),
"website" VARCHAR(128),
"type" VARCHAR(14),
"status" VARCHAR(64),
"kvks" INTEGER,
"sub" INTEGER
);

Reproducible: Always

MonetDB server v5.21.0 (64-bit), based on kernel v1.39.0 (64-bit oids)
Not released
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved
Visit http://monetdb.cwi.nl/ for further information
Found 3.9GiB available memory, 2 available cpu cores
Configured for prefix: /opt/monetdb-testing
Libraries:
libpcre: 8.02 2010-03-19 (compiled with 8.02)
openssl: OpenSSL 0.9.8o 01 Jun 2010 (compiled with OpenSSL 0.9.8o 01 Jun 2010)
libxml2: 2.7.7 (compiled with 2.7.7)
Compiled by: skinkie@openkvk (x86_64-unknown-linux-gnu)
Compilation: gcc -Wall -Wextra -fno-strict-aliasing -g -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wp,-D_FORTIFY_SOURCE=2
Linking : /usr/x86_64-pc-linux-gnu/bin/ld -IPA -m elf_x86_64

Including: http://bugs.monetdb.org/show_bug.cgi?id=2604c7

Comment 15135

Date: 2010-10-28 13:27:55 +0200
From: @grobian

does this still happen with Oct2010?

Comment 18149

Date: 2012-11-27 16:31:11 +0100
From: @romulogoncalves

Test add in the sql module under the directory BugTracker_2012 with the name:

update_crash.Bug-2655

The stable out and err were also added.

The crash does not happen anymore and the test was extended to test the update statement. The output is correct, therefore, the bug will be closed.