MonetDB: default - Count active rows only

[Pedro Ferreira]

Changeset: 6f1b2a03dad5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6f1b2a03dad5
Modified Files:
        sql/server/rel_optimizer.c
Branch: default
Log Message:

Count active rows only


diffs (12 lines):

diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -89,7 +89,7 @@ merge_table_prune_and_unionize(visitor *
                        return sql_error(v->sql, 02, SQLSTATE(42000) "The %s 
'%s.%s' should have at least one table associated",
                                                         
TABLE_TYPE_DESCRIPTION(pt->type, pt->properties), pt->s->base.name, 
pt->base.name);
                /* Do not include empty partitions */
-               if (isTable(pt) && pt->access == TABLE_READONLY && 
!store->storage_api.count_col(v->sql->session->tr, 
ol_first_node(pt->columns)->data, 0))
+               if (isTable(pt) && pt->access == TABLE_READONLY && 
!store->storage_api.count_col(v->sql->session->tr, 
ol_first_node(pt->columns)->data, 10)) /* count active rows only */
                        continue;
 
                if (!table_privs(v->sql, pt, PRIV_SELECT)) /* Test for 
privileges */
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org