Changeset: afba977b9ff0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/afba977b9ff0
Modified Files:
sql/backends/monet5/bin_partition_by_slice.c
sql/storage/bat/bat_storage.c
Branch: default
Log Message:
small changes for cardinality estimation.
diffs (24 lines):
diff --git a/sql/backends/monet5/bin_partition_by_slice.c
b/sql/backends/monet5/bin_partition_by_slice.c
--- a/sql/backends/monet5/bin_partition_by_slice.c
+++ b/sql/backends/monet5/bin_partition_by_slice.c
@@ -859,7 +859,7 @@ rel_groupby_partition(mvc *sql, sql_rel
card = (lng) (card * ncard * corr_weight); /* TODO
check for overflow */
corr_weight *= 0.85;
if (card > estimate || ncard >= estimate) {
- card = estimate;
+ card = (lng) (estimate * 0.85);
break;
}
}
diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c
--- a/sql/storage/bat/bat_storage.c
+++ b/sql/storage/bat/bat_storage.c
@@ -3033,7 +3033,7 @@ col_stats(sql_trans *tr, sql_column *c,
*nonil = bi.nonil && !bi.nil;
if ((EC_NUMBER(eclass) || EC_VARCHAR(eclass) ||
EC_TEMP_NOFRAC(eclass) || eclass == EC_DATE) &&
- d->cs.ucnt == 0 && (bi.minpos != BUN_NONE ||
bi.maxpos != BUN_NONE)) {
+ d->cs.ucnt == 0) {
if (c->min && VALinit(NULL, min, bi.type,
c->min))
ok |= 1;
else if (bi.minpos != BUN_NONE && VALinit(NULL,
min, bi.type, BUNtail(&bi, bi.minpos)))
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
