Segfault in SQL

[monetdb-team]

Date: 2012-07-09 15:51:43 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.9.7 (Apr2012-SP2) [obsolete]
CC: @njnes

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

Comment 17434

Date: 2012-07-09 15:51:43 +0200
From: @mlkersten

In the VOC demo database, the following query (double use of IS NOT NULL) causes a segfault

SELECT hired, count(*) FROM voyages WHERE true AND hired IS NOT NULL AND hired is not null GROUP BY hired ORDER BY hired;

in 0x00007fadc5d4857e in exp_bin (sql=0x7fadb8005470, e=0x7fadb8115ea0, left=0x7fadb8118af0, right=0x0, grp=0x0, sel=0x0)
at /export/scratch1/mk/current//package/sql/server/rel_bin.c:690

Comment 17435

Date: 2012-07-09 22:55:23 +0200
From: @njnes

fixed bug in rel_push_select_down (down project)

Comment 17483

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

Fix released in Jul2012