Changeset: 58723cf394e2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=58723cf394e2
Added Files:
        sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.sql
Modified Files:
        .hgtags
        MonetDB.spec
        NT/monetdb_config.h.in
        NT/rules.msc
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/mapilib/mapi.rc
        clients/odbc/driver/driver.rc
        clients/odbc/winsetup/setup.rc
        configure.ag
        debian/changelog
        gdk/ChangeLog-Archive
        gdk/ChangeLog.Jul2017
        gdk/gdk_batop.c
        gdk/gdk_logger.c
        gdk/libbat.rc
        libversions
        monetdb5/mal/mal_parser.c
        monetdb5/modules/atoms/str.c
        monetdb5/tools/libmonetdb5.rc
        sql/backends/monet5/sql_aggr_bte.mal
        sql/backends/monet5/sql_aggr_dbl.mal
        sql/backends/monet5/sql_aggr_flt.mal
        sql/backends/monet5/sql_aggr_hge.mal
        sql/backends/monet5/sql_aggr_int.mal
        sql/backends/monet5/sql_aggr_lng.mal
        sql/backends/monet5/sql_aggr_sht.mal
        sql/backends/monet5/sql_cat.c
        sql/backends/monet5/sql_execute.c
        sql/backends/monet5/sql_upgrades.c
        sql/benchmarks/tpch/fileleak/Tests/delete_all.stable.out
        sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out
        sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out.Windows
        sql/scripts/39_analytics.sql
        sql/scripts/39_analytics_hge.sql
        sql/server/rel_select.c
        sql/server/sql_parser.y
        sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.sql
        
sql/test/BugTracker-2012/Tests/insert_serial_with_unique_key.Bug-3091.sql
        sql/test/BugTracker-2015/Tests/schema_view.Bug-3708.sql
        sql/test/BugTracker-2016/Tests/subcorr-missing.Bug-3978.sql
        sql/test/BugTracker-2016/Tests/subcorr-missing.Bug-3978.stable.out
        sql/test/BugTracker-2017/Tests/All
        sql/test/BugTracker-2017/Tests/function_and_mergetable.Bug-6288.sql
        sql/test/Dependencies/Tests/Dependencies.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.out.int128
        sql/test/Skyserver/drop_user.sql
        sql/test/Tests/systemfunctions.stable.out
        sql/test/Tests/systemfunctions.stable.out.int128
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.32bit
        sql/test/emptydb/Tests/check.stable.out.int128
        sql/test/leaks/Tests/check1.stable.out.int128
        vertoo.data
Branch: trails
Log Message:

Merge with default


diffs (truncated from 5346 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -682,3 +682,6 @@ 1534ee14ff84fe5629becc6a5b5e2990b694d5a3
 269ab71a82190d6024b3a920837089d657893493 Jul2017_SP1_release
 fce449d5af88de715fde36624815a56ef34c56bb Jul2017_7
 fce449d5af88de715fde36624815a56ef34c56bb Jul2017_SP2_release
+3d26c58579a18157659b590899a8f73f45954ec6 Jul2017_9
+fce449d5af88de715fde36624815a56ef34c56bb Jul2017_SP2_release
+3d26c58579a18157659b590899a8f73f45954ec6 Jul2017_SP2_release
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -970,7 +970,7 @@ fi
        --enable-monetdb5=yes \
        --enable-netcdf=no \
        --enable-odbc=yes \
-       --enable-optimize=yes \
+       --enable-optimize=no \
        --enable-profile=no \
        
--enable-pyintegration=%{?with_pyintegration:yes}%{!?with_pyintegration:no} \
        
--enable-rintegration=%{?with_rintegration:yes}%{!?with_rintegration:no} \
@@ -1041,6 +1041,44 @@ done
 %postun -p /sbin/ldconfig
 
 %changelog
+* Mon Oct 23 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.9-20171023
+- Rebuilt.
+- BZ#6207: identifier ambiguous when grouping and selecting the same
+  column twice
+- BZ#6335: Sqlitelogictest crash in complex SQL query
+- BZ#6405: Compilation error if DISABLE_PARENT_HASH not defined
+- BZ#6412: Overflow in sys.epoch
+- BZ#6413: Wrong answer for TPC-H Q17
+- BZ#6414: Using RPAD returns: could not allocate space
+- BZ#6416: Sqlitelogictest crash in aggregation query with a NOT IN clause
+- BZ#6417: Segfault encountered (sqlsmith)
+- BZ#6418: Segfault in renaming (sqlsmith)
+- BZ#6419: segfault in rel_optimizer (sqlsmith)
+- BZ#6420: Assertion error in mergetable task (sqlsmith)
+- BZ#6422: Another assertion error in rel_or (sqlsmith)
+- BZ#6423: Dereference null pointer (sqlsmith)
+- BZ#6424: Assertion error in rel_rename_expr (sqlsmith)
+- BZ#6425: Assertion error in exp_bin (sqlsmith)
+- BZ#6426: Assertion error in rel_find_exp_ (sqlsmith)
+- BZ#6427: Assertion error in eq_typeswitchloop (sqlsmith)
+- BZ#6428: Sqlitelogictest crash in aggregation query
+- BZ#6430: Assertion raised in another eq_typeswitch error (sqlsmith)
+- BZ#6431: Sqlitelogictest crash in aggregation query with a long
+  having clause
+- BZ#6432: Assertion error in exp_bin (sqlsmith)
+- BZ#6433: Sqlitelogictest crash in complex SELECT query with IN operator
+- BZ#6435: Sqlitelogictest crash in simple select query
+- BZ#6437: System schemas "profiler" and "json" shouldn't be allowed to
+  be dropped.
+- BZ#6438: Implement functionality to enforce the restrict option in:
+  DROP SCHEMA xyz RESTRICT;
+- BZ#6440: Faulty plan generated. Query returns more rows than expected
+  or existing in the view sys.tables.
+
+* Mon Oct 23 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.9-20171023
+- gdk: A serious bug, possibly resulting in database corruption, having to
+  do with appending data to a string BAT was fixed.
+
 * Wed Oct 11 2017 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 
11.27.7-20171011
 - Rebuilt.
 - BZ#4017: server crashes when executing particular loopback query in
diff --git a/clients/Tests/MAL-signatures.stable.out 
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -75,24 +75,24 @@ Ready.
 [ "aggr",      "avg",  "command aggr.avg(b:bat[:sht], g:bat[:oid], 
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ",    "AGGRavg23_dbl;",       
"Grouped tail average on sht, also returns count"       ]
 [ "aggr",      "avg",  "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;",  
"Gives the avg of all tail values"      ]
 [ "aggr",      "cardinality",  "command aggr.cardinality(b:bat[:any_2]):lng ", 
"ALGcard;",     "Return the cardinality of the BAT tail values."        ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):bte;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):dbl;",  
"",     ""      ]
 [ "aggr",      "corr", "function aggr.corr(e1:bat[:dbl], e2:bat[:dbl]):dbl;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):flt;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):int;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):lng;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):sht;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):dbl;",  
"",     ""      ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any_1], g:bat[:oid], 
e:bat[:any_2], ignorenils:bit):bat[:lng] ",     "AGGRcount3;",  ""      ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any_1], g:bat[:oid], 
e:bat[:any_2]):bat[:lng] ",     "AGGRcount3nils;",      "Grouped count" ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any]):lng ", 
"ALGcount_bat;",        "Return the current size (in number of elements) in a 
BAT."     ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any], 
ignore_nils:bit):lng ",        "ALGcount_nil;",        "Return the number of 
elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff 
ignore_nils==TRUE."       ]
 [ "aggr",      "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1], 
g:bat[:oid], e:bat[:any_2]):bat[:lng] ",      "AGGRcount3nonils;",    ""      ]
 [ "aggr",      "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng 
",        "ALGcount_no_nil;",     "Return the number of elements 
currently\n\tin a BAT ignoring BUNs with nil-tail"       ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:bte], 
e2:bat[:bte]):bte;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:bte], 
e2:bat[:bte]):dbl;", "",     ""      ]
 [ "aggr",      "covar",        "function aggr.covar(e1:bat[:dbl], 
e2:bat[:dbl]):dbl;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:flt], 
e2:bat[:flt]):flt;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:int], 
e2:bat[:int]):int;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:lng], 
e2:bat[:lng]):lng;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:sht], 
e2:bat[:sht]):sht;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:flt], 
e2:bat[:flt]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:int], 
e2:bat[:int]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:lng], 
e2:bat[:lng]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:sht], 
e2:bat[:sht]):dbl;", "",     ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2], h:any_1):bit 
",      "ALGexist;",    ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2]):bit ",       
"SQLexist;",    ""      ]
 [ "aggr",      "exist",        "pattern aggr.exist(v:any_2):bit ",     
"SQLexist_val;",        ""      ]
@@ -225,20 +225,20 @@ Ready.
 [ "aggr",      "subavg",       "command aggr.subavg(b:bat[:int], g:bat[:oid], 
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], 
X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with 
candidates list, also returns count"    ]
 [ "aggr",      "subavg",       "command aggr.subavg(b:bat[:lng], g:bat[:oid], 
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], 
X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with 
candidates list, also returns count"    ]
 [ "aggr",      "subavg",       "command aggr.subavg(b:bat[:sht], g:bat[:oid], 
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], 
X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with 
candidates list, also returns count"    ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
 [ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:dbl], 
e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
 [ "aggr",      "subcount",     "command aggr.subcount(b:bat[:any_1], 
g:bat[:oid], e:bat[:any_2], skip_nils:bit):bat[:lng] ",   "AGGRsubcount;",      
  "Grouped count aggregate"       ]
 [ "aggr",      "subcount",     "command aggr.subcount(b:bat[:any_1], 
g:bat[:oid], e:bat[:any_2], s:bat[:oid], skip_nils:bit):bat[:lng] ",      
"AGGRsubcountcand;",    "Grouped count aggregate with candidates list"  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
 [ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:dbl], 
e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(val:bat[:dbl], 
g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ",        "JSONsubjson;", 
"Grouped aggregation of values."        ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(val:bat[:str], 
g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ",        "JSONsubjson;", 
"Grouped aggregation of values."        ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(val:bat[:dbl], 
g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit):bat[:str] ",   
"JSONsubjsoncand;",     "Grouped aggregation of values with candidates list."   
]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128 
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -81,26 +81,26 @@ Ready.
 [ "aggr",      "avg",  "command aggr.avg(b:bat[:sht], g:bat[:oid], 
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ",    "AGGRavg23_dbl;",       
"Grouped tail average on sht, also returns count"       ]
 [ "aggr",      "avg",  "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;",  
"Gives the avg of all tail values"      ]
 [ "aggr",      "cardinality",  "command aggr.cardinality(b:bat[:any_2]):lng ", 
"ALGcard;",     "Return the cardinality of the BAT tail values."        ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):bte;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):dbl;",  
"",     ""      ]
 [ "aggr",      "corr", "function aggr.corr(e1:bat[:dbl], e2:bat[:dbl]):dbl;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):flt;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:hge], e2:bat[:hge]):hge;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):int;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):lng;",  
"",     ""      ]
-[ "aggr",      "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):sht;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:hge], e2:bat[:hge]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):dbl;",  
"",     ""      ]
+[ "aggr",      "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):dbl;",  
"",     ""      ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any_1], g:bat[:oid], 
e:bat[:any_2], ignorenils:bit):bat[:lng] ",     "AGGRcount3;",  ""      ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any_1], g:bat[:oid], 
e:bat[:any_2]):bat[:lng] ",     "AGGRcount3nils;",      "Grouped count" ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any]):lng ", 
"ALGcount_bat;",        "Return the current size (in number of elements) in a 
BAT."     ]
 [ "aggr",      "count",        "command aggr.count(b:bat[:any], 
ignore_nils:bit):lng ",        "ALGcount_nil;",        "Return the number of 
elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff 
ignore_nils==TRUE."       ]
 [ "aggr",      "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1], 
g:bat[:oid], e:bat[:any_2]):bat[:lng] ",      "AGGRcount3nonils;",    ""      ]
 [ "aggr",      "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng 
",        "ALGcount_no_nil;",     "Return the number of elements 
currently\n\tin a BAT ignoring BUNs with nil-tail"       ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:bte], 
e2:bat[:bte]):bte;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:bte], 
e2:bat[:bte]):dbl;", "",     ""      ]
 [ "aggr",      "covar",        "function aggr.covar(e1:bat[:dbl], 
e2:bat[:dbl]):dbl;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:flt], 
e2:bat[:flt]):flt;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:hge], 
e2:bat[:hge]):hge;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:int], 
e2:bat[:int]):int;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:lng], 
e2:bat[:lng]):lng;", "",     ""      ]
-[ "aggr",      "covar",        "function aggr.covar(e1:bat[:sht], 
e2:bat[:sht]):sht;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:flt], 
e2:bat[:flt]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:hge], 
e2:bat[:hge]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:int], 
e2:bat[:int]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:lng], 
e2:bat[:lng]):dbl;", "",     ""      ]
+[ "aggr",      "covar",        "function aggr.covar(e1:bat[:sht], 
e2:bat[:sht]):dbl;", "",     ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2], h:any_1):bit 
",      "ALGexist;",    ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2]):bit ",       
"SQLexist;",    ""      ]
 [ "aggr",      "exist",        "pattern aggr.exist(v:any_2):bit ",     
"SQLexist_val;",        ""      ]
@@ -268,22 +268,22 @@ Ready.
 [ "aggr",      "subavg",       "command aggr.subavg(b:bat[:int], g:bat[:oid], 
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], 
X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with 
candidates list, also returns count"    ]
 [ "aggr",      "subavg",       "command aggr.subavg(b:bat[:lng], g:bat[:oid], 
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], 
X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with 
candidates list, also returns count"    ]
 [ "aggr",      "subavg",       "command aggr.subavg(b:bat[:sht], g:bat[:oid], 
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], 
X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with 
candidates list, also returns count"    ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
 [ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:dbl], 
e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:hge], 
e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:hge];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];",      "",     ""   
   ]
-[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:hge], 
e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
+[ "aggr",      "subcorr",      "function aggr.subcorr(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",      "",     ""   
   ]
 [ "aggr",      "subcount",     "command aggr.subcount(b:bat[:any_1], 
g:bat[:oid], e:bat[:any_2], skip_nils:bit):bat[:lng] ",   "AGGRsubcount;",      
  "Grouped count aggregate"       ]
 [ "aggr",      "subcount",     "command aggr.subcount(b:bat[:any_1], 
g:bat[:oid], e:bat[:any_2], s:bat[:oid], skip_nils:bit):bat[:lng] ",      
"AGGRsubcountcand;",    "Grouped count aggregate with candidates list"  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:bte], 
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
 [ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:dbl], 
e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:hge], 
e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:hge];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];",     "",     ""    
  ]
-[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:flt], 
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:hge], 
e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:int], 
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:lng], 
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
+[ "aggr",      "subcovar",     "function aggr.subcovar(e1:bat[:sht], 
e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];",     "",     ""    
  ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(val:bat[:dbl], 
g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ",        "JSONsubjson;", 
"Grouped aggregation of values."        ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(val:bat[:str], 
g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ",        "JSONsubjson;", 
"Grouped aggregation of values."        ]
 [ "aggr",      "subjsonaggr",  "command aggr.subjsonaggr(val:bat[:dbl], 
g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit):bat[:str] ",   
"JSONsubjsoncand;",     "Grouped aggregation of values with candidates list."   
]
diff --git a/configure.ag b/configure.ag
--- a/configure.ag
+++ b/configure.ag
@@ -326,19 +326,19 @@ AC_ARG_ENABLE([debug],
        [AS_HELP_STRING([--enable-debug],
                [enable full debugging (default=yes for development sources)])],
        [enable_debug=$enableval],
-       [enable_debug=def_$dft_debug])
+       [enable_debug=$dft_debug])
 
 AC_ARG_ENABLE([assert],
        [AS_HELP_STRING([--enable-assert],
                [enable assertions in the code (default=yes for development 
sources)])],
        [enable_assert=$enableval],
-       [enable_assert=def_$dft_assert])
+       [enable_assert=$dft_assert])
 
 AC_ARG_ENABLE([optimize],
        [AS_HELP_STRING([--enable-optimize],
                [enable extra optimization (default=no)])],
        [enable_optimize=$enableval],
-       [enable_optimize=def_$dft_optimize])
+       [enable_optimize=$dft_optimize])
 
 AC_ARG_ENABLE([strict],
        [AS_HELP_STRING([--enable-strict],
@@ -362,7 +362,7 @@ dft_profile=$need_profile
 AC_ARG_ENABLE([profile],
        [AS_HELP_STRING([--enable-profile], [enable profiling (default=no)])],
        [enable_profile=$enableval],
-       [enable_profile=def_$dft_profile])
+       [enable_profile=$dft_profile])
 
 need_instrument=no
 dft_instrument=$need_instrument
@@ -370,7 +370,7 @@ AC_ARG_ENABLE([instrument],
        [AS_HELP_STRING([--enable-instrument],
                [enable instrument (default=no)])],
        [enable_instrument=$enableval],
-       [enable_instrument=def_$dft_instrument])
+       [enable_instrument=$dft_instrument])
 
 # RIPEMD160 is patent free, academic and European, but unfortunately
 # can't use it by default, as that would exclude JDBC usage (Java
diff --git a/debian/changelog b/debian/changelog
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,47 @@
+monetdb (11.27.9) unstable; urgency=low
+
+  * Rebuilt.
+  * BZ#6207: identifier ambiguous when grouping and selecting the same
+    column twice
+  * BZ#6335: Sqlitelogictest crash in complex SQL query
+  * BZ#6405: Compilation error if DISABLE_PARENT_HASH not defined
+  * BZ#6412: Overflow in sys.epoch
+  * BZ#6413: Wrong answer for TPC-H Q17
+  * BZ#6414: Using RPAD returns: could not allocate space
+  * BZ#6416: Sqlitelogictest crash in aggregation query with a NOT IN clause
+  * BZ#6417: Segfault encountered (sqlsmith)
+  * BZ#6418: Segfault in renaming (sqlsmith)
+  * BZ#6419: segfault in rel_optimizer (sqlsmith)
+  * BZ#6420: Assertion error in mergetable task (sqlsmith)
+  * BZ#6422: Another assertion error in rel_or (sqlsmith)
+  * BZ#6423: Dereference null pointer (sqlsmith)
+  * BZ#6424: Assertion error in rel_rename_expr (sqlsmith)
+  * BZ#6425: Assertion error in exp_bin (sqlsmith)
+  * BZ#6426: Assertion error in rel_find_exp_ (sqlsmith)
+  * BZ#6427: Assertion error in eq_typeswitchloop (sqlsmith)
+  * BZ#6428: Sqlitelogictest crash in aggregation query
+  * BZ#6430: Assertion raised in another eq_typeswitch error (sqlsmith)
+  * BZ#6431: Sqlitelogictest crash in aggregation query with a long
+    having clause
+  * BZ#6432: Assertion error in exp_bin (sqlsmith)
+  * BZ#6433: Sqlitelogictest crash in complex SELECT query with IN operator
+  * BZ#6435: Sqlitelogictest crash in simple select query
+  * BZ#6437: System schemas "profiler" and "json" shouldn't be allowed to
+    be dropped.
+  * BZ#6438: Implement functionality to enforce the restrict option in:
+    DROP SCHEMA xyz RESTRICT;
+  * BZ#6440: Faulty plan generated. Query returns more rows than expected
+    or existing in the view sys.tables.
+
+ -- Sjoerd Mullender <sjo...@acm.org>  Mon, 23 Oct 2017 15:39:35 +0200
+
+monetdb (11.27.9) unstable; urgency=low
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to