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