Changeset: 58a115d26756 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=58a115d26756
Modified Files:
sql/backends/monet5/vaults/lidar/lidar.c
Branch: data-vaults
Log Message:
[LiDAR]: Adjust statistics table inserts after merge
diffs (32 lines):
diff --git a/sql/backends/monet5/vaults/lidar/lidar.c
b/sql/backends/monet5/vaults/lidar/lidar.c
--- a/sql/backends/monet5/vaults/lidar/lidar.c
+++ b/sql/backends/monet5/vaults/lidar/lidar.c
@@ -1252,7 +1252,8 @@ LIDARattach(Client cntxt, MalBlkPtr mb,
snprintf(minval, BUFSIZ, "%lf", header->hi->minX);
snprintf(maxval, BUFSIZ, "%lf", header->hi->maxX);
snprintf(col_type, BUFSIZ, "%s(%u,%u)",
col->type.type->sqlname, col->type.digits, col->type.scale);
- snprintf(cstmt, 8192, "insert into sys.statistics
values(%d,'%s',%d,now()," LLFMT "," LLFMT "," LLFMT "," LLFMT
",'%s','%s',%s);", col->base.id, col_type, precisionX, sz, sz, uniq, nils,
minval, maxval, (header->hi->minX == header->hi->maxX) ? "true" : "false");
+ snprintf(cstmt, 8192, "insert into sys.statistics
values(%d,'%s',%d,now()," LLFMT "," LLFMT "," LLFMT "," LLFMT
",'%s','%s',%s,%s);", col->base.id, col_type, precisionX, sz, sz, uniq, nils,
minval, maxval, "false", "false");
+ printf("%s\n", cstmt);
msg = SQLstatementIntern(cntxt, &cstmt, "LIDARattach", TRUE,
FALSE, NULL);
if (msg) {
GDKfree(cstmt);
@@ -1265,7 +1266,7 @@ LIDARattach(Client cntxt, MalBlkPtr mb,
snprintf(minval, BUFSIZ, "%lf", header->hi->minY);
snprintf(maxval, BUFSIZ, "%lf", header->hi->maxY);
snprintf(col_type, BUFSIZ, "%s(%u,%u)",
col->type.type->sqlname, col->type.digits, col->type.scale);
- snprintf(cstmt, 8192, "insert into sys.statistics
values(%d,'%s',%d,now()," LLFMT "," LLFMT "," LLFMT "," LLFMT
",'%s','%s',%s);", col->base.id, col_type, precisionX, sz, sz, uniq, nils,
minval, maxval, (header->hi->minY == header->hi->maxY) ? "true" : "false");
+ snprintf(cstmt, 8192, "insert into sys.statistics
values(%d,'%s',%d,now()," LLFMT "," LLFMT "," LLFMT "," LLFMT
",'%s','%s',%s,%s);", col->base.id, col_type, precisionY, sz, sz, uniq, nils,
minval, maxval, "false", "false");
msg = SQLstatementIntern(cntxt, &cstmt, "LIDARattach", TRUE,
FALSE, NULL);
if (msg) {
GDKfree(cstmt);
@@ -1277,8 +1278,7 @@ LIDARattach(Client cntxt, MalBlkPtr mb,
snprintf(minval, BUFSIZ, "%lf", header->hi->minZ);
snprintf(maxval, BUFSIZ, "%lf", header->hi->maxZ);
snprintf(col_type, BUFSIZ, "%s(%u,%u)",
col->type.type->sqlname, col->type.digits, col->type.scale);
-
- snprintf(cstmt, 8192, "insert into sys.statistics
values(%d,'%s',%d,now()," LLFMT "," LLFMT "," LLFMT "," LLFMT
",'%s','%s',%s);", col->base.id, col_type, precisionX, sz, sz, uniq, nils,
minval, maxval, (header->hi->minZ == header->hi->maxZ) ? "true" : "false");
+ snprintf(cstmt, 8192, "insert into sys.statistics
values(%d,'%s',%d,now()," LLFMT "," LLFMT "," LLFMT "," LLFMT
",'%s','%s',%s,%s);", col->base.id, col_type, precisionZ, sz, sz, uniq, nils,
minval, maxval, "false", "false");
msg = SQLstatementIntern(cntxt, &cstmt, "LIDARattach", TRUE,
FALSE, NULL);
if (msg) {
GDKfree(cstmt);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
