query causes "Not yet implemented" message

[monetdb-team]

Date: 2012-05-28 12:51:41 +0200
From: @sjoerdmullender
To: SQL devs <>
Version: 11.9.5 (Apr2012-SP1) [obsolete]
CC: @njnes

Last updated: 2012-06-19 11:20:32 +0200

Comment 17293

Date: 2012-05-28 12:51:41 +0200
From: @sjoerdmullender

sql>create table t (i int);
operation successful (62.572ms)
sql>create table t1 as select row_number() over () as id, i from t with data;
Not yet implemented

This is a regression: it worked in the Dec2011 branch.

$ mserver5 --version
MonetDB 5 server v11.9.5 "Apr2012-SP1" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 3.9GiB available memory, 2 available cpu cores
Libraries:
libpcre: 8.12 2011-01-15 (compiled with 8.12)
openssl: OpenSSL 1.0.0i 19 Apr 2012 (compiled with OpenSSL 1.0.0i-fips 19 Apr 2012)
libxml2: 2.7.8 (compiled with 2.7.8)
Compiled by: mockbuild@ (x86_64-unknown-linux-gnu)
Compilation: gcc -O3 -fomit-frame-pointer -pipe -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic
Linking : /usr/bin/ld -m elf_x86_64 -Wl,-z,relro

Comment 17304

Date: 2012-05-30 09:52:17 +0200
From: @sjoerdmullender

Changeset 4dfc90104ad9 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=4dfc90104ad9

Changeset description:

Added test for bug #3087.

Comment 17311

Date: 2012-05-30 15:21:49 +0200
From: @njnes

fixed by using the minimal_pipe in case of ddl statements (not the fixed 2 optimizers remap/multiplex only)

Comment 17340

Date: 2012-06-06 11:29:57 +0200
From: @njnes

Next to the proper optimization pipeline we also needed a chkProgram call, to properly initialize the types of the mal program

Comment 17342

Date: 2012-06-06 12:06:58 +0200
From: @njnes

Changeset 331edd3a8194 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=331edd3a8194

Changeset description:

fixed bug #3087, ie a chkProgram was missing