Date: 2010-07-13 14:13:41 +0200
From: @romulogoncalves
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]
CC: @njnes

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

Comment 14377

Date: 2010-07-13 14:13:41 +0200
From: @romulogoncalves

User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-GB; rv:1.9.1.10) Gecko/20100622 Fedora/3.5.10-1.fc12 Firefox/3.5.10
Build Identifier:

The insertion into a table with 818 columns where all the columns are type char(1) crashes the mserver.

Reproducible: Always

Steps to Reproduce:

1. start mserver
2. run mclient -lsql < <attached_file.sql>

Actual Results:

mserver crashes

Expected Results:

successful insertion

(gdb)
0 0x00007fffe02d7e24 in bin_optimizer (c=0x0, s=0x0)
at /ufs/goncalve/MonetDB/current/sql/src/server/bin_optimizer.mx:247
247 {
(gdb) l
242 }
243
244
245 stmt *
246 bin_optimizer(mvc *c, stmt *s)
247 {
248 if (s->optimized >= 3) {
249 if (s->rewritten)
250 return stmt_dup(s->rewritten);
251 else
(gdb) p s
$1 = (stmt *) 0x0
(gdb) up
1 0x00007fffe02d9309 in bin_optimizer (c=0x7fffd0005468, s=0x7fffd35fea08)
at /ufs/goncalve/MonetDB/current/sql/src/server/bin_optimizer.mx:586
586 stmt *ns = bin_optimizer(c, os);
(gdb) p os
$2 = (stmt *) 0x7fffd35fe958
(gdb)

Comment 14378

Date: 2010-07-13 14:15:37 +0200
From: @romulogoncalves

Created attachment 14
The sql code re-create the bug

Attached file: bug1.sql (text/plain, 25273 bytes)
Description: The sql code re-create the bug

Comment 14845

Date: 2010-08-30 09:23:21 +0200
From: @sjoerdmullender

The Jun2010-SP2 version has been released.

Comment 15237

Date: 2010-12-01 22:45:31 +0100
From: @njnes

test added to BugTracker-2010

Comment 15238

Date: 2010-12-01 22:46:06 +0100
From: @njnes

fixed by flattening the stmt tree.

Comment 15246

Date: 2010-12-02 10:44:33 +0100
From: @njnes

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

Changeset description:

added test for bug #2609

Comment 15652

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

The Mar2011 version has been released.