MonetDB: default - Correctly handle count nils, and min/max nils

[Martin Kersten]

Changeset: ef6e02b149fd for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ef6e02b149fd
Modified Files:
        sql/backends/monet5/sql_statistics.c
Branch: default
Log Message:

Correctly handle count nils, and min/max nils


diffs (29 lines):

diff --git a/sql/backends/monet5/sql_statistics.c 
b/sql/backends/monet5/sql_statistics.c
--- a/sql/backends/monet5/sql_statistics.c
+++ b/sql/backends/monet5/sql_statistics.c
@@ -110,7 +110,7 @@ sql_analyze(Client cntxt, MalBlkPtr mb, 
                                        bsample = BATsample(bn, (BUN) 25000);
                                } else 
                                        bsample = bn;
-                               br = BATselect(bsample, ATOMnil(bn->ttype), 
ATOMnil(bn->ttype));
+                               br = BATselect(bsample,ATOMnil(bn->ttype),0);
                                nils = BATcount(br);
                                BBPunfix(br->batCacheid);
                                if ( bn->tkey)
@@ -130,10 +130,14 @@ sql_analyze(Client cntxt, MalBlkPtr mb, 
 {\
        TYPE *val=0;\
        val= BATmax(bn,0);\
-       snprintf(maxval,8192,FMT,*val);\
+       if ( ATOMcmp(bn->ttype,val, ATOMnil(bn->ttype))== 0)\
+               snprintf(maxval,8192,"nil");\
+       else snprintf(maxval,8192,FMT,*val);\
        GDKfree(val);\
        val= BATmin(bn,0);\
-       snprintf(minval,8192,FMT,*val);\
+       if ( ATOMcmp(bn->ttype,val, ATOMnil(bn->ttype))== 0)\
+               snprintf(minval,8192,"nil");\
+       else snprintf(minval,8192,FMT,*val);\
        GDKfree(val);\
        break;\
 }
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list