MonetDB: typing - Merged with default

2020-08-12 Thread Pedro Ferreira
Changeset: cad0445566c5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cad0445566c5
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
monetdb5/modules/atoms/mtime.c
sql/backends/monet5/sql_upgrades.c
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/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: typing
Log Message:

Merged with default


diffs (truncated from 92255 to 300 lines):

diff --git a/ChangeLog.userstats b/ChangeLog.userstats
new file mode 100644
--- /dev/null
+++ b/ChangeLog.userstats
@@ -0,0 +1,19 @@
+# ChangeLog file for userstats
+# This file is updated with Maddlog
+
+* Mon Aug 10 2020 Ying Zhang 
+- Finished a first version of the new monitoring function
+  user_statistics(), which is only intended for the DBAs.
+  For each database user who has logged in during the current mserver5
+  session, it returns 
+  "username": login name of the database user,
+  "querycount": the number of queries this user has executed since his/her
+  first login,
+  "totalticks": the total execution time (in microsecond) of the queries ran
+  by this user,
+  "maxquery": the query with the longest execution time (if two queries have
+  the same execution time, the newer overwrites the older),
+  "maxticks": the execution time of the 'maxquery' (in microsecond),
+  "started": the start timestamp of the 'maxquery',
+  "finished": the finish timestamp of the 'maxquery'.
+
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
@@ -3788,15 +3788,22 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "cmp",  "pattern batcalc.cmp(X_1:str, X_2:bat[:str]):bat[:bte] 
",   "CMDbatCMP;",   ""  ]
 [ "batcalc",   "cmp",  "pattern batcalc.cmp(X_1:str, X_2:bat[:str], 
X_3:bat[:oid]):bat[:bte] ","CMDbatCMP;",   ""  ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:date]):bat[:date] ", 
"MTIMEdate_date_bulk;", ""  ]
+[ "batcalc",   "date", "command batcalc.date(X_1:bat[:date], 
X_2:bat[:oid]):bat[:date] ",  "MTIMEdate_date_bulk_cand;",""  ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:str]):bat[:date] ",  
"MTIMEdate_fromstr_bulk;",  ""  ]
+[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str], 
X_2:bat[:oid]):bat[:date] ",   "MTIMEdate_fromstr_bulk_cand;", ""  ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:timestamp]):bat[:date] 
","MTIMEtimestamp_extract_date_bulk;",""  ]
+[ "batcalc",   "date", "command batcalc.date(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:date] ", "MTIMEtimestamp_extract_date_bulk_cand;",   "" 
 ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:str]):bat[:date] ",  
"batstr_2_date;",   ""  ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:str], 
X_2:bat[:oid]):bat[:date] ",   "batstr_2_date_cand;",  ""  ]
 [ "batcalc",   "date", "pattern batcalc.date(X_1:bat[:oid]):bat[:date] ",  
"nil_2_date;",  ""  ]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:daytime]):bat[:daytime] ",
"MTIMEdaytime_daytime_bulk;",   ""  ]
+[ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:daytime], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_daytime_bulk_cand;",  ""  
]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:lng]):bat[:daytime] ",
"MTIMEdaytime_fromseconds_bulk;",   ""  ]
+[ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:lng], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_fromseconds_bulk_cand;",  ""  
]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:str]):bat[:daytime] ",
"MTIMEdaytime_fromstr_bulk;",   ""  ]
+[ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid]):bat[:daytime] ", "MTIMEdaytime_fromstr_bulk_cand;",  ""  
]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:timestamp]):bat[:daytime] ",  
"MTIMEtimestamp_extract_daytime_bulk;", ""  ]
+[ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:timestamp], 
X_2:bat[:oid]):bat[:daytime] ",   "MTIMEtimestamp_extract_daytime_bulk_cand;",  
  ""  ]
 [ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:str], 
X_2:int):bat[:daytime] ",   "batstr_2time_daytime;",""  ]
 [ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid], X_3:int):bat[:daytime] ","batstr_2time_daytime_cand;",   
""  ]
 [ "batcalc",   "daytime",  "pattern 

MonetDB: typing - Merged with default

2020-08-11 Thread Pedro Ferreira
Changeset: 61d27edb7f89 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=61d27edb7f89
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
sql/server/rel_select.c
Branch: typing
Log Message:

Merged with default


diffs (truncated from 6376 to 300 lines):

diff --git a/buildtools/conf/CMakeLists.txt b/buildtools/conf/CMakeLists.txt
--- a/buildtools/conf/CMakeLists.txt
+++ b/buildtools/conf/CMakeLists.txt
@@ -12,7 +12,7 @@ if(WIN32)
 license.rtf
 monetdb.ico
 website.html
-DESTINATION ${CMAKE_INSTALL_PREFIX}
+DESTINATION ${CMAKE_INSTALL_DATADIR}
 COMPONENT server)
 endif()
 
diff --git a/clients/NT/CMakeLists.txt b/clients/NT/CMakeLists.txt
--- a/clients/NT/CMakeLists.txt
+++ b/clients/NT/CMakeLists.txt
@@ -6,11 +6,15 @@
 # Copyright 1997 - July 2008 CWI, August 2008 - 2020 MonetDB B.V.
 #]]
 
+# These files have to be installed in the root of the project. But you
+# cannot use the CMAKE_INSTALL_PREFIX variable, because the WIX
+# generator does not allow for absolute install paths. That is why we use
+# the "." as a relative path.
 if(WIN32)
   install(FILES
 mclient.bat
 msqldump.bat
-DESTINATION ${CMAKE_INSTALL_PREFIX}
+DESTINATION "."
 COMPONENT server)
 endif()
 
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
@@ -3533,7 +3533,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "bte",  "command batcalc.bte(X_1:int, X_2:bat[:sht], 
X_3:bat[:oid], X_4:int, X_5:int):bat[:bte] ",  "batsht_dec2dec_cand_bte;",  
   ""  ]
 [ "batcalc",   "bte",  "command batcalc.bte(X_1:bat[:sht], X_2:int, 
X_3:int):bat[:bte] ",  "batsht_num2dec_bte;",  ""  ]
 [ "batcalc",   "bte",  "command batcalc.bte(X_1:bat[:sht], X_2:bat[:oid], 
X_3:int, X_4:int):bat[:bte] ",   "batsht_num2dec_cand_bte;", ""  ]
-[ "batcalc",   "bte",  "command batcalc.bte(X_1:bat[:str], X_2:int, 
X_3:int):bat[:bte] ",  "batstr_2dec_bte;", ""  ]
+[ "batcalc",   "bte",  "pattern batcalc.bte(X_1:bat[:str], X_2:bat[:oid], 
X_3:int, X_4:int):bat[:bte] ",   "batstr_2dec_bte;", ""  ]
+[ "batcalc",   "bte",  "pattern batcalc.bte(X_1:bat[:str], X_2:int, 
X_3:int):bat[:bte] ",  "batstr_2dec_bte;", ""  ]
 [ "batcalc",   "bte_noerror",  "pattern 
batcalc.bte_noerror(X_1:bat[:bit]):bat[:bte] ","CMDconvert_bte;",  
""  ]
 [ "batcalc",   "bte_noerror",  "pattern batcalc.bte_noerror(X_1:bat[:bit], 
X_2:bat[:oid]):bat[:bte] ", "CMDconvert_bte;",  ""  ]
 [ "batcalc",   "bte_noerror",  "pattern 
batcalc.bte_noerror(X_1:bat[:bte]):bat[:bte] ","CMDconvert_bte;",  
""  ]
@@ -3790,16 +3791,22 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:str]):bat[:date] ",  
"MTIMEdate_fromstr_bulk;",  ""  ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:timestamp]):bat[:date] 
","MTIMEtimestamp_extract_date_bulk;",""  ]
 [ "batcalc",   "date", "command batcalc.date(X_1:bat[:str]):bat[:date] ",  
"batstr_2_date;",   ""  ]
+[ "batcalc",   "date", "command batcalc.date(X_1:bat[:str], 
X_2:bat[:oid]):bat[:date] ",   "batstr_2_date_cand;",  ""  ]
 [ "batcalc",   "date", "pattern batcalc.date(X_1:bat[:oid]):bat[:date] ",  
"nil_2_date;",  ""  ]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:daytime]):bat[:daytime] ",
"MTIMEdaytime_daytime_bulk;",   ""  ]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:lng]):bat[:daytime] ",
"MTIMEdaytime_fromseconds_bulk;",   ""  ]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:str]):bat[:daytime] ",
"MTIMEdaytime_fromstr_bulk;",   ""  ]
 [ "batcalc",   "daytime",  "command 
batcalc.daytime(X_1:bat[:timestamp]):bat[:daytime] ",  
"MTIMEtimestamp_extract_daytime_bulk;", ""  ]
 [ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:str], 
X_2:int):bat[:daytime] ",   "batstr_2time_daytime;",""  ]
+[ "batcalc",   "daytime",  "command batcalc.daytime(X_1:bat[:str], 
X_2:bat[:oid], X_3:int):bat[:daytime] ","batstr_2time_daytime_cand;",   
""  ]
+[ "batcalc",   "daytime",  "pattern batcalc.daytime(X_1:bat[:daytime], 
X_2:bat[:oid], X_3:int):bat[:daytime] ","daytime_2time_daytime;",   ""  
]
 [ "batcalc",   "daytime",  "pattern batcalc.daytime(X_1:bat[:daytime], 
X_2:int):bat[:daytime] ",   "daytime_2time_daytime;",   ""  ]
 [ "batcalc",   "daytime",  "pattern batcalc.daytime(X_1:bat[:oid], 
X_2:int):bat[:daytime] ",   "nil_2time_daytime;",   ""  ]
+[ "batcalc",   "daytime",  "pattern batcalc.daytime(X_1:bat[:lng], 
X_2:bat[:oid], X_3:int):bat[:daytime] ",

MonetDB: typing - Merged with default

2020-08-07 Thread Pedro Ferreira
Changeset: eb57d68c6e9b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eb57d68c6e9b
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
sql/common/sql_types.c
sql/server/rel_select.c
sql/test/miscellaneous/Tests/simple_selects.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: typing
Log Message:

Merged with default


diffs (truncated from 10763 to 300 lines):

diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -111,7 +111,7 @@ BuildRequires: checkpolicy
 BuildRequires: selinux-policy-devel
 BuildRequires: hardlink
 %endif
-BuildRequires: cmake >= 3.12
+BuildRequires: cmake3 >= 3.12
 BuildRequires: gcc
 BuildRequires: bison
 BuildRequires: /usr/bin/python3
@@ -605,7 +605,7 @@ use SQL with MonetDB, you will need to i
 %config(noreplace) %attr(664,monetdb,monetdb) 
%{_localstatedir}/monetdb5/dbfarm/.merovingian_properties
 %verify(not mtime) %attr(664,monetdb,monetdb) 
%{_localstatedir}/monetdb5/dbfarm/.merovingian_lock
 %config(noreplace) %attr(644,root,root) %{_sysconfdir}/logrotate.d/monetdbd
-%{_libdir}/monetdb5/lib_sql.so*
+%{_libdir}/libmonetdbsql.so*
 %doc %{_mandir}/man1/monetdb.1.gz
 %doc %{_mandir}/man1/monetdbd.1.gz
 %dir %{_datadir}/doc/MonetDB-SQL
@@ -762,7 +762,7 @@ fi
 %setup -q
 
 %build
-%{cmake} \
+%cmake3 \
-DASSERT=OFF \
-DCINTEGRATION=%{?with_cintegration:ON}%{!?with_cintegration:OFF} \
-DFITS=%{?with_fits:ON}%{!?with_fits:OFF} \
@@ -791,7 +791,7 @@ fi
-DWITH_XML2=ON \
-DWITH_ZLIB=ON
 
-%cmake_build
+%cmake3_build
 
 %if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} >= 7
 cd buildtools/selinux
@@ -810,7 +810,7 @@ cd -
 %endif
 
 %install
-%cmake_install
+%cmake3_install
 
 # move file to correct location
 %if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} >= 7
diff --git a/NT/mksqlwxs.py b/NT/mksqlwxs.py
--- a/NT/mksqlwxs.py
+++ b/NT/mksqlwxs.py
@@ -124,9 +124,10 @@ def main():
   [r'bin\mclient.exe',
r'bin\mserver5.exe',
r'bin\msqldump.exe',
-   r'bin\gdk.dll',
+   r'bin\bat.dll',
r'bin\mapi.dll',
r'bin\monetdb5.dll',
+   r'bin\monetdbsql.dll',
r'bin\stream.dll',
vcpkg.format(r'bin\libiconv.dll'),
vcpkg.format(r'bin\bz2.dll'),
@@ -166,18 +167,19 @@ def main():
 id = comp(features, id, 16,
   [r'lib\monetdb5\microbenchmark.mal'])
 id = comp(features, id, 16,
-  [r'lib\monetdb5\{}'.format(x) for x in sorted(filter(lambda x: 
x.startswith('lib_') and x.endswith('.dll') and ('geom' not in x) and ('pyapi' 
not in x) and ('opt_sql_append' not in x), os.listdir(os.path.join(sys.argv[3], 
'lib', 'monetdb5'])
+  [r'lib\monetdb5\{}'.format(x) for x in sorted(filter(lambda x: 
x.startswith('_') and x.endswith('.dll') and ('geom' not in x) and ('pyapi' not 
in x) and ('opt_sql_append' not in x), os.listdir(os.path.join(sys.argv[3], 
'lib', 'monetdb5'])
 id = comp(debug, id, 16,
-  [r'lib\monetdb5\{}'.format(x) for x in sorted(filter(lambda x: 
x.startswith('lib_') and x.endswith('.pdb') and ('geom' not in x) and 
('opt_sql_append' not in x), os.listdir(os.path.join(sys.argv[3], 'lib', 
'monetdb5'])
+  [r'lib\monetdb5\{}'.format(x) for x in sorted(filter(lambda x: 
x.startswith('_') and x.endswith('.pdb') and ('geom' not in x) and 
('opt_sql_append' not in x), os.listdir(os.path.join(sys.argv[3], 'lib', 
'monetdb5'])
 id = comp(geom, id, 16,
-  [r'lib\monetdb5\{}'.format(x) for x in sorted(filter(lambda x: 
x.startswith('lib_') and (x.endswith('.dll') or x.endswith('.pdb')) and ('geom' 
in x), os.listdir(os.path.join(sys.argv[3], 'lib', 'monetdb5'])
+  [r'lib\monetdb5\{}'.format(x) for x in sorted(filter(lambda x: 
x.startswith('_') and (x.endswith('.dll') or x.endswith('.pdb')) and ('geom' in 
x), os.listdir(os.path.join(sys.argv[3], 'lib', 'monetdb5'])
 id = comp(pyapi3, id, 16,
   [r'lib\monetdb5\_pyapi3.dll'])
 print(r'  ')
 id = comp(extend, id, 14,
-  [r'lib\gdk.lib',
+  [r'lib\bat.lib',
r'lib\mapi.lib',
r'lib\monetdb5.lib',
+   r'lib\monetdbsql.lib',
r'lib\stream.lib',
vcpkg.format(r'lib\libiconv.lib'),
vcpkg.format(r'lib\bz2.lib'),
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
@@ -757,14 +757,30 @@ stdout of test 'MAL-signatures` in direc
 [ "bataggr",   "not_exist","pattern bataggr.not_exist(X_1:any_1):bat[:bit] 
",  

MonetDB: typing - Merged with default

2020-08-04 Thread Pedro Ferreira
Changeset: c7a44fe49243 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c7a44fe49243
Modified Files:
sql/server/rel_select.c
sql/server/rel_unnest.c
Branch: typing
Log Message:

Merged with default


diffs (truncated from 3218 to 300 lines):

diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -547,7 +547,6 @@ used from the MAL level.
 
 %files -n MonetDB5-server-devel
 %defattr(-,root,root)
-%dir %{_includedir}/monetdb
 %{_includedir}/monetdb/mal*.h
 %{_libdir}/libmonetdb5.so
 %{_libdir}/pkgconfig/monetdb5.pc
@@ -632,6 +631,8 @@ library.  Also see %{name}-embedded-deve
 %package embedded-devel
 Summary: MonetDB as an embedded library development files
 Group: Applications/Databases
+Requires: %{name}-embedded%{?_isa} = %{version}-%{release}
+Requires: %{name}-devel%{?_isa} = %{version}-%{release}
 
 %description embedded-devel
 MonetDB is a database management system that is developed from a
@@ -639,12 +640,14 @@ main-memory perspective with use of a fu
 automatic index management, extensibility of data types and search
 accelerators.  It also has an SQL front end.
 
-This package contains the library and include files to turn MonetDB
-into an embeddable library.
+This package contains the library and include files to create a
+program that uses MonetDB as an embeddable library.
 
 %files embedded-devel
+%defattr(-,root,root)
 %{_libdir}/libmonetdbe.so
 %{_includedir}/monetdb/monetdbe.h
+%{_libdir}/pkgconfig/monetdbe.pc
 
 %package testing
 Summary: MonetDB - Monet Database Management System
@@ -821,7 +824,6 @@ rmdir %{buildroot}%{_sysconfdir}/tmpfile
 
 install -d -m 0750 %{buildroot}%{_localstatedir}/lib/monetdb
 install -d -m 0770 %{buildroot}%{_localstatedir}/monetdb5/dbfarm
-touch %{buildroot}%{_localstatedir}/monetdb5/dbfarm/.merovingian_lock
 install -d -m 0775 %{buildroot}%{_localstatedir}/log/monetdb
 install -d -m 0775 %{buildroot}%{_rundir}/monetdb
 
diff --git a/ctest/tools/monetdbe/test_helper.h 
b/ctest/tools/monetdbe/test_helper.h
--- a/ctest/tools/monetdbe/test_helper.h
+++ b/ctest/tools/monetdbe/test_helper.h
@@ -36,22 +36,22 @@ TYPE_DEFTEST_TPE(timestamp, monetdbe_dat
 
 #define Null  ._is_null = 1
 
-monetdbe_export bool check_column_bool  (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int8_t) 
expected_column[]);
-monetdbe_export bool check_column_int8_t(monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int8_t)* 
expected_column);
-monetdbe_export bool check_column_int16_t   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int16_t)* 
expected_column);
-monetdbe_export bool check_column_int32_t   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int32_t)* 
expected_column);
-monetdbe_export bool check_column_int64_t   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int64_t)* 
expected_column);
+extern bool check_column_bool  (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int8_t) 
expected_column[]);
+extern bool check_column_int8_t(monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int8_t)* 
expected_column);
+extern bool check_column_int16_t   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int16_t)* 
expected_column);
+extern bool check_column_int32_t   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int32_t)* 
expected_column);
+extern bool check_column_int64_t   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int64_t)* 
expected_column);
 #if HAVE_HGE
-monetdbe_export bool check_column_int128_t  (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int128_t)* 
expected_column);
+extern bool check_column_int128_t  (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(int128_t)* 
expected_column);
 #endif
-monetdbe_export bool check_column_size_t(monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(size_t)* 
expected_column);
-monetdbe_export bool check_column_float (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(float)* 
expected_column);
-monetdbe_export bool check_column_double(monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(double)* 
expected_column);
-monetdbe_export bool check_column_str   (monetdbe_result* result, size_t 
column_index, size_t expected_nr_column_entries, TEST_TPE_ID(str)* 
expected_column);
-monetdbe_export bool check_column_blob  (monetdbe_result* result, size_t 
column_index, size_t 

MonetDB: typing - Merged with default

2020-08-03 Thread Pedro Ferreira
Changeset: b518b991674d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b518b991674d
Modified Files:
clients/Tests/exports.stable.out
sql/common/sql_types.c
sql/server/rel_select.c
sql/server/rel_unnest.c
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/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: typing
Log Message:

Merged with default


diffs (truncated from 189398 to 300 lines):

diff --git a/.hgignore b/.hgignore
--- a/.hgignore
+++ b/.hgignore
@@ -15,32 +15,7 @@ syntax: glob
 # recommended build process plus a few patterns of files that we never
 # want in the repository (object files and such).
 
-# files generated by bootstrap
-Makefile.am
-Makefile.in
-Makefile.msc
-aclocal.m4
-acout.in
-autom4te.cache
-buildtools/conf/compile
-buildtools/conf/config.guess
-buildtools/conf/config.sub
-buildtools/conf/install-sh
-buildtools/conf/libtool.m4
-buildtools/conf/ltmain.sh
-buildtools/conf/ltoptions.m4
-buildtools/conf/ltsugar.m4
-buildtools/conf/ltversion.m4
-buildtools/conf/lt~obsolete.m4
-buildtools/conf/missing
-buildtools/conf/ylwrap
-configure
-configure.ac
-doc.lst
-install.lst
-monetdb_config.h.in
 *.pyc
-sql/backends/monet5/UDF/capi/cheader.text.h
 
 # files generated by various editors
 *.swp
@@ -73,21 +48,6 @@ tags
 *.rej
 *.orig
 
-# build results on Windows
-NT/.monetdb
-NT/buildtools
-NT/clients
-NT/common
-NT/gdk
-NT/geom
-NT/java
-NT/monetdb5
-NT/monetdb_config.h
-NT/sql
-NT/testing
-NT/tools
-NT/unistd.h
-
 # package building on Mac OS X
 MacOSX/build
 MacOSX/usr
diff --git a/misc/packages/rpm/COPYING b/COPYING
rename from misc/packages/rpm/COPYING
rename to COPYING
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -65,6 +65,9 @@
 # operators.  Otherwise the POSIX regex functions are used.
 %bcond_without pcre
 
+# By default, include C integration
+%bcond_without cintegration
+
 %if %{fedpkgs}
 # By default, create the MonetDB-R package.
 %bcond_without rintegration
@@ -108,6 +111,7 @@ BuildRequires: checkpolicy
 BuildRequires: selinux-policy-devel
 BuildRequires: hardlink
 %endif
+BuildRequires: cmake >= 3.12
 BuildRequires: gcc
 BuildRequires: bison
 BuildRequires: /usr/bin/python3
@@ -187,6 +191,7 @@ functionality of MonetDB.
 %{_includedir}/monetdb/gdk*.h
 %{_includedir}/monetdb/matomic.h
 %{_includedir}/monetdb/mstring.h
+%exclude %{_includedir}/monetdb/monetdbe.h
 %{_includedir}/monetdb/monet*.h
 %{_libdir}/libbat.so
 %{_libdir}/pkgconfig/monetdb-gdk.pc
@@ -462,7 +467,6 @@ Provides: MonetDB5-server-hugeint%{?_isa
 %endif
 %if (0%{?fedora} >= 22)
 Recommends: %{name}-SQL-server5%{?_isa} = %{version}-%{release}
-%endif
 Suggests: %{name}-client%{?_isa} = %{version}-%{release}
 %endif
 # versions up to 1.0.5 don't accept the queryid field in the result set
@@ -515,7 +519,10 @@ exit 0
 %{_libdir}/libmonetdb5.so.*
 %dir %{_libdir}/monetdb5
 %{_libdir}/monetdb5/microbenchmark.mal
+%{_libdir}/monetdb5/run_*.mal
+%if %{with cintegration}
 %{_libdir}/monetdb5/lib_capi.so
+%endif
 %{_libdir}/monetdb5/lib_generator.so
 %{_libdir}/monetdb5/lib_udf.so
 %doc %{_mandir}/man1/mserver5.1.gz
@@ -599,13 +606,46 @@ use SQL with MonetDB, you will need to i
 %config(noreplace) %attr(664,monetdb,monetdb) 
%{_localstatedir}/monetdb5/dbfarm/.merovingian_properties
 %verify(not mtime) %attr(664,monetdb,monetdb) 
%{_localstatedir}/monetdb5/dbfarm/.merovingian_lock
 %config(noreplace) %attr(644,root,root) %{_sysconfdir}/logrotate.d/monetdbd
-%{_libdir}/monetdb5/lib_sql.so
+%{_libdir}/monetdb5/lib_sql.so*
 %doc %{_mandir}/man1/monetdb.1.gz
 %doc %{_mandir}/man1/monetdbd.1.gz
 %dir %{_datadir}/doc/MonetDB-SQL
 %docdir %{_datadir}/doc/MonetDB-SQL
 %{_datadir}/doc/MonetDB-SQL/*
 
+%package embedded
+Summary: MonetDB as an embedded library
+Group: Applications/Databases
+
+%description embedded
+MonetDB is a database management system that is developed from a
+main-memory perspective with use of a fully decomposed storage model,
+automatic index management, extensibility of data types and search
+accelerators.  It also has an SQL front end.
+
+This package contains the library to turn MonetDB into an embeddable
+library.  Also see %{name}-embedded-devel to use this in a program.
+
+%files embedded
+%{_libdir}/libmonetdbe.so.*
+
+%package embedded-devel
+Summary: MonetDB as an embedded library development files
+Group: Applications/Databases
+
+%description embedded-devel
+MonetDB is a database management system that is developed from a
+main-memory perspective with use of a fully decomposed storage model,
+automatic index management, extensibility of data types and search
+accelerators.  It also has an SQL front end.
+
+This package contains the library and include files to turn MonetDB
+into an embeddable library.
+
+%files 

MonetDB: typing - Merged with default

2020-07-30 Thread Pedro Ferreira
Changeset: c8c2500abb2c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c8c2500abb2c
Modified Files:
clients/Tests/exports.stable.out
sql/common/sql_types.c
sql/server/rel_select.c
sql/server/rel_unnest.c
sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out
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/miscellaneous/Tests/simple_selects.stable.out
sql/test/pg_regress/Tests/date.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: typing
Log Message:

Merged with default


diffs (truncated from 231588 to 300 lines):

diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -55,7 +55,6 @@ include(monetdb-toolchain)
 monetdb_default_toolchain()
 #monetdb_default_compiler_options()
 
-
 include(monetdb-defines)
 monetdb_hg_revision()
 
@@ -155,6 +154,7 @@ add_subdirectory(tools)
 if(TESTING)
   add_subdirectory(testing)
 endif()
+add_subdirectory(buildtools)
 
 include(CMakePackageConfigHelpers)
 configure_package_config_file(${CMAKE_CURRENT_SOURCE_DIR}/Config.cmake.in
diff --git a/NT/mkodbcwxs.py b/NT/mkodbcwxs.py
--- a/NT/mkodbcwxs.py
+++ b/NT/mkodbcwxs.py
@@ -4,7 +4,7 @@
 #
 # Copyright 1997 - July 2008 CWI, August 2008 - 2020 MonetDB B.V.
 
-# python mkodbcwxs.py VERSION makedefs.txt PREFIX > 
PREFIX/MonetDB-ODBC-Installer.wxs
+# python mkodbcwxs.py VERSION BITS PREFIX > PREFIX/MonetDB-ODBC-Installer.wxs
 # "c:\Program Files (x86)\WiX Toolset v3.10\bin\candle.exe" -nologo -arch 
x64/x86 PREFIX/MonetDB-ODBC-Installer.wxs
 # "c:\Program Files (x86)\WiX Toolset v3.10\bin\light.exe" -nologo -sice:ICE03 
-sice:ICE60 -sice:ICE82 -ext WixUIExtension PREFIX/MonetDB-ODBC-Installer.wixobj
 
@@ -29,21 +29,19 @@ def comp(features, id, depth, files, fid
 
 def main():
 if len(sys.argv) != 4:
-print(r'Usage: mkodbcwxs.py version makedefs.txt installdir')
+print(r'Usage: mkodbcwxs.py version bits installdir')
 return 1
-makedefs = {}
-for line in open(sys.argv[2]):
-key, val = line.strip().split('=', 1)
-makedefs[key] = val
-if makedefs['bits'] == '64':
+if sys.argv[2] == '64':
 folder = r'ProgramFiles64Folder'
 arch = 'x64'
 libcrypto = '-x64'
+vcpkg = r'C:\vcpkg\installed\x64-windows\{}'
 else:
 folder = r'ProgramFilesFolder'
 arch = 'x86'
 libcrypto = ''
-vs = os.getenv('vs')# inherited from TestTools\common.bat
+vcpkg = r'C:\vcpkg\installed\x86-windows\{}'
+vs = '2019'
 features = []
 print(r'')
 print(r'http://schemas.microsoft.com/wix/2006/wi;>')
@@ -59,7 +57,7 @@ def main():
 print(r'')
 print(r'')
 print(r'')
-msvc = r'C:\Program Files (x86)\Microsoft Visual 
Studio\20{}\Community\VC\Redist\MSVC'.format(vs)
+msvc = r'C:\Program Files (x86)\Microsoft Visual 
Studio\{}\Community\VC\Redist\MSVC'.format(vs)
 d = sorted(os.listdir(msvc))[-1]
 msm = '_CRT_{}.msm'.format(arch)
 for f in sorted(os.listdir(os.path.join(msvc, d, 'MergeModules'))):
@@ -72,14 +70,14 @@ def main():
 id = 1
 print(r'')
 id = comp(features, id, 14,
-  [r'lib\libmapi.dll', r'lib\libmapi.pdb',
-   r'lib\libMonetODBC.dll', r'lib\libMonetODBC.pdb',
-   r'lib\libMonetODBCs.dll', r'lib\libMonetODBCs.pdb',
-   r'lib\libstream.dll', r'lib\libstream.pdb',
-   r'{}\bin\iconv-2.dll'.format(makedefs['LIBICONV']),
-   r'{}\bin\libbz2.dll'.format(makedefs['LIBBZIP2']),
-   r'{}\bin\libcrypto-1_1{}.dll'.format(makedefs['LIBOPENSSL'], 
libcrypto),
-   r'{}\bin\zlib1.dll'.format(makedefs['LIBZLIB'])])
+  [r'bin\mapi.dll', # r'lib\mapi.pdb',
+   r'bin\MonetODBC.dll', # r'lib\MonetODBC.pdb',
+   r'bin\MonetODBCs.dll', # r'lib\MonetODBCs.pdb',
+   r'bin\stream.dll', # r'lib\stream.pdb',
+   vcpkg.format(r'bin\libiconv.dll'),
+   vcpkg.format(r'bin\bz2.dll'),
+   vcpkg.format(r'bin\libcrypto-1_1{}.dll'.format(libcrypto)),
+   vcpkg.format(r'bin\zlib1.dll')])
 print(r'')
 id = comp(features, id, 12,
   [r'license.rtf'])
diff --git a/NT/mksqlwxs.py b/NT/mksqlwxs.py
--- a/NT/mksqlwxs.py
+++ b/NT/mksqlwxs.py
@@ -4,7 +4,7 @@
 #
 # Copyright 1997 - July 2008 CWI, August 2008 - 2020 MonetDB B.V.
 
-# python mksqlwxs.py VERSION makedefs.txt PREFIX > 
PREFIX/MonetDB5-SQL-Installer.wxs
+# python mksqlwxs.py VERSION BITS PREFIX > PREFIX/MonetDB5-SQL-Installer.wxs
 # "c:\Program Files (x86)\WiX Toolset v3.10\bin\candle.exe" -nologo -arch 
x64/x86 PREFIX/MonetDB5-SQL-Installer.wxs
 # "c:\Program 

MonetDB: typing - Merged with default

2020-07-24 Thread Pedro Ferreira
Changeset: c946327214dc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c946327214dc
Branch: typing
Log Message:

Merged with default


diffs (truncated from 2261 to 300 lines):

diff --git a/gdk/gdk_analytic_func.c b/gdk/gdk_analytic_func.c
--- a/gdk/gdk_analytic_func.c
+++ b/gdk/gdk_analytic_func.c
@@ -1677,25 +1677,19 @@ GDKanalyticalavg(BAT *r, BAT *b, BAT *s,
 #ifdef TRUNCATE_NUMBERS
 #define ANALYTICAL_AVERAGE_INT_CALC_FINALIZE(avg, rem, ncnt) \
do {
-   if (rem > 0 && avg < 0) { \
+   if (rem > 0 && avg < 0) \
avg++; \
-   rem -= ncnt; \
-   }
} while(0)
 #else
 #define ANALYTICAL_AVERAGE_INT_CALC_FINALIZE(avg, rem, ncnt) \
do { \
if (rem > 0) { \
if (avg < 0) { \
-   if (2*rem > ncnt) { \
+   if (2*rem > ncnt) \
avg++; \
-   rem -= ncnt; \
-   } \
} else { \
-   if (2*rem >= ncnt) { \
+   if (2*rem >= ncnt) \
avg++; \
-   rem -= ncnt; \
-   } \
} \
} \
} while(0)
diff --git a/sql/backends/monet5/sql_scenario.c 
b/sql/backends/monet5/sql_scenario.c
--- a/sql/backends/monet5/sql_scenario.c
+++ b/sql/backends/monet5/sql_scenario.c
@@ -1157,6 +1157,11 @@ SQLparser(Client c)
 
if (msg != MAL_SUCCEED) {
str other = c->curprg->def->errors;
+   /* In debugging mode you may want to 
assess what went wrong in the optimizers*/
+#ifndef NDEBUG
+   if( m->emod & mod_debug)
+   runMALDebugger(c, 
c->curprg->def);
+#endif
c->curprg->def->errors = 0;
MSresetInstructions(c->curprg->def, 
oldstop);
freeVariables(c, c->curprg->def, NULL, 
oldvtop);
diff --git a/sql/benchmarks/tpcds/Tests/47.stable.out 
b/sql/benchmarks/tpcds/Tests/47.stable.out
--- a/sql/benchmarks/tpcds/Tests/47.stable.out
+++ b/sql/benchmarks/tpcds/Tests/47.stable.out
@@ -37,112 +37,112 @@ stdout of test '47` in directory 'sql/be
 #  s_company_name,
 % sys.v2,  sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, 
sys.v2 # table_name
 % i_category,  i_brand,s_store_name,   s_company_name, d_year, d_moy,  
avg_monthly_sales,  sum_sales,  psum,   nsum # name
-% char,char,   varchar,varchar,int,int,double, 
decimal,decimal,decimal # type
-% 50,  50, 5,  7,  4,  1,  24, 20, 20, 20 # 
length
-[ "Men",   "importoimporto #1","ese",  "Unknown",  1999,   3,  
5492.817525,2070.65,3307.78,2784.11 ]
-[ "Music", "exportischolar #1","eing", "Unknown",  1999,   2,  
5134.238322,1740.21,4401.89,2721.61 ]
-[ "Music", "edu packscholar #1",   "ese",  "Unknown",  1999,   4,  
5463.700806,2091.07,3391.39,3095.31 ]
-[ "Music", "edu packscholar #1",   "ought","Unknown",  1999,   
7,  5552.305013,2226.34,4081.99,7573.33 ]
-[ "Music", "edu packscholar #1",   "ese",  "Unknown",  1999,   2,  
5463.700806,2268.27,4139.47,3391.39 ]
-[ "Men",   "edu packimporto #1",   "ought","Unknown",  1999,   
7,  5176.257426,1993.73,3542.54,5764.35 ]
-[ "Children",  "exportiexporti #1","ese",  "Unknown",  1999,   3,  
5185.898254,2019.69,3479.21,2982.05 ]
-[ "Shoes", "amalgedu pack #1", "ation","Unknown",  1999,   
6,  5152.095886,2077.67,3123.43,2368.73 ]
-[ "Men",   "edu packimporto #1",   "eing", "Unknown",  1999,   3,  
5501.180766,2453.88,2683.70,2615.32 ]
-[ "Children",  "exportiexporti #1","ation","Unknown",  1999,   
4,  5238.357524,2232.03,3221.70,3649.52 ]
-[ "Shoes", "importoedu pack #1",   "eing", "Unknown",  1999,   5,  
4698.612447,1703.27,2687.15,2757.83 ]
-[ "Music", "exportischolar #1","bar",  "Unknown",  1999,   7,  
5318.146708,2346.06,3483.88,7658.62 ]
-[ "Music", "edu packscholar #1",   "ation","Unknown",  1999,   
2,  5622.227458,2657.68,4207.03,3543.82 ]
-[ "Children",  "exportiexporti #1",

MonetDB: typing - Merged with default

2020-07-23 Thread Pedro Ferreira
Changeset: e76a5c0cb85f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e76a5c0cb85f
Modified Files:
clients/Tests/exports.stable.out
clients/mapiclient/dump.c
sql/common/sql_types.c
sql/server/rel_select.c
sql/server/rel_unnest.c
sql/server/sql_decimal.c
sql/server/sql_decimal.h
sql/server/sql_parser.y
sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out

sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_interval.SF.1280682.stable.err

sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_interval.SF.1280682.stable.out
sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out

sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.err

sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.out
sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.sql
sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.stable.out

sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.sql
sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.err
sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.stable.out
sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out
sql/test/bugs/Tests/interval_convert_bugs-sf-1274077-1274085.stable.out
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/pg_regress/Tests/date.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: typing
Log Message:

Merged with default


diffs (truncated from 217180 to 300 lines):

diff --git a/.editorconfig b/.editorconfig
--- a/.editorconfig
+++ b/.editorconfig
@@ -19,3 +19,4 @@ charset = utf-8
 
 [gdk/*.{c,h}]
 tab_width = 8
+max_line_length = 72
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -775,3 +775,8 @@ 28480e096722b7f76ab021c0d16c68c6949f41b4
 80bd3e89c48032840f493a63d6c4c12ee6273b3d Jun2020_7
 28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_release
 80bd3e89c48032840f493a63d6c4c12ee6273b3d Jun2020_release
+1e3bd8cd485a0880a7557aa5307e986a210a1e00 Jun2020_9
+1e3bd8cd485a0880a7557aa5307e986a210a1e00 Jun2020_SP1_release
+bb157905ecb86908dcfb112d102a8c6152557b5d Jun2020_11
+1e3bd8cd485a0880a7557aa5307e986a210a1e00 Jun2020_SP1_release
+bb157905ecb86908dcfb112d102a8c6152557b5d Jun2020_SP1_release
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -34,6 +34,7 @@ set(CMAKE_FIND_FRAMEWORK LAST)
 set(CMAKE_FIND_APPBUNDLE LAST)
 
 include(CheckCSourceCompiles REQUIRED)
+include(CheckCCompilerFlag REQUIRED)
 include(CheckIncludeFile REQUIRED)
 include(CMakePushCheckState REQUIRED)
 include(CheckStructHasMember REQUIRED)
@@ -52,6 +53,8 @@ include(monetdb-functions)
 include(monetdb-findpackages)
 include(monetdb-toolchain)
 monetdb_default_toolchain()
+#monetdb_default_compiler_options()
+
 
 include(monetdb-defines)
 monetdb_hg_revision()
@@ -106,14 +109,11 @@ set(PROGRAM_PERMISSIONS_DEFAULT
 
 find_program(BASH NAMES bash DOC "bash interpreter fullpath")
 
+configure_file(monetdb_config.h.in
+  ${CMAKE_CURRENT_BINARY_DIR}/monetdb_config.h)
 if(WIN32)
-  configure_file(monetdb_config_win32.h.in
-${CMAKE_CURRENT_BINARY_DIR}/monetdb_config.h)
   configure_file(unistd.h.in
 ${CMAKE_CURRENT_BINARY_DIR}/unistd.h)
-else()
-  configure_file(monetdb_config.h.in
-${CMAKE_CURRENT_BINARY_DIR}/monetdb_config.h)
 endif()
 
 add_library(monetdb_config_header
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -7,7 +7,7 @@
 # The --with OPTION and --without OPTION arguments can be passed on
 # the commandline of both rpmbuild and mock.
 
-# On 64 bit architectures we build "hugeint" packages.
+# On 64 bit architectures compile with 128 bit integer support.
 %if "%{?_lib}" == "lib64"
 %bcond_without hugeint
 %endif
@@ -94,7 +94,7 @@ Group: Applications/Databases
 License: MPLv2.0
 URL: https://www.monetdb.org/
 BugURL: https://bugs.monetdb.org/
-Source: 
https://www.monetdb.org/downloads/sources/Jun2020/%{name}-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Jun2020-SP1/%{name}-%{version}.tar.bz2
 
 # The Fedora packaging document says we need systemd-rpm-macros for
 # the _unitdir and _tmpfilesdir macros to exist; however on RHEL 7
@@ -379,9 +379,6 @@ extensions for %{name}-SQL-server5.
 
 %files geom-MonetDB5
 %defattr(-,root,root)
-%{_libdir}/monetdb5/autoload/*_geom.mal
-%{_libdir}/monetdb5/createdb/*_geom.sql
-%{_libdir}/monetdb5/geom.mal
 %{_libdir}/monetdb5/lib_geom.so
 %endif
 
@@ -406,8 +403,7 @@ install it.
 
 %files R
 %defattr(-,root,root)

MonetDB: typing - merged with default

2020-06-08 Thread Niels Nes
Changeset: 8194f306e8b7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8194f306e8b7
Modified Files:
cmake/monetdb-defines.cmake
monetdb5/modules/atoms/mtime.c
monetdb5/modules/mal/batmtime.mal
monetdb5/modules/mal/batmtime.mal.sh
sql/backends/monet5/sql.c
sql/backends/monet5/sql_subquery.mal
Branch: typing
Log Message:

merged with default


diffs (170 lines):

diff --git a/cmake/monetdb-defines.cmake b/cmake/monetdb-defines.cmake
--- a/cmake/monetdb-defines.cmake
+++ b/cmake/monetdb-defines.cmake
@@ -57,7 +57,7 @@ function(monetdb_configure_defines)
   check_symbol_exists("gettimeofday" "sys/time.h" HAVE_SYS_TIME_H)
   # Linux specific, in the future, it might be ported to other platforms
   check_symbol_exists("S_ISREG" "sys/stat.h" HAVE_SYS_STAT_H)
-  check_symbol_exists("getaddrinfo" "netdb.h" UNIX_GETADDRINFO)
+  check_symbol_exists("getaddrinfo" "sys/types.h;sys/socket.h;netdb.h" 
UNIX_GETADDRINFO)
   check_symbol_exists("getaddrinfo" "ws2tcpip.h" WIN_GETADDRINFO)
   #check_symbol_exists("WSADATA" "winsock2.h" HAVE_WINSOCK_H)
   check_symbol_exists("fdatasync" "unistd.h" HAVE_FDATASYNC)
@@ -113,8 +113,13 @@ function(monetdb_configure_defines)
   check_function_exists("uname" HAVE_UNAME)
   # Some libc versions on Linux distributions don't have it
   check_symbol_exists("semtimedop" "sys/types.h;sys/ipc.h;sys/sem.h" 
HAVE_SEMTIMEDOP)
-  check_function_exists("pthread_kill" HAVE_PTHREAD_KILL)
-  check_function_exists("pthread_sigmask" HAVE_PTHREAD_SIGMASK)
+  cmake_push_check_state()
+if (NOT APPLE)
+  set(CMAKE_REQUIRED_LIBRARIES "${CMAKE_REQUIRED_LIBRARIES};pthread")
+endif()
+check_symbol_exists("pthread_kill" "pthread.h;signal.h" HAVE_PTHREAD_KILL)
+check_symbol_exists("pthread_sigmask" "pthread.h;signal.h" 
HAVE_PTHREAD_SIGMASK)
+  cmake_pop_check_state()
   check_symbol_exists("regcomp" "regex.h" HAVE_POSIX_REGEX)
 endfunction()
 
diff --git a/monetdb5/modules/atoms/mtime.c b/monetdb5/modules/atoms/mtime.c
--- a/monetdb5/modules/atoms/mtime.c
+++ b/monetdb5/modules/atoms/mtime.c
@@ -884,6 +884,9 @@ static mel_func mtime_init_funcs[] = {
  command("batmtime", "time_add_msec_interval", 
MTIMEtime_add_msec_interval_bulk_p1, false, "", args(1,3, 
batarg("",daytime),arg("t",daytime),batarg("ms",lng))),
  command("batmtime", "time_add_msec_interval", 
MTIMEtime_add_msec_interval_bulk_p2, false, "", args(1,3, 
batarg("",daytime),batarg("t",daytime),arg("ms",lng))),
  command("mtime", "diff", MTIMEdaytime_diff_msec, false, "returns the number 
of msec between 'val1' and 'val2'.", args(1,3, 
arg("",lng),arg("val1",daytime),arg("val2",daytime))),
+ command("batmtime", "diff", MTIMEdaytime_diff_msec_bulk, false, "", args(1,3, 
batarg("",lng),batarg("val1",daytime),batarg("val2",daytime))),
+ command("batmtime", "diff", MTIMEdaytime_diff_msec_bulk_p1, false, "", 
args(1,3, batarg("",lng),arg("val1",daytime),batarg("val2",daytime))),
+ command("batmtime", "diff", MTIMEdaytime_diff_msec_bulk_p2, false, "", 
args(1,3, batarg("",lng),batarg("val1",daytime),arg("val2",daytime))),
  command("mtime", "date_sub_month_interval", MTIMEdate_submonths, false, 
"Subtract months from a date", args(1,3, 
arg("",date),arg("t",date),arg("months",int))),
  command("batmtime", "date_sub_month_interval", MTIMEdate_submonths_bulk, 
false, "", args(1,3, batarg("",date),batarg("t",date),batarg("months",int))),
  command("batmtime", "date_sub_month_interval", MTIMEdate_submonths_bulk_p1, 
false, "", args(1,3, batarg("",date),arg("t",date),batarg("months",int))),
@@ -912,6 +915,9 @@ static mel_func mtime_init_funcs[] = {
  command("batmtime", "addmonths", MTIMEdate_addmonths_bulk_p1, false, "", 
args(1,3, batarg("",date),arg("value",date),batarg("months",int))),
  command("batmtime", "addmonths", MTIMEdate_addmonths_bulk_p2, false, "", 
args(1,3, batarg("",date),batarg("value",date),arg("months",int))),
  command("mtime", "diff", MTIMEdate_diff, false, "returns the number of 
days\nbetween 'val1' and 'val2'.", args(1,3, 
arg("",int),arg("val1",date),arg("val2",date))),
+ command("batmtime", "diff", MTIMEdate_diff_bulk, false, "", args(1,3, 
batarg("",int),batarg("val1",date),batarg("val2",date))),
+ command("batmtime", "diff", MTIMEdate_diff_bulk_p1, false, "", args(1,3, 
batarg("",int),arg("val1",date),batarg("val2",date))),
+ command("batmtime", "diff", MTIMEdate_diff_bulk_p2, false, "", args(1,3, 
batarg("",int),batarg("val1",date),arg("val2",date))),
  command("mtime", "dayofyear", MTIMEdate_extract_dayofyear, false, "Returns N 
where d is the Nth day\nof the year (january 1 returns 1)", args(1,2, 
arg("",int),arg("d",date))),
  command("batmtime", "dayofyear", MTIMEdate_extract_dayofyear_bulk, false, "", 
args(1,2, batarg("",int),batarg("d",date))),
  command("mtime", "weekofyear", MTIMEdate_extract_weekofyear, false, "Returns 
the week number in the year.", args(1,2, arg("",int),arg("d",date))),
@@ -919,6 +925,9 @@ static mel_func 

MonetDB: typing - merged with default

2020-06-08 Thread Niels Nes
Changeset: 8c22fd0cbd9b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8c22fd0cbd9b
Added Files:
.bumpversion.cfg
CMakeLists.txt
Config.cmake.in
README.md
Release.md
clients/CMakeLists.txt
clients/examples/C/CMakeLists.txt
clients/examples/CMakeLists.txt
clients/examples/perl/CMakeLists.txt
clients/examples/php/CMakeLists.txt
clients/mapiclient/CMakeLists.txt
clients/mapilib/CMakeLists.txt
clients/odbc/CMakeLists.txt
clients/odbc/ChangeLog-Archive
clients/odbc/driver/CMakeLists.txt
clients/odbc/samples/CMakeLists.txt
clients/odbc/setup/CMakeLists.txt
clients/odbc/winsetup/CMakeLists.txt
cmake/Modules/FindCFitsIO.cmake
cmake/Modules/FindCommonCrypto.cmake
cmake/Modules/FindGeos.cmake
cmake/Modules/FindGetopt.cmake
cmake/Modules/FindKVM.cmake
cmake/Modules/FindLZ4.cmake
cmake/Modules/FindLibR.cmake
cmake/Modules/FindLiblas.cmake
cmake/Modules/FindLidar.cmake
cmake/Modules/FindLzma.cmake
cmake/Modules/FindNetCDF.cmake
cmake/Modules/FindNumPy.cmake
cmake/Modules/FindPCRE.cmake
cmake/Modules/FindProj.cmake
cmake/Modules/FindReadline.cmake
cmake/Modules/FindSnappy.cmake
cmake/Modules/FindUUID.cmake
cmake/Modules/FindValgrind.cmake
cmake/Toolchains/linux-clang.cmake
cmake/Toolchains/linux-gnu.cmake
cmake/Toolchains/linux-icc.cmake
cmake/monetdb-custom-targets.cmake
cmake/monetdb-deb-packages.cmake
cmake/monetdb-defines.cmake
cmake/monetdb-findpackages.cmake
cmake/monetdb-functions.cmake
cmake/monetdb-options.cmake
cmake/monetdb-packages.cmake
cmake/monetdb-rpm-packages.cmake
cmake/monetdb-toolchain.cmake
cmake/monetdb-versions.cmake
cmake/os_release_info.cmake
common/CMakeLists.txt
common/options/CMakeLists.txt
common/stream/CMakeLists.txt
common/utils/CMakeLists.txt
common/utils/monetdb_hgversion.h.in
create_include_object.py.in
ctest/CMakeLists.txt
ctest/cmake/CMakeLists.txt
ctest/cmake/detect-bz2.cmake
ctest/cmake/detect-commoncrypto.cmake
ctest/cmake/detect-curl.cmake
ctest/cmake/detect-fits.cmake
ctest/cmake/detect-gdal.cmake
ctest/cmake/detect-geos.cmake
ctest/cmake/detect-getaddrinfo.cmake
ctest/cmake/detect-iconv.cmake
ctest/cmake/detect-libpy3.cmake
ctest/cmake/detect-libr.cmake
ctest/cmake/detect-libz.cmake
ctest/cmake/detect-lz4.cmake
ctest/cmake/detect-lzma.cmake
ctest/cmake/detect-netcdf.cmake
ctest/cmake/detect-openssl.cmake
ctest/cmake/detect-pcre.cmake
ctest/cmake/detect-proj.cmake
ctest/cmake/detect-pthreadh.cmake
ctest/cmake/detect-pthreadinit.cmake
ctest/cmake/detect-pthreadkill.cmake
ctest/cmake/detect-pthreadsig.cmake
ctest/cmake/detect-readline.cmake
ctest/cmake/detect-snappy.cmake
ctest/cmake/detect-unixgetaddrinfo.cmake
ctest/cmake/detect-uuid.cmake
ctest/cmake/detect-valgrind.cmake
ctest/cmake/detect-wingetaddrinfo.cmake
ctest/cmake/detect-xml.cmake
ctest/cmake/set-cmake-vars.cmake
ctest/cmake/set-dir-vars.cmake
ctest/cmake/test_cmake_var.c.in
ctest/cmake/test_detect_bz2.c.in
ctest/cmake/test_detect_commoncrypto.c.in
ctest/cmake/test_detect_curl.c.in
ctest/cmake/test_detect_fits.c.in
ctest/cmake/test_detect_gdal.c.in
ctest/cmake/test_detect_geos.c.in
ctest/cmake/test_detect_getaddrinfo.c.in
ctest/cmake/test_detect_iconv.c.in
ctest/cmake/test_detect_libpy3.c.in
ctest/cmake/test_detect_libr.c.in
ctest/cmake/test_detect_libz.c.in
ctest/cmake/test_detect_lz4.c.in
ctest/cmake/test_detect_lzma.c.in
ctest/cmake/test_detect_netcdf.c.in
ctest/cmake/test_detect_openssl.c.in
ctest/cmake/test_detect_pcre.c.in
ctest/cmake/test_detect_proj.c.in
ctest/cmake/test_detect_pthreadh.c.in
ctest/cmake/test_detect_pthreadinit.c.in
ctest/cmake/test_detect_pthreadkill.c.in
ctest/cmake/test_detect_pthreadsig.c.in
ctest/cmake/test_detect_readline.c.in
ctest/cmake/test_detect_snappy.c.in
ctest/cmake/test_detect_unixgetaddrinfo.c.in
ctest/cmake/test_detect_uuid.c.in
ctest/cmake/test_detect_valgrind.c.in
ctest/cmake/test_detect_wingetaddrinfo.c.in
ctest/cmake/test_detect_xml.c.in
ctest/monetdb5/CMakeLists.txt
ctest/monetdb5/mal/CMakeLists.txt
ctest/monetdb5/mal/test_malEmbeddedBoot.c
ctest/monetdb5/mal/test_malInclude.c

MonetDB: typing - Merged with default

2020-05-08 Thread Pedro Ferreira
Changeset: 27d750370ead for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=27d750370ead
Added Files:
buildtools/selinux/ChangeLog.Jun2020
sql/test/Triggers/Tests/trigger_projection.sql.src
sql/test/Triggers/Tests/trigger_projection.stable.err
sql/test/Triggers/Tests/trigger_projection.stable.out
sql/test/Triggers/trigger_projection.sql
sql/test/Users/Tests/createUserRollback.SQL.py
sql/test/Users/Tests/createUserRollback.stable.err
sql/test/Users/Tests/createUserRollback.stable.out
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.err
sql/test/subquery/Tests/subquery6.stable.out
Modified Files:
MonetDB.spec
buildtools/selinux/monetdb.te
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
clients/mapiclient/mclient.c
configure.ag
gdk/ChangeLog.Jun2020
gdk/gdk.h
gdk/gdk_atoms.h
gdk/gdk_batop.c
gdk/gdk_calc.c
gdk/gdk_cross.c
gdk/gdk_heap.c
gdk/gdk_utils.h
monetdb5/ChangeLog.Jun2020
monetdb5/extras/rapi/rapi.c
monetdb5/modules/kernel/algebra.c
monetdb5/modules/kernel/algebra.h
monetdb5/modules/kernel/algebra.mal
monetdb5/modules/mal/mkey.c
monetdb5/optimizer/opt_mergetable.c
sql/backends/monet5/rel_bin.c
sql/backends/monet5/sql_execute.c
sql/backends/monet5/sql_scenario.c
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_statement.h
sql/backends/monet5/sql_upgrades.c
sql/backends/monet5/sql_user.c
sql/benchmarks/tpcds/Tests/alter.timeout
sql/include/sql_relation.h
sql/server/rel_dump.c
sql/server/rel_exp.c
sql/server/rel_optimizer.c
sql/server/rel_psm.c
sql/server/rel_rel.c
sql/server/rel_rel.h
sql/server/rel_select.c
sql/server/rel_semantic.c
sql/server/rel_unnest.c
sql/server/rel_updates.c
sql/storage/sql_storage.h
sql/storage/store.c

sql/test/BugDay_2005-12-19_2.9.3/Tests/subselect_cardinality.SF-1240701.1242164.stable.err
sql/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.err

sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.SQL.py
sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.out
sql/test/BugTracker-2013/Tests/pivot.Bug-3339.stable.err
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.err
sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out
sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out.single

sql/test/BugTracker-2017/Tests/type-resolution-error.Bugs-6313.stable.err

sql/test/BugTracker-2018/Tests/alter-sequence-subquery.Bug-6657.stable.err
sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.err
sql/test/BugTracker/Tests/insert_values.SF-1578838.stable.err
sql/test/Triggers/Tests/All
sql/test/Triggers/run.all
sql/test/Users/Tests/All
sql/test/analytics/Tests/analytics11.stable.err
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128

sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.SQL.py
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/miscellaneous/Tests/All
sql/test/miscellaneous/Tests/simple_selects.sql
sql/test/miscellaneous/Tests/simple_selects.stable.out
sql/test/subquery/Tests/All
sql/test/subquery/Tests/all.stable.out
sql/test/subquery/Tests/any.stable.out
sql/test/subquery/Tests/any_all.stable.out
sql/test/subquery/Tests/correlated.stable.err
sql/test/subquery/Tests/correlated.stable.out
sql/test/subquery/Tests/exists.stable.out
  

MonetDB: typing - Merged with default

2020-05-01 Thread Pedro Ferreira
Changeset: 6f687c56979d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6f687c56979d
Added Files:
clients/odbc/ChangeLog.Jun2020
sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.py

sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.stable.err

sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.stable.out
sql/test/Tests/sysqueue.sql
sql/test/Tests/sysqueue.stable.err
sql/test/Tests/sysqueue.stable.out
sql/test/analytics/Tests/analytics18.sql
sql/test/analytics/Tests/analytics18.stable.err
sql/test/analytics/Tests/analytics18.stable.out
sql/test/merge-partitions/Tests/mergepart30.sql
sql/test/merge-partitions/Tests/mergepart30.stable.err
sql/test/merge-partitions/Tests/mergepart30.stable.out
sql/test/miscellaneous/Tests/create_func_temp.sql
sql/test/miscellaneous/Tests/create_func_temp.stable.err
sql/test/miscellaneous/Tests/create_func_temp.stable.out
sql/test/miscellaneous/Tests/simple_plans.sql
sql/test/miscellaneous/Tests/simple_plans.stable.err
sql/test/miscellaneous/Tests/simple_plans.stable.out
sql/test/miscellaneous/Tests/table_udf_missing_var.py
sql/test/miscellaneous/Tests/table_udf_missing_var.stable.err
sql/test/miscellaneous/Tests/table_udf_missing_var.stable.out
sql/test/subquery/Tests/subquery5.stable.err
sql/test/subquery/Tests/subquery5.stable.out
tools/merovingian/daemon/snapshot.c
tools/merovingian/daemon/snapshot.h
Modified Files:
ChangeLog
ChangeLog.Jun2020
MonetDB.spec
NT/Makefile
NT/makelibdef.py
NT/mkodbcwxs.py
NT/mksqlwxs.py
NT/monetdb_config.h.in
NT/rules.msc
NT/winconfig.py
buildtools/autogen/autogen.py
buildtools/autogen/autogen/am.py
buildtools/autogen/autogen/codegen.py
buildtools/autogen/autogen/msc.py
buildtools/conf/fixlicense.py
buildtools/conf/monetdbd.conf
buildtools/selinux/monetdb.fc
buildtools/selinux/monetdb.te
clients/ChangeLog.Jun2020
clients/Tests/All
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SingleServer
clients/Tests/exports.stable.out
clients/examples/C/smack00.c
clients/examples/C/smack01.c
clients/examples/perl/sqlsample.pl
clients/examples/python/basics.py
clients/examples/python/sqlsample.py
clients/mapiclient/dotfile.py
clients/mapiclient/dotmonetdb.c
clients/mapiclient/dump.c
clients/mapiclient/mclient.1
clients/mapiclient/mclient.c
clients/mapiclient/mhelp.c
clients/mapiclient/stethoscope.c
clients/mapilib/mapi.c
clients/odbc/driver/ODBCConvert.c
clients/odbc/driver/ODBCUtil.c
clients/odbc/driver/SQLColumnPrivileges.c
clients/odbc/driver/SQLColumns.c
clients/odbc/driver/SQLForeignKeys.c
clients/odbc/driver/SQLPrepare.c
clients/odbc/driver/SQLPrimaryKeys.c
clients/odbc/driver/SQLProcedureColumns.c
clients/odbc/driver/SQLProcedures.c
clients/odbc/driver/SQLSpecialColumns.c
clients/odbc/driver/SQLStatistics.c
clients/odbc/driver/SQLTablePrivileges.c
clients/odbc/driver/SQLTables.c
clients/odbc/samples/arraytest.c
clients/odbc/samples/odbcsample1.c
clients/odbc/samples/testStmtAttr.c
clients/odbc/samples/testgetinfo.c
clients/odbc/winsetup/setup.c
common/options/getopt.c
common/options/getopt1.c
common/stream/stream.c
common/stream/stream.h
common/utils/mcrypt.c
common/utils/mcrypt.h
common/utils/msabaoth.c
common/utils/mstring.h
common/utils/mutils.h
common/utils/muuid.c
configure.ag
debian/changelog
debian/control
debian/monetdb5-server.dirs
debian/monetdb5-server.postinst
debian/monetdb5-sql.install
debian/monetdb5-sql.postinst
gdk/ChangeLog.Jun2020
gdk/Makefile.ag
gdk/gdk.h
gdk/gdk_aggr.c
gdk/gdk_align.c
gdk/gdk_analytic.h
gdk/gdk_analytic_bounds.c
gdk/gdk_analytic_func.c
gdk/gdk_atoms.c
gdk/gdk_bat.c
gdk/gdk_batop.c
gdk/gdk_bbp.c
gdk/gdk_calc.c
gdk/gdk_calc_compare.h
gdk/gdk_cand.c
gdk/gdk_delta.h
gdk/gdk_firstn.c
gdk/gdk_group.c
gdk/gdk_hash.c
gdk/gdk_heap.c
gdk/gdk_imprints.c
gdk/gdk_join.c
gdk/gdk_logger.c
gdk/gdk_orderidx.c
gdk/gdk_posix.c
gdk/gdk_posix.h
gdk/gdk_private.h
gdk/gdk_project.c
gdk/gdk_sample.c