mserver5: sql_gencode.c:864: _dumpstmt: Assertion `s->nrcols' failed.

[monetdb-team]

Date: 2012-10-01 17:37:35 +0200
From: gordon <>
To: SQL devs <>
Version: 11.13.3 (Oct2012)
CC: mrunal.gawade, @njnes, @skinkie, y.kargin

Duplicates: #3198
Last updated: 2012-11-28 11:16:53 +0100

Comment 17762

Date: 2012-10-01 17:37:35 +0200
From: gordon <>

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.151 Safari/535.19
Build Identifier:

Hello,

Got this error message (in the merovingian.log):

mserver5: sql_gencode.c:864: _dumpstmt: Assertion `s->nrcols' failed.

After trying the following query using "union":

select
'total',
'a',
'b',
'c',
sum(count) as counts from bc251
union
select
track,
category,
name,
orien,
sum(count) as counts
from
bc251
group by
track,
category,
name,
orien
order by
reads desc
limit 100
;

Each of the two 'selects' without the union work fine.

Reproducible: Always

Steps to Reproduce:

1. Run the query.

Actual Results:

Server crashes with SIGABRT, mclient exits with "connection terminated".

Expected Results:

Results of the query.

Using MonetDB 5 server v11.14.0, HG changeset 45564:14983b3e103e (compiled from source).

Comment 17786

Date: 2012-10-10 13:38:19 +0200
From: @grobian

(In reply to comment 0)

Each of the two 'selects' without the union work fine.

Are you sure of this? You reference reads from order by, but don't use it in select, which causes the parser to complain here (after trying to fix column names for your set).

Comment 17787

Date: 2012-10-10 17:48:25 +0200
From: gordon <>

Hello Fabian,

(In reply to comment 1)

(In reply to comment 0)

Each of the two 'selects' without the union work fine.

Are you sure of this? You reference reads from order by, but don't use it in
select, which causes the parser to complain here (after trying to fix column
names for your set).

Yes - the bug is reproducible.
I had a typo in the bug report above,
but I sent you an email (privately) with the exact query that triggers the bug on the same table (bc251).

Comment 18015

Date: 2012-11-26 16:54:36 +0100
From: @njnes

also this one is fixed on default but still a problem on Oct2012 (seems deep in the string bat handling)
Is related or even duplicate of 3165

Comment 18157

Date: 2012-11-27 17:15:26 +0100
From: Yagiz <<y.kargin>>

We can not write a test because we cannot publish the data.

Comment 18176

Date: 2012-11-28 11:10:45 +0100
From: @njnes

*** Bug #3198 has been marked as a duplicate of this bug. ***

Comment 18178

Date: 2012-11-28 11:16:53 +0100
From: @njnes

*** This bug has been marked as a duplicate of bug #3198 ***