Date: 2010-11-22 17:24:21 +0100
From: @skinkie
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]
CC: @njnes

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

Comment 15214

Date: 2010-11-22 17:24:21 +0100
From: @skinkie

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

sql>\d vve
CREATE TABLE "sys"."vve" (
"kd" INTEGER,
"naam1" VARCHAR(255),
"naam2" VARCHAR(255),
"naam3" VARCHAR(255),
"straatnaam" VARCHAR(255),
"huisnummer" INTEGER,
"toevoeging" VARCHAR(16),
"postcode" CHAR(6),
"plaats" VARCHAR(32),
"appartementen" INTEGER,
"zeter" VARCHAR(32)
);
sql>\d kvk
CREATE TABLE "sys"."kvk" (
"kvk" BIGINT,
"bedrijfsnaam" VARCHAR(256),
"kvks" INTEGER,
"sub" INTEGER,
"adres" VARCHAR(256),
"postcode" VARCHAR(10),
"plaats" VARCHAR(32),
"type" VARCHAR(14),
"website" VARCHAR(128)
);

select count(*) from vve, kvk where toevoeging is null and vve.huisnummer is not null and vve.postcode = kvk.postcode and substring(kvk.adres, length(kvk.adres)-length(huisnummer)+1) = vve.huisnummer;

mserver5: ../../../src/server/rel_bin.mx:537: exp_bin: Assertion `0' failed.

select substring('hello 10', length('hello 10')-length(10)+1) = 10;
Does work.

Reproducible: Always

MonetDB server v5.22.2 (64-bit), based on kernel v1.40.2 (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-testing3
Libraries:
libpcre: 8.02 2010-03-19 (compiled with 8.02)
openssl: OpenSSL 1.0.0a 1 Jun 2010 (compiled with OpenSSL 1.0.0a 1 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

Comment 15279

Date: 2010-12-04 23:07:24 +0100
From: @njnes

fixed (complex join expression) by adding a extra select.

Comment 15280

Date: 2010-12-05 10:30:14 +0100
From: @njnes

Changeset bd75c8aecaab 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=bd75c8aecaab

Changeset description:

fixed bug #2729 (complex expressions with different relations being used
on one of the sides of the compare expression).
We push in an extra select.

Comment 15281

Date: 2010-12-05 10:30:22 +0100
From: @njnes

Changeset ef68ce68797a 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=ef68ce68797a

Changeset description:

fixed bug #2729

Comment 15282

Date: 2010-12-05 10:43:37 +0100
From: @grobian

bah, overlooked branch. Fix was done on Oct2010, hence was present there and will be in SP-1 (?).

Comment 15641

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

The Mar2011 version has been released.