Changeset: abb0ee15aee8 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=abb0ee15aee8
Modified Files:
sql/backends/monet5/sql_scenario.c
Branch: Dec2011
Log Message:
Only convert intervals when value not null.
diffs (17 lines):
diff --git a/sql/backends/monet5/sql_scenario.c
b/sql/backends/monet5/sql_scenario.c
--- a/sql/backends/monet5/sql_scenario.c
+++ b/sql/backends/monet5/sql_scenario.c
@@ -392,10 +392,10 @@ sql_update_dec2011( Client c, mvc *m )
if (c->type.type->eclass == EC_INTERVAL
&&
strcmp(c->type.type->sqlname,
"sec_interval") == 0) {
- while (bufsize < pos + 100 +
strlen(s->base.name) + strlen(t->base.name) + 2*strlen(c->base.name))
+ while (bufsize < pos + 100 +
strlen(s->base.name) + strlen(t->base.name) + 3*strlen(c->base.name))
buf = GDKrealloc(buf,
bufsize += 1024);
- pos += snprintf(buf+pos,
bufsize-pos, "update \"%s\".\"%s\" set \"%s\"=1000*\"%s\";\n",
- s->base.name,
t->base.name, c->base.name, c->base.name);
+ pos += snprintf(buf+pos,
bufsize-pos, "update \"%s\".\"%s\" set \"%s\"=1000*\"%s\" where \"%s\" is not
null;\n",
+ s->base.name,
t->base.name, c->base.name, c->base.name, c->base.name);
}
}
}
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
