MonetDB: parquet - merged with default

2023-06-29 Thread Niels Nes via checkin-list
Changeset: f2589c280581 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f2589c280581
Modified Files:
cmake/monetdb-defines.cmake
cmake/monetdb-findpackages.cmake
cmake/monetdb-options.cmake
monetdb5/mal/mal_embedded.c
monetdb_config.h.in
sql/backends/monet5/rel_bin.c
sql/server/rel_updates.c
sql/server/sql_parser.y
tools/mserver/mserver5.c
Branch: parquet
Log Message:

merged with default


diffs (truncated from 50837 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -796,3 +796,13 @@ e8b0e5558313f4d98bc48316368299decc55ed4e
 8a95168e853382b9b89ac7b67e343788ea837f3a Jul2021_31
 8a95168e853382b9b89ac7b67e343788ea837f3a Jul2021_SP9_release
 bb95192134c0d8ef8fea525204eefcd0de099a54 Jun2023_root
+24385ee6130494440e09d31ec73f4aa2e2893e98 Jul2021_33
+05b3d9ea9165baf1d2956d5b06ad85f817ecc6d2 Jul2021_33
+05b3d9ea9165baf1d2956d5b06ad85f817ecc6d2 Jul2021_SP10_release
+ed34ab4283cbfcc57fb9d7387bc9d781c91902b1 Jan2022_27
+ed34ab4283cbfcc57fb9d7387bc9d781c91902b1 Jan2022_SP7_release
+d11af9398029c117b92a9be9efa971ac0299ffc4 Sep2022_15
+8b736d6dcfd63d0560c99fc5427b504c116b74b0 Sep2022_17
+8b736d6dcfd63d0560c99fc5427b504c116b74b0 Sep2022_SP3_release
+aba8c31c60480148cd388a09ac99b42679406258 Jun2023_1
+79dbf838f04483a2d9ccce8332090ff91b18caec Jun2023_3
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -54,7 +54,6 @@ include(monetdb-toolchain)
 monetdb_default_compiler_options()
 
 include(monetdb-defines)
-monetdb_hg_revision()
 
 # required for symbol existance tests
 if(${CMAKE_SYSTEM_NAME} STREQUAL "Linux")
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -89,7 +89,7 @@ Group: Applications/Databases
 License: MPL-2.0
 URL: https://www.monetdb.org/
 BugURL: https://github.com/MonetDB/MonetDB/issues
-Source: 
https://www.monetdb.org/downloads/sources/Sep2022-SP2/%{name}-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Jun2023/%{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
@@ -118,7 +118,7 @@ BuildRequires: pkgconfig(readline)
 BuildRequires: pkgconfig(cfitsio)
 %endif
 %if %{with geos}
-BuildRequires: geos-devel >= 3.4.0
+BuildRequires: geos-devel >= 3.10.0
 %endif
 BuildRequires: pkgconfig(libcurl)
 BuildRequires: pkgconfig(liblzma)
@@ -432,6 +432,7 @@ install it.
 Summary: Integration of MonetDB and Python, allowing use of Python from within 
SQL
 Group: Applications/Databases
 Requires: MonetDB5-server%{?_isa} = %{version}-%{release}
+Requires: python3-numpy
 
 %description python3
 MonetDB is a database management system that is developed from a
@@ -859,6 +860,222 @@ fi
 %endif
 
 %changelog
+* Thu Jun 22 2023 Sjoerd Mullender  - 11.47.3-20230622
+- Rebuilt.
+- GH#7344: Database upgrade failure due to user object dependency on
+  system procedure
+- GH#7378: MonetDB server crashes at sql_trans_copy_key
+- GH#7379: MonetDB server 11.46.0 crashes at cs_bind_ubat
+- GH#7380: MonetDB server 11.46.0 crashes at `BLOBcmp`
+- GH#7381: MonetDB server 11.46.0 crashes at `log_create_delta`
+- GH#7382: MonetDB server 11.46.0 crashes at `gc_col`
+- GH#7383: MonetDB server 11.46.0 crashes at `list_append`
+- GH#7384: MonetDB server 11.46.0 crashes at `__nss_database_lookup`
+- GH#7386: MonetDB server 11.46.0 crashes in `rel_deps`
+- GH#7387: MonetDB server 11.46.0 crashes in `rel_sequences`
+
+* Tue Jun 20 2023 Sjoerd Mullender  - 11.47.3-20230622
+- clients: The COPY INTO from file ON CLIENT was extended to also look for a
+  relative path name relative to the file from which the query was read.
+  This is only possible if the name of the query file is known, so when
+  it is specified on the command line or read using the interactive
+  \< command.
+
+* Fri Jun 16 2023 Joeri van Ruth  - 
11.47.3-20230622
+- sql: Add MAX_MEMORY and MAX_WORKERS options to the ALTER USER statement
+
+* Fri Jun 16 2023 Sjoerd Mullender  - 11.47.1-20230616
+- Rebuilt.
+- GH#7311: Missing `REGEXP_REPLACE` function.
+- GH#7348: Subquery inside case always evaluated
+
+* Tue Jun  6 2023 Lucas Pereira  - 
11.47.1-20230616
+- sql: Function 'similarity(x string, y string)' marked as deprecated and will
+  be removed in the next release.
+
+* Tue Jun  6 2023 Martin van Dinther  
- 11.47.1-20230616
+- odbc: Extended Windows MonetDB ODBC Data Source setup program with option
+  to specify a logfile to enable tracing of ODBC Driver API calls.
+  On other platforms users can edit the  odbc.ini  file and add a line:
+  logfile=/home/username/odbctrace.log
+  When a logfile is specified it will start logging the ODBC Driver API calls
+  to the logfile after a new connection is made via SQLConnect() or
+  SQLDriverConnect() or SQLBrowseConnect().
+  Note that enabling ODBC logging will slow down the performance of ODBC
+  applications, so enable 

MonetDB: parquet - merged with default

2023-04-28 Thread Niels Nes
Changeset: ebc14728f538 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ebc14728f538
Modified Files:
sql/server/rel_dump.c
sql/server/sql_parser.y
tools/mserver/mserver5.c
Branch: parquet
Log Message:

merged with default


diffs (truncated from 1621 to 300 lines):

diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -272,7 +272,7 @@ void GDKclrerr(void);
 gdk_return GDKcopyenv(BAT **key, BAT **val, bool writable);
 gdk_return GDKcreatedir(const char *nme);
 gdk_return GDKcreatesem(int id, int count, int *semid);
-int GDKdebug;
+ATOMIC_TYPE GDKdebug;
 bool GDKembedded(void);
 bool GDKexiting(void);
 _Noreturn void GDKfatal(_In_z_ _Printf_format_string_ const char *format, ...) 
__attribute__((__format__(__printf__, 1, 2)));
@@ -281,7 +281,7 @@ bit GDKfataljumpenable;
 str GDKfatalmsg;
 char *GDKfilepath(int farmid, const char *dir, const char *nme, const char 
*ext);
 void GDKfree(void *blk);
-int GDKgetdebug(void);
+unsigned GDKgetdebug(void);
 const char *GDKgetenv(const char *name);
 int GDKgetenv_int(const char *name, int def);
 bool GDKgetenv_istext(const char *name, const char *text);
@@ -315,7 +315,7 @@ gdk_return GDKrebuild_segment_tree(oid n
 gdk_return GDKreleasemmap(void *ptr, size_t size, size_t id);
 gdk_return GDKreleasesem(int sem_id);
 void GDKreset(int status);
-void GDKsetdebug(int debug);
+void GDKsetdebug(unsigned debug);
 gdk_return GDKsetenv(const char *name, const char *value);
 void GDKsetmallocsuccesscount(lng count);
 ssize_t GDKstrFromStr(unsigned char *restrict dst, const unsigned char 
*restrict src, ssize_t len, char quote);
@@ -559,7 +559,7 @@ gdk_return log_tend(logger *lg);
 gdk_return log_tflush(logger *lg, ulng log_file_id, ulng commit_ts);
 gdk_return log_tsequence(logger *lg, int seq, lng id);
 gdk_return log_tstart(logger *lg, bool flushnow, ulng *log_file_id);
-log_level_t lvl_per_component[];
+ATOMIC_TYPE lvl_per_component[];
 void *mdlopen(const char *library, int mode);
 const char *mercurial_revision(void) __attribute__((__const__));
 int mo_add_option(opt **Set, int setlen, opt_kind kind, const char *name, 
const char *value);
diff --git a/gdk/ChangeLog.Sep2022 b/gdk/ChangeLog.Sep2022
--- a/gdk/ChangeLog.Sep2022
+++ b/gdk/ChangeLog.Sep2022
@@ -1,6 +1,10 @@
 # ChangeLog file for GDK
 # This file is updated with Maddlog
 
+* Tue Apr 25 2023 Sjoerd Mullender 
+- Fixed parsing of the BBP.dir file when BAT ids grow larger than 2**24
+  (i.e. 1 in octal).
+
 * Thu Apr 20 2023 Sjoerd Mullender 
 - Fixed yet another occurrence of a missing .tailN file.  This one could
   happen if a string bat was appended to in stages so that between appends
diff --git a/gdk/gdk.h b/gdk/gdk.h
--- a/gdk/gdk.h
+++ b/gdk/gdk.h
@@ -380,40 +380,40 @@ gdk_export _Noreturn void GDKfatal(_In_z
for a documentation of the following debug options.
 */
 
-#define THRDMASK   (1)
-#define CHECKMASK  (1<<1)
-#define CHECKDEBUG if (GDKdebug & CHECKMASK)
-#define PROPMASK   (1<<3)  /* unused */
-#define PROPDEBUG  if (GDKdebug & PROPMASK) /* unused */
-#define IOMASK (1<<4)
-#define BATMASK(1<<5)
-#define PARMASK(1<<7)
-#define TMMASK (1<<9)
-#define TEMMASK(1<<10)
-#define PERFMASK   (1<<12)
-#define DELTAMASK  (1<<13)
-#define LOADMASK   (1<<14)
-#define PUSHCANDMASK   (1<<15) /* used in opt_pushselect.c */
-#define TAILCHKMASK(1<<16) /* check .tail file size during commit */
-#define ACCELMASK  (1<<20)
-#define ALGOMASK   (1<<21)
+#define THRDMASK   (1U)
+#define CHECKMASK  (1U<<1)
+#define CHECKDEBUG if (ATOMIC_GET() & CHECKMASK)
+#define PROPMASK   (1U<<3) /* unused */
+#define PROPDEBUG  if (ATOMIC_GET() & PROPMASK) /* unused */
+#define IOMASK (1U<<4)
+#define BATMASK(1U<<5)
+#define PARMASK(1U<<7)
+#define TMMASK (1U<<9)
+#define TEMMASK(1U<<10)
+#define PERFMASK   (1U<<12)
+#define DELTAMASK  (1U<<13)
+#define LOADMASK   (1U<<14)
+#define PUSHCANDMASK   (1U<<15)/* used in opt_pushselect.c */
+#define TAILCHKMASK(1U<<16)/* check .tail file size during commit 
*/
+#define ACCELMASK  (1U<<20)
+#define ALGOMASK   (1U<<21)
 
-#define NOSYNCMASK (1<<24)
+#define NOSYNCMASK (1U<<24)
 
-#define DEADBEEFMASK   (1<<25)
-#define DEADBEEFCHKif (!(GDKdebug & DEADBEEFMASK))
+#define DEADBEEFMASK   (1U<<25)
+#define DEADBEEFCHKif (!(ATOMIC_GET() & DEADBEEFMASK))
 
-#define ALLOCMASK  (1<<26)
+#define ALLOCMASK  (1U<<26)
 
 /* M5, only; cf.,
  * monetdb5/mal/mal.h
  */
-#define OPTMASK(1<<27)
+#define OPTMASK(1U<<27)
 
-#define HEAPMASK   (1<<28)
+#define HEAPMASK   (1U<<28)
 
-#define FORCEMITOMASK  (1<<29)
-#define FORCEMITODEBUG if (GDKdebug & FORCEMITOMASK)

MonetDB: parquet - merged with default

2023-04-23 Thread Niels Nes
Changeset: 81b0b38eed3c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/81b0b38eed3c
Modified Files:
monetdb5/mal/mal_embedded.c
sql/backends/monet5/CMakeLists.txt
sql/backends/monet5/rel_bin.c
sql/backends/monet5/vaults/csv/csv.c
sql/common/sql_types.c
sql/server/rel_select.c
sql/server/sql_parser.y
Branch: parquet
Log Message:

merged with default


diffs (truncated from 24511 to 300 lines):

diff --git a/.bumpversion.cfg b/.bumpversion.cfg
--- a/.bumpversion.cfg
+++ b/.bumpversion.cfg
@@ -1,5 +1,5 @@
 [bumpversion]
-current_version = 11.46.0
+current_version = 11.48.0
 commit = False
 tag = False
 
@@ -30,4 +30,3 @@ serialize = {major},{minor},{patch}
 [bumpversion:file:monetdb5/tools/libmonetdb5.rc]
 parse = (?P\d+),(?P\d+),(?P\d+)
 serialize = {major},{minor},{patch}
-
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -795,3 +795,4 @@ e8b0e5558313f4d98bc48316368299decc55ed4e
 e8b0e5558313f4d98bc48316368299decc55ed4e Sep2022_SP2_release
 8a95168e853382b9b89ac7b67e343788ea837f3a Jul2021_31
 8a95168e853382b9b89ac7b67e343788ea837f3a Jul2021_SP9_release
+bb95192134c0d8ef8fea525204eefcd0de099a54 Jun2023_root
diff --git a/ChangeLog b/ChangeLog.Jun2023
copy from ChangeLog
copy to ChangeLog.Jun2023
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -7,7 +7,7 @@
 # Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
 
 %global name MonetDB
-%global version 11.46.0
+%global version 11.48.0
 %{!?buildno: %global buildno %(date +%Y%m%d)}
 
 # Use bcond_with to add a --with option; i.e., "without" is default.
@@ -366,6 +366,7 @@ developer.
 %{_bindir}/ODBCStmtAttr
 %{_bindir}/ODBCgetInfo
 %{_bindir}/ODBCmetadata
+%{_bindir}/ODBCtester
 %{_bindir}/arraytest
 %{_bindir}/bincopydata
 %{_bindir}/odbcsample1
diff --git a/clients/ChangeLog b/clients/ChangeLog.Jun2023
copy from clients/ChangeLog
copy to clients/ChangeLog.Jun2023
diff --git a/clients/ChangeLog.Sep2022 b/clients/ChangeLog.Sep2022
--- a/clients/ChangeLog.Sep2022
+++ b/clients/ChangeLog.Sep2022
@@ -1,3 +1,8 @@
 # ChangeLog file for clients
 # This file is updated with Maddlog
 
+* Mon Apr 17 2023 Sjoerd Mullender 
+- If the number of rows in mclient is set to 0 (using either --rows=0
+  option or \r0 on the mclient command line), the internal pager is used
+  and it then uses the height of the terminal window.
+
diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -1019,11 +1019,21 @@ command aggr.quantile(X_0:bat[:any_1], X
 AGGRquantile;
 Quantile aggregate
 aggr
+quantile
+command aggr.quantile(X_0:bat[:any_1], X_1:dbl):any_1 
+AGGRquantile_cst;
+Quantile aggregate
+aggr
 quantile_avg
 command aggr.quantile_avg(X_0:bat[:any_1], X_1:bat[:dbl]):dbl 
 AGGRquantile_avg;
 Quantile aggregate
 aggr
+quantile_avg
+command aggr.quantile_avg(X_0:bat[:any_1], X_1:dbl):dbl 
+AGGRquantile_avg_cst;
+Quantile aggregate
+aggr
 stdev
 command aggr.stdev(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] 
 AGGRstdev3_dbl;
@@ -34574,35 +34584,130 @@ pattern batstr.ascii(X_0:bat[:str], X_1:
 STRbatAscii;
 Return unicode of head of string
 batstr
+asciify
+command batstr.asciify(X_0:bat[:str]):bat[:str] 
+BATSTRasciify;
+Transform BAT of strings from UTF8 to ASCII
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:bat[:str]):bat[:bit] 
+BATSTRcontains;
+Check if bat string haystack contains bat string needle.
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid], 
X_3:bat[:oid]):bat[:bit] 
+BATSTRcontains;
+Check if bat string haystack contains bat string needle (with CLs).
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:bat[:str], X_2:bit):bat[:bit] 
+BATSTRcontains;
+Check if bat string haystack contains bat string needle, icase flag.
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:bat[:str], X_2:bit, X_3:bat[:oid], 
X_4:bat[:oid]):bat[:bit] 
+BATSTRcontains;
+Check if bat string haystack contains bat string needle (with CLs) + icase 
flag.
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:str):bat[:bit] 
+BATSTRcontains_cst;
+Check if bat string haystack contains string needle.
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:str, X_2:bat[:oid]):bat[:bit] 
+BATSTRcontains_cst;
+Check if bat string haystack contains string needle (with CL) ends with 
substring.
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:str, X_2:bit):bat[:bit] 
+BATSTRcontains_cst;
+Check if bat string haystack contains string needle, icase flag.
+batstr
+contains
+pattern batstr.contains(X_0:bat[:str], X_1:str, X_2:bit, 
X_3:bat[:oid]):bat[:bit] 
+BATSTRcontains_cst;
+Check if bat string haystack contains string needle (with CL) ends with 
substring + icase flag.
+batstr
+contains
+pattern batstr.contains(X_0:str, X_1:bat[:str]):bat[:bit] 

MonetDB: parquet - merged with default

2023-03-03 Thread Niels Nes
Changeset: 29d608b3ad52 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/29d608b3ad52
Modified Files:
README.rst
cmake/monetdb-defines.cmake
cmake/monetdb-findpackages.cmake
cmake/monetdb-options.cmake
monetdb5/mal/mal_linker.c
monetdb_config.h.in
sql/backends/monet5/vaults/CMakeLists.txt
sql/common/sql_types.c
sql/server/CMakeLists.txt
sql/server/rel_select.c
sql/server/rel_updates.c
sql/server/sql_parser.y
tools/mserver/mserver5.c
Branch: parquet
Log Message:

merged with default


diffs (truncated from 485409 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -789,3 +789,6 @@ 43d4a717410d6f6692a16a878640fc7e0f248725
 43d4a717410d6f6692a16a878640fc7e0f248725 Jan2022_SP6_release
 5c50a4071c86d1621e20a885a51cc36f2f23eec4 Sep2022_9
 41ca60d96bd0198ca5d74937630a442a5fbaf1cd Sep2022_11
+41ca60d96bd0198ca5d74937630a442a5fbaf1cd Sep2022_SP1_release
+e8b0e5558313f4d98bc48316368299decc55ed4e Sep2022_13
+e8b0e5558313f4d98bc48316368299decc55ed4e Sep2022_SP2_release
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -1,9 +1,11 @@
 #[[
+# SPDX-License-Identifier: MPL-2.0
+#
 # This Source Code Form is subject to the terms of the Mozilla Public
 # License, v. 2.0.  If a copy of the MPL was not distributed with this
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
-# Copyright 1997 - July 2008 CWI, August 2008 - 2022 MonetDB B.V.
+# Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
 #]]
 
 cmake_minimum_required(VERSION 3.12)
diff --git a/Config.cmake.in b/Config.cmake.in
--- a/Config.cmake.in
+++ b/Config.cmake.in
@@ -1,9 +1,11 @@
 #[[
+# SPDX-License-Identifier: MPL-2.0
+#
 # This Source Code Form is subject to the terms of the Mozilla Public
 # License, v. 2.0.  If a copy of the MPL was not distributed with this
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
-# Copyright 1997 - July 2008 CWI, August 2008 - 2022 MonetDB B.V.
+# Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
 #]]
 
 @PACKAGE_INIT@
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -1,8 +1,10 @@
+# SPDX-License-Identifier: MPL-2.0
+#
 # This Source Code Form is subject to the terms of the Mozilla Public
 # License, v. 2.0.  If a copy of the MPL was not distributed with this
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
-# Copyright 1997 - July 2008 CWI, August 2008 - 2022 MonetDB B.V.
+# Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
 
 %global name MonetDB
 %global version 11.46.0
@@ -80,14 +82,14 @@
 Name: %{name}
 Version: %{version}
 Release: %{release}
-Summary: MonetDB - Monet Database Management System
+Summary: Monet Database Management System
 Vendor: MonetDB BV 
 
 Group: Applications/Databases
-License: MPLv2.0
+License: MPL-2.0
 URL: https://www.monetdb.org/
-BugURL: https://bugs.monetdb.org/
-Source: 
https://www.monetdb.org/downloads/sources/Sep2022-SP1/%{name}-%{version}.tar.bz2
+BugURL: https://github.com/MonetDB/MonetDB/issues
+Source: 
https://www.monetdb.org/downloads/sources/Sep2022-SP2/%{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
@@ -128,6 +130,7 @@ BuildRequires: pkgconfig(zlib)
 BuildRequires: pkgconfig(liblz4) >= 1.8
 %if %{with py3integration}
 BuildRequires: pkgconfig(python3) >= 3.5
+# cannot use python3dist(numpy) because of CentOS 7
 BuildRequires: python3-numpy
 %endif
 %if %{with rintegration}
@@ -141,12 +144,12 @@ BuildRequires: texlive-obsolete
 %endif
 %endif
 # optional packages:
-# BuildRequires: pkgconfig(cmocka) # -DWITH_CMOCKA=ON
-# BuildRequires: pkgconfig(gdal)   # -DSHP=ON
-# BuildRequires: pkgconfig(netcdf) # -DNETCDF=ON
-# BuildRequires: pkgconfig(proj)   # -DWITH_PROJ=ON
-# BuildRequires: pkgconfig(snappy) # -DWITH_SNAPPY=ON
-# BuildRequires: pkgconfig(valgrind)   # -DWITH_VALGRIND=ON
+# BuildRequires: pkgconfig(cmocka)  # -DWITH_CMOCKA=ON
+# BuildRequires: pkgconfig(gdal)# -DSHP=ON
+# BuildRequires: pkgconfig(netcdf)  # -DNETCDF=ON
+# BuildRequires: pkgconfig(proj)# -DWITH_PROJ=ON
+# BuildRequires: pkgconfig(snappy)  # -DWITH_SNAPPY=ON
+# BuildRequires: pkgconfig(valgrind)# -DWITH_VALGRIND=ON
 
 %if (0%{?fedora} >= 22)
 Recommends: %{name}-SQL-server5%{?_isa} = %{version}-%{release}
@@ -343,7 +346,6 @@ Recommends: perl-DBD-monetdb >= 1.0
 Recommends: php-monetdb >= 1.0
 %endif
 Requires: MonetDB5-server%{?_isa} = %{version}-%{release}
-Requires: python3-pymonetdb >= 1.0.6
 %if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} > 7
 Recommends: python3dist(lz4)
 Recommends: python3dist(scipy)
@@ -503,17 +505,17 @@ getent group monetdb >/dev/null || group
 if getent passwd monetdb >/dev/null; then
 case $(getent passwd monetdb | cut -d: -f6) in
 

MonetDB: parquet - merged with default

2022-12-09 Thread Niels Nes
Changeset: 3ef2d29456cb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/3ef2d29456cb
Modified Files:
sql/common/sql_types.c
sql/server/rel_select.c
Branch: parquet
Log Message:

merged with default


diffs (truncated from 9661 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -786,3 +786,6 @@ 47675351fec22d5d5dc81eec03dfa08f505afc99
 44e45c9a451f6afd933773094ec25723f713d3be Jan2022_23
 44e45c9a451f6afd933773094ec25723f713d3be Jan2022_SP5_release
 43d4a717410d6f6692a16a878640fc7e0f248725 Jan2022_25
+43d4a717410d6f6692a16a878640fc7e0f248725 Jan2022_SP6_release
+5c50a4071c86d1621e20a885a51cc36f2f23eec4 Sep2022_9
+41ca60d96bd0198ca5d74937630a442a5fbaf1cd Sep2022_11
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -87,7 +87,7 @@ Group: Applications/Databases
 License: MPLv2.0
 URL: https://www.monetdb.org/
 BugURL: https://bugs.monetdb.org/
-Source: 
https://www.monetdb.org/downloads/sources/Sep2022/%{name}-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Sep2022-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
@@ -855,6 +855,55 @@ fi
 %endif
 
 %changelog
+* Mon Dec 05 2022 Sjoerd Mullender  - 11.45.11-20221205
+- Rebuilt.
+- GH#7342: column which datatype is double couldn't group or aggregation
+  in version 11.45.7
+
+* Mon Nov 28 2022 Sjoerd Mullender  - 11.45.9-20221128
+- Rebuilt.
+- GH#7330: Creating temporary table fails after reconnect
+- GH#7333: DLLs fail to load on Windows with accented characters in path
+- GH#7336: Selecting from a literal-value table returns wrong values
+- GH#7339: MonetDB corrupted state after SIGKILL
+
+* Wed Nov  9 2022 Sjoerd Mullender  - 11.45.9-20221128
+- clients: Also dump the new options of CREATE USER.
+
+* Wed Nov  9 2022 Sjoerd Mullender  - 11.45.9-20221128
+- gdk: On Windows, use the wide-character interface of system calls when
+  dealing with the environment (i.e. file names and getenv()).
+- gdk: Memory leaks have been fixed.
+- gdk: Improved maintenance of the estimated number of distinct values in BATs.
+  The estimate helps in deciding which low-level algorithm to use.
+
+* Wed Nov  9 2022 Sjoerd Mullender  - 11.45.9-20221128
+- monetdb5: Fixed a crash when the server runs out of client contexts (i.e. 
more
+  concurrent clients than the server is configured to handle).
+- monetdb5: A race condition in the SHA hash code was fixed which resulted in
+  occasional failed connection attempts when they occurred concurrently.
+
+* Wed Nov  9 2022 Sjoerd Mullender  - 11.45.9-20221128
+- sql: Improved the handling of the "idle" value in the sys.sessions function
+  and view.
+
+* Wed Oct 19 2022 Sjoerd Mullender  - 11.45.9-20221128
+- monetdb5: Fix a bug where the MAL optimizer would use the starttime of the
+  previous query to determine whether a query timeout occurred.
+
+* Thu Oct 13 2022 Martin van Dinther  
- 11.45.9-20221128
+- odbc: Fixed issue with generated raw strings prefix when ODBC driver is used
+  against a server older than Jun2020 (11.37).
+
+* Wed Oct 12 2022 Sjoerd Mullender  - 11.45.9-20221128
+- merovingian: Stop logging references to monetdbd's logfile in said logfile.
+
+* Mon Oct 10 2022 Sjoerd Mullender  - 11.45.9-20221128
+- gdk: Offset heaps (.tailN files) were growing too fast and unnecessarily
+  under certain conditions.  This has been fixed.  Also, when such too
+  large files are now loaded into the system, it is recognized they are
+  too large and they are truncated to a more reasonable size.
+
 * Fri Sep 23 2022 Sjoerd Mullender  - 11.45.7-20220923
 - Rebuilt.
 
diff --git a/clients/ChangeLog-Archive b/clients/ChangeLog-Archive
--- a/clients/ChangeLog-Archive
+++ b/clients/ChangeLog-Archive
@@ -1,6 +1,9 @@
 # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY
 # This file contains past ChangeLog entries
 
+* Wed Nov  9 2022 Sjoerd Mullender  - 11.45.9-20221128
+- Also dump the new options of CREATE USER.
+
 * Wed Sep 21 2022 Sjoerd Mullender  - 11.45.3-20220921
 - Dumping of function GRANTs was improved by adding the types of the
   function (and procedure) arguments.
diff --git a/clients/ChangeLog.Sep2022 b/clients/ChangeLog.Sep2022
--- a/clients/ChangeLog.Sep2022
+++ b/clients/ChangeLog.Sep2022
@@ -1,6 +1,3 @@
 # ChangeLog file for clients
 # This file is updated with Maddlog
 
-* Wed Nov  9 2022 Sjoerd Mullender 
-- Also dump the new options of CREATE USER.
-
diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -43895,11 +43895,6 @@ CLTsetPrintTimeout;
 Print running query every so many seconds.
 clients
 setquerytimeout
-unsafe pattern clients.setquerytimeout(X_0:bte, X_1:int):void 
-CLTqueryTimeout;
-(empty)
-clients
-setquerytimeout
 unsafe pattern 

MonetDB: parquet - merged with default

2022-11-27 Thread Niels Nes
Changeset: 7b0302b9824b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7b0302b9824b
Modified Files:
monetdb_config.h.in
Branch: parquet
Log Message:

merged with default


diffs (truncated from 12101 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -785,3 +785,4 @@ 47675351fec22d5d5dc81eec03dfa08f505afc99
 47675351fec22d5d5dc81eec03dfa08f505afc99 Sep2022_release
 44e45c9a451f6afd933773094ec25723f713d3be Jan2022_23
 44e45c9a451f6afd933773094ec25723f713d3be Jan2022_SP5_release
+43d4a717410d6f6692a16a878640fc7e0f248725 Jan2022_25
diff --git a/clients/ChangeLog.Sep2022 b/clients/ChangeLog.Sep2022
--- a/clients/ChangeLog.Sep2022
+++ b/clients/ChangeLog.Sep2022
@@ -1,3 +1,6 @@
 # ChangeLog file for clients
 # This file is updated with Maddlog
 
+* Wed Nov  9 2022 Sjoerd Mullender 
+- Also dump the new options of CREATE USER.
+
diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -30620,13 +30620,13 @@ CLRbatycc;
 Converts an YCC triplets to a color atom
 batgeom
 AsEWKT
-function batgeom.AsEWKT(w:bat[:wkb]):bat[:str];
-(empty)
+command batgeom.AsEWKT(X_0:bat[:wkb]):bat[:str] 
+batgeom_AsEWKT_wkb;
 (empty)
 batgeom
 AsText
-function batgeom.AsText(w:bat[:wkb]):bat[:str];
-(empty)
+command batgeom.AsText(X_0:bat[:wkb]):bat[:str] 
+batgeom_AsText_wkb;
 (empty)
 batgeom
 Boundary
@@ -30685,23 +30685,23 @@ wkbFromText_bat;
 (empty)
 batgeom
 GeomCollFromText
-function batgeom.GeomCollFromText(wkt:bat[:str]):bat[:wkb];
-(empty)
+command batgeom.GeomCollFromText(X_0:bat[:str]):bat[:wkb] 
+batgeom_GeomCollFromText_str;
 (empty)
 batgeom
 GeomCollFromText
-function batgeom.GeomCollFromText(wkt:bat[:str], srid:int):bat[:wkb];
-(empty)
+command batgeom.GeomCollFromText(X_0:bat[:str], X_1:int):bat[:wkb] 
+batgeom_GeomCollFromText_str_int;
 (empty)
 batgeom
 GeomFromText
-function batgeom.GeomFromText(wkt:bat[:str]):bat[:wkb];
-(empty)
+command batgeom.GeomFromText(X_0:bat[:str]):bat[:wkb] 
+batgeom_GeomFromText_str;
 (empty)
 batgeom
 GeomFromText
-function batgeom.GeomFromText(wkt:bat[:str], srid:int):bat[:wkb];
-(empty)
+command batgeom.GeomFromText(X_0:bat[:str], X_1:int):bat[:wkb] 
+batgeom_GeomFromText_str_int;
 (empty)
 batgeom
 GeometryN
@@ -30715,13 +30715,13 @@ wkbGeometryType_bat;
 (empty)
 batgeom
 GeometryType1
-function batgeom.GeometryType1(w:bat[:wkb]):bat[:str];
-(empty)
+command batgeom.GeometryType1(X_0:bat[:wkb]):bat[:str] 
+batgeom_GeometryType1_wkb;
 (empty)
 batgeom
 GeometryType2
-function batgeom.GeometryType2(w:bat[:wkb]):bat[:str];
-(empty)
+command batgeom.GeometryType2(X_0:bat[:wkb]):bat[:str] 
+batgeom_GeometryType2_wkb;
 (empty)
 batgeom
 GetCoordinate
@@ -30755,43 +30755,43 @@ wkbIsValid_bat;
 (empty)
 batgeom
 LineFromText
-function batgeom.LineFromText(wkt:bat[:str]):bat[:wkb];
-(empty)
+command batgeom.LineFromText(X_0:bat[:str]):bat[:wkb] 
+batgeom_LineFromText_str;
 (empty)
 batgeom
 LineFromText
-function batgeom.LineFromText(wkt:bat[:str], srid:int):bat[:wkb];
-(empty)
+command batgeom.LineFromText(X_0:bat[:str], X_1:int):bat[:wkb] 
+batgeom_LineFromText_str_int;
 (empty)
 batgeom
 MLineFromText
-function batgeom.MLineFromText(wkt:bat[:str]):bat[:wkb];
-(empty)
+command batgeom.MLineFromText(X_0:bat[:str]):bat[:wkb] 
+batgeom_MLineFromText_str;
 (empty)
 batgeom
 MLineFromText
-function batgeom.MLineFromText(wkt:bat[:str], srid:int):bat[:wkb];
-(empty)
+command batgeom.MLineFromText(X_0:bat[:str], X_1:int):bat[:wkb] 
+batgeom_MLineFromText_str_int;
 (empty)
 batgeom
 MPointFromText
-function batgeom.MPointFromText(wkt:bat[:str]):bat[:wkb];
-(empty)
+command batgeom.MPointFromText(X_0:bat[:str]):bat[:wkb] 
+batgeom_MPointFromText_str;
 (empty)
 batgeom
 MPointFromText
-function batgeom.MPointFromText(wkt:bat[:str], srid:int):bat[:wkb];
-(empty)
+command batgeom.MPointFromText(X_0:bat[:str], X_1:int):bat[:wkb] 
+batgeom_MPointFromText_str_int;
 (empty)
 batgeom
 MPolyFromText
-function batgeom.MPolyFromText(wkt:bat[:str]):bat[:wkb];
-(empty)
+command batgeom.MPolyFromText(X_0:bat[:str]):bat[:wkb] 
+batgeom_MPolyFromText_str;
 (empty)
 batgeom
 MPolyFromText
-function batgeom.MPolyFromText(wkt:bat[:str], srid:int):bat[:wkb];
-(empty)
+command batgeom.MPolyFromText(X_0:bat[:str], X_1:int):bat[:wkb] 
+batgeom_MPolyFromText_str_int;
 (empty)
 batgeom
 MakeBox2D
@@ -30805,23 +30805,23 @@ wkbMakeLine_bat;
 Gets two BATS of point or linestring geometries and returns a bat with 
linestring geometries
 batgeom
 MakePoint
-function batgeom.MakePoint(x:bat[:dbl], y:bat[:dbl]):bat[:wkb];
-(empty)
+command batgeom.MakePoint(X_0:bat[:dbl], X_1:bat[:dbl]):bat[:wkb] 
+batgeom_MakePoint_dbl_dbl;
 (empty)
 batgeom
 MakePoint
-function batgeom.MakePoint(x:bat[:dbl], y:bat[:dbl], z:bat[:dbl]):bat[:wkb];
-(empty)
+command batgeom.MakePoint(X_0:bat[:dbl], X_1:bat[:dbl], 
X_2:bat[:dbl]):bat[:wkb] 
+batgeom_MakePoint_dbl_dbl_dbl;
 (empty)