SELECT query with INTERSECT causes assertion failure

[monetdb-team]

Date: 2015-08-27 16:09:55 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.21.1 (Jul2015)
CC: @njnes

Last updated: 2015-11-03 10:18:10 +0100

Comment 21168

Date: 2015-08-27 16:09:55 +0200
From: Martin van Dinther <<martin.van.dinther>>

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:38.0) Gecko/20100101 Firefox/38.0
Build Identifier:

mserver5: ../../dev/gdk/gdk_bat.c:2847: BATassertHeadProps: Assertion `b->H->sorted' failed.

Reproducible: Always

Steps to Reproduce:

1. Start mserver5 (MonetDB 5 server v11.21.4)
2. download and save attached select4a.test.sql file
3. Mtest.py select4a.test

Actual Results:

bash-4.2$ Mtest.py select4a.test

Running in sql/test
15:56:44> select4a.test 0.621s ABORTED

!ERROR: Testing FAILED SIGNIFICANTLY (1 out of 1 tests failed)

 1 out of   1 tests caused an abort (assertion failure)
     sql/test/SQLite_sqllogictest/select4a.test

Output of select4a.test.err:
Statistics about stderr of test 'select4a.test in directory 'sql/test:
6 lines, 31 words, 297 chars in lines not matching '^$|^|^= = 6 lines, 31 words, 297 chars in lines not matching '^$|^
24 lines, 92 words, 923 chars in all lines

stderr of test 'select4a.test in directory 'sql/test itself:

15:56:44 >
15:56:44 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34472" "--set" "mapi_usock=/var/tmp/mtest-9212/.s.monetdb.34472" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/export/scratch1/dinther/INSTALL/var/MonetDB/mTests_sql_test" "--set" "mal_listing=0" "--set" "embedded_r=yes"
15:56:44 >

mserver5: ../../dev/gdk/gdk_bat.c:2847: BATassertHeadProps: Assertion `b->H->sorted' failed.

Aborted

15:56:44 >
15:56:44 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-9212" "--port=34472"
15:56:44 >

~ MAPI = (monetdb) /var/tmp/mtest-9212/.s.monetdb.34472
ACTION= mapi_query_done
QUERY = -- 9 values hashing to 0242ff524f6efe4a8115ad23f4d8659a
ERROR = !write error on stream

15:56:45 >
15:56:45 > "Done."
15:56:45 >

Expected Results:

No assertion failure.
The problem is somewhere in the INTERSECT part of the query as without it, it does not fail.

Comment 21169

Date: 2015-08-27 16:12:13 +0200
From: Martin van Dinther <<martin.van.dinther>>

Created attachment 347
sql test file

Attached file: select4a.test.sql (application/sql, 57662 bytes)
Description: sql test file

Comment 21173

Date: 2015-08-28 11:05:01 +0200
From: MonetDB Mercurial Repository <>

Changeset 8491714d157c 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=8491714d157c

Changeset description:

fixed bug #3798, ie properly set the bat properties in ALGgroupby

Comment 21175

Date: 2015-08-28 11:18:19 +0200
From: @njnes

intersect group by code is fixed

Comment 21436

Date: 2015-11-03 10:18:10 +0100
From: @sjoerdmullender

Jul2015 SP1 has been released.