If you consider this a bug, please report ;-) Thanks! Stefan On Thu, Aug 16, 2012 at 10:46:53AM +0200, Martin Kersten wrote:

Changeset: 9e78eccb3fb3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9e78eccb3fb3 Modified Files: sql/backends/monet5/datacell/Tests/dctemper00.sql sql/backends/monet5/datacell/emitter.c sql/backends/monet5/datacell/receptor.c Branch: default Log Message:

Hack to circumvent SQL implementation issue The SQL procedural code can not properly handle the case where an attribute of a select is also part of the target table.

diffs (52 lines):

diff --git a/sql/backends/monet5/datacell/Tests/dctemper00.sql b/sql/backends/monet5/datacell/Tests/dctemper00.sql --- a/sql/backends/monet5/datacell/Tests/dctemper00.sql +++ b/sql/backends/monet5/datacell/Tests/dctemper00.sql @@ -12,7 +12,7 @@ create table datacell.temperature( tmp decimal(4,2) );

-create table datacell.warnings (msg string, ts time with time zone, location string); +create table datacell.warnings (msg string, ts time with time zone, loc string); create table datacell.templog( ts timestamp with time zone, cnt integer);

call datacell.receptor('datacell.temperature','localhost',50550); diff --git a/sql/backends/monet5/datacell/emitter.c b/sql/backends/monet5/datacell/emitter.c --- a/sql/backends/monet5/datacell/emitter.c +++ b/sql/backends/monet5/datacell/emitter.c @@ -35,7 +35,7 @@ #include "dcsocket.h" #include "stream_socket.h"

-#define _DEBUG_EMITTER_ +/* #define _DEBUG_EMITTER_ */

static Emitter emAnchor = NULL;

@@ -105,7 +105,6 @@ EMemitterStartInternal(int *ret, str *tb em->delay = delay; em->lastseen = *timestamp_nil; /* - * @- * All tables are prepended with a default tick bat. * It becomes the synchronization handle. */ diff --git a/sql/backends/monet5/datacell/receptor.c b/sql/backends/monet5/datacell/receptor.c --- a/sql/backends/monet5/datacell/receptor.c +++ b/sql/backends/monet5/datacell/receptor.c @@ -41,7 +41,7 @@ #include "stream_socket.h" #include "mal_builder.h"

-#define _DEBUG_RECEPTOR_ +/* #define _DEBUG_RECEPTOR_ */

/* default settings */ #define RCHOST "localhost" @@ -495,7 +495,6 @@ parse: #endif } /* - * @- * A short cut is to generate the events based upon the interpretation * of a scenario file. Much like the one used in the sensor. * It is processed multiple times. The header is the delay imposed. _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |