MonetDB: Aug2024 - Pre-release version number update.

2024-10-25 Thread Sjoerd Mullender via checkin-list
Changeset: 48f6bc33d185 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/48f6bc33d185
Modified Files:
.bumpversion.cfg
MonetDB.spec
clients/mapilib/mapi.rc
clients/odbc/driver/driver.rc
clients/odbc/winsetup/setup.rc
cmake/monetdb-versions.cmake
gdk/libbat.rc
monetdb5/tools/libmonetdb5.rc
Branch: Aug2024
Log Message:

Pre-release version number update.


diffs (191 lines):

diff --git a/.bumpversion.cfg b/.bumpversion.cfg
--- a/.bumpversion.cfg
+++ b/.bumpversion.cfg
@@ -1,5 +1,5 @@
 [bumpversion]
-current_version = 11.51.4
+current_version = 11.51.5
 commit = False
 tag = False
 
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -8,7 +8,7 @@
 # Copyright August 2008 - 2023 MonetDB B.V.;
 # Copyright 1997 - July 2008 CWI.
 
-%global version 11.51.4
+%global version 11.51.5
 
 %bcond_with compat
 
diff --git a/clients/mapilib/mapi.rc b/clients/mapilib/mapi.rc
--- a/clients/mapilib/mapi.rc
+++ b/clients/mapilib/mapi.rc
@@ -6,8 +6,8 @@ LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_U
 #define sversion(major,minor,patch)#major "." #minor "." #patch "\0"
 
 1 VERSIONINFO
-  FILEVERSION version(11,51,4)
-  PRODUCTVERSION version(11,51,4)
+  FILEVERSION version(11,51,5)
+  PRODUCTVERSION version(11,51,5)
   FILEFLAGSMASK 0x3fL
   FILEFLAGS 0
   FILEOS VOS_NT_WINDOWS32
@@ -21,14 +21,14 @@ BEGIN
   VALUE "Comments", "\0"
   VALUE "CompanyName", "MonetDB Foundation\0"
   VALUE "FileDescription", "MonetDB Application Interface DLL\0"
-  VALUE "FileVersion", sversion(11,51,4)
+  VALUE "FileVersion", sversion(11,51,5)
   VALUE "InternalName", "Mapi\0"
   VALUE "LegalCopyright", "Copyright (c) 2024 MonetDB Foundation\0"
   VALUE "LegalTrademarks", "\0"
   VALUE "OriginalFilename", "Mapi.dll\0"
   VALUE "PrivateBuild", "\0"
   VALUE "ProductName", "MonetDB Client Libraries\0"
-  VALUE "ProductVersion", sversion(11,51,4)
+  VALUE "ProductVersion", sversion(11,51,5)
   VALUE "SpecialBuild", "\0"
 END
   END
diff --git a/clients/odbc/driver/driver.rc b/clients/odbc/driver/driver.rc
--- a/clients/odbc/driver/driver.rc
+++ b/clients/odbc/driver/driver.rc
@@ -6,8 +6,8 @@ LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_U
 #define sversion(major,minor,patch)#major "." #minor "." #patch "\0"
 
 1 VERSIONINFO
-  FILEVERSION version(11,51,4)
-  PRODUCTVERSION version(11,51,4)
+  FILEVERSION version(11,51,5)
+  PRODUCTVERSION version(11,51,5)
   FILEFLAGSMASK 0x3fL
   FILEFLAGS 0
   FILEOS VOS_NT_WINDOWS32
@@ -21,14 +21,14 @@ BEGIN
   VALUE "Comments", "\0"
   VALUE "CompanyName", "MonetDB Foundation\0"
   VALUE "FileDescription", "MonetDB ODBC Driver DLL\0"
-  VALUE "FileVersion", sversion(11,51,4)
+  VALUE "FileVersion", sversion(11,51,5)
   VALUE "InternalName", "MonetODBC\0"
   VALUE "LegalCopyright", "Copyright (c) 2024 MonetDB Foundation\0"
   VALUE "LegalTrademarks", "\0"
   VALUE "OriginalFilename", "MonetODBC.dll\0"
   VALUE "PrivateBuild", "\0"
   VALUE "ProductName", "MonetDB ODBC Driver\0"
-  VALUE "ProductVersion", sversion(11,51,4)
+  VALUE "ProductVersion", sversion(11,51,5)
   VALUE "SpecialBuild", "\0"
 END
   END
diff --git a/clients/odbc/winsetup/setup.rc b/clients/odbc/winsetup/setup.rc
--- a/clients/odbc/winsetup/setup.rc
+++ b/clients/odbc/winsetup/setup.rc
@@ -51,8 +51,8 @@ END
 //
 
 VS_VERSION_INFO VERSIONINFO
- FILEVERSION version(11,51,4)
- PRODUCTVERSION version(11,51,4)
+ FILEVERSION version(11,51,5)
+ PRODUCTVERSION version(11,51,5)
  FILEFLAGSMASK 0x3fL
 #ifdef _DEBUG
  FILEFLAGS 0x1L
@@ -69,12 +69,12 @@ BEGIN
 BEGIN
 VALUE "CompanyName", "MonetDB Foundation"
 VALUE "FileDescription", "MonetDB ODBC Setup DLL"
-VALUE "FileVersion", sversion(11,51,4)
+VALUE "FileVersion", sversion(11,51,5)
 VALUE "InternalName", "MonetODBCs.dll"
 VALUE "LegalCopyright", "Copyright (c) 2024 MonetDB Foundation"
 VALUE "OriginalFilename", "MonetODBCs.dll"
 VALUE "ProductName", "MonetDB ODBC Setup"
-VALUE "ProductVersion", sversion(11,51,4)
+VALUE "ProductVersion", sversion(11,51,5)
 END
 END
 BLOCK "VarFileInfo"
diff --git a/cmake/monetdb-versions.cmake b/cmake/monetdb-versions.cmake
--- a/cmake/monetdb-versions.cmake
+++ b/cmake/monetdb-versions.cmake
@@ -12,10 +12,10 @@
 
 set(MONETDB_VERSION_MAJOR "11")
 set(MONETDB_VERSION_MINOR "51")
-set(MONETDB_VERSION_PATCH "4")
+set(MONETDB_VERSION_PATCH "5")
 
 if(RELEASE_VERSION)
-  set(MONETDB_RELEASE "unreleased")
+  set(MONETDB_RELEASE "Aug2024-SP1")
 endif()
 set(MONETDB_VERSION 
"${MONETDB_VERSION_MAJOR}.${MONETDB_VERSION_MINOR}.${MONETDB_VERSION_PATCH}")
 
diff --git a/gdk/libbat.rc b/gdk/libbat.rc
--- a/gdk/libbat.rc
+++ b/gdk/libbat.rc
@@ -6,8 +6,8 @@ LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_U
 #define sversion(major,minor

MonetDB: ordered-set-aggregates - merged with default

2024-10-25 Thread Niels Nes via checkin-list
Changeset: acb6e2a6951d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/acb6e2a6951d
Modified Files:
sql/server/rel_dump.c
sql/storage/store.c
Branch: ordered-set-aggregates
Log Message:

merged with default


diffs (truncated from 873 to 300 lines):

diff --git a/.github/workflows/linux.yml b/.github/workflows/linux.yml
--- a/.github/workflows/linux.yml
+++ b/.github/workflows/linux.yml
@@ -48,7 +48,12 @@ jobs:
   ref: ${{ github.ref }}
 
   - name: install pymonetdb cryptography
+run: pip3 install --user --upgrade pymonetdb cryptography
+if: runner.os != 'macOS'
+
+  - name: install pymonetdb cryptography
 run: pip3 install --user --break-system-packages --upgrade pymonetdb 
cryptography
+if: runner.os == 'macOS'
 
   - name: make MonetDB on linux
 run: |
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -833,3 +833,4 @@ cde7d8f7c99540a8c95856df052a9f123b0c1643
 ae474f7fda0a3f2ebefc6c0b2cd969ef0854fad1 Aug2024_1
 dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_3
 dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_release
+ab5d60be21cd1c65e9de476d71a86c2995f70785 Aug2024_5
diff --git a/ChangeLog.Aug2024 b/ChangeLog.Aug2024
--- a/ChangeLog.Aug2024
+++ b/ChangeLog.Aug2024
@@ -1,10 +1,3 @@
 # ChangeLog file for devel
 # This file is updated with Maddlog
 
-* Thu Oct 17 2024 Niels Nes 
-- Changed generic Decimal handling (ie without digits/scale), old cased
-  mapped always into dec(18,3) now this is only done in case of create of
-  a column. In other cases the coercion to the correct decimal type is
-  based on the input data type. For *api (LANG*PY/C(pp)/R) we no longer
-  allow generic decimal type in the function definitions.
-
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -95,7 +95,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/Aug2024/MonetDB-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Aug2024-SP1/MonetDB-%{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
@@ -989,6 +989,57 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd
 %endif
 
 %changelog
+* Thu Oct 24 2024 Sjoerd Mullender  - 11.51.5-20241024
+- Rebuilt.
+- GH#7281: UDFs defined at compile time in a user schema should not become
+  system functions
+- GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW`
+- GH#7567: creating remote table from subquery crashes the server
+- GH#7569: Column of temporary table changes when another is updated
+- GH#7570: BUG in the "str_to_timestamp" function
+- GH#7571: Crash when integer overflow in `ORDER BY`
+- GH#7572: column max length is not stored as specified and accepted at
+  creation time
+- GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with
+  restart.
+- GH#7576: unescaping UTF-16 code units goes wrong in json.text
+- GH#7577: Crash when using `CHECK` constraint
+- GH#7580: statistics optimizer handles date difference incorrectly
+- GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN
+  EXISTS (..)
+- GH#7583: Query slowdown after deleting rows from large table
+- GH#7584: SO_KEEPALIVE should be configured sensibly
+- GH#7585: rel2bin_join: Assertion `sql->session->status == -10' failed.
+- GH#7587: Line/row numbers get out of sync with COPY INTO .. BEST EFFORT
+
+* Mon Oct 21 2024 Lucas Pereira  - 
11.51.5-20241024
+- sql: Improve casting to generic decimal type by choosing a better fit for
+  precision and scale instead of defaulting to 18 and 3, respectively.
+
+* Thu Oct 17 2024 Sjoerd Mullender  - 11.51.5-20241024
+- sql: When for whatever reason the upgrade code produces an error, we now
+  exit the server.  Before the server would limp on with what is basically
+  a broken database.
+
+* Mon Oct 14 2024 stefanos mavros  - 11.51.5-20241024
+- monetdb5: The server prints out an informative message for the case of a 
graceful
+  termination.
+
+* Mon Oct  7 2024 Joeri van Ruth  - 
11.51.5-20241024
+- merovingian: Tweak socket parameters to simulate network activity on client 
connections.
+  This prevents firewalls from killing connections that seem idle but are
+  actually waiting for a long-running query. Can be controlled with a new
+  'keepalive' option to monetdbd.
+
+* Thu Sep 26 2024 Martin van Dinther  
- 11.51.5-20241024
+- sql: Improved the violation message of CHECK constraints when violated. It
+  now includes the schema name of the constraint and the check clause.
+
+* Fri Aug 23 2024 Joeri van Ruth  - 
11.51.5-20241024
+- sql: Increase the buffer size used by hot snapshot from 64kiB to 1MiB,
+  and make it configurable through setting 'hot_snapshot_buffer_size'.
+  It must be a multiple of 512.
+
 * Mon Aug 19 2024 Sjoerd Mullender  - 11.51.3-2

MonetDB: Aug2024 - Updated library versions.

2024-10-25 Thread Sjoerd Mullender via checkin-list
Changeset: 978b0dadf506 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/978b0dadf506
Modified Files:
cmake/monetdb-versions.cmake
Branch: Aug2024
Log Message:

Updated library versions.


diffs (34 lines):

diff --git a/cmake/monetdb-versions.cmake b/cmake/monetdb-versions.cmake
--- a/cmake/monetdb-versions.cmake
+++ b/cmake/monetdb-versions.cmake
@@ -44,20 +44,20 @@ set(MONETDB_VERSION "${MONETDB_VERSION_M
 # common/options and common/utils)
 set(GDK_VERSION_MAJOR "29")
 set(GDK_VERSION_MINOR "0")
-set(GDK_VERSION_PATCH "0")
+set(GDK_VERSION_PATCH "1")
 set(GDK_VERSION 
"${GDK_VERSION_MAJOR}.${GDK_VERSION_MINOR}.${GDK_VERSION_PATCH}")
 
 # version of the MAPI library (subdirectory clients/mapilib)
 set(MAPI_VERSION_MAJOR "27")
 set(MAPI_VERSION_MINOR "0")
-set(MAPI_VERSION_PATCH "0")
+set(MAPI_VERSION_PATCH "1")
 set(MAPI_VERSION 
"${MAPI_VERSION_MAJOR}.${MAPI_VERSION_MINOR}.${MAPI_VERSION_PATCH}")
 
 # version of the MONETDB5 library (subdirectory monetdb5, not including
 # extras, and tools/utils/msabaoth.[ch])
 set(MONETDB5_VERSION_MAJOR "36")
 set(MONETDB5_VERSION_MINOR "0")
-set(MONETDB5_VERSION_PATCH "1")
+set(MONETDB5_VERSION_PATCH "2")
 set(MONETDB5_VERSION 
"${MONETDB5_VERSION_MAJOR}.${MONETDB5_VERSION_MINOR}.${MONETDB5_VERSION_PATCH}")
 
 # version of the MONETDBE library (subdirectory tools/monetdbe)
@@ -75,5 +75,5 @@ set(STREAM_VERSION "${STREAM_VERSION_MAJ
 # version of the SQL library (subdirectory sql)
 set(SQL_VERSION_MAJOR "15")
 set(SQL_VERSION_MINOR "0")
-set(SQL_VERSION_PATCH "1")
+set(SQL_VERSION_PATCH "2")
 set(SQL_VERSION 
"${SQL_VERSION_MAJOR}.${SQL_VERSION_MINOR}.${SQL_VERSION_PATCH}")
___
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org


MonetDB: Aug2024 - Moved contents of ChangeLog.Aug2024 to MonetD...

2024-10-25 Thread Sjoerd Mullender via checkin-list
Changeset: ab5d60be21cd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ab5d60be21cd
Modified Files:
MonetDB.spec
debian/changelog
misc/packages/deb/changelog
misc/packages/rpm/changelog
monetdb5/ChangeLog-Archive
monetdb5/ChangeLog.Aug2024
sql/ChangeLog-Archive
sql/ChangeLog.Aug2024
tools/merovingian/ChangeLog-Archive
tools/merovingian/ChangeLog.Aug2024
Branch: Aug2024
Log Message:

Moved contents of ChangeLog.Aug2024 to MonetDB.spec, debian/changelog and 
ChangeLog-Archive.


diffs (truncated from 418 to 300 lines):

diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -95,7 +95,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/Aug2024/MonetDB-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Aug2024-SP1/MonetDB-%{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
@@ -990,6 +990,57 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd
 %endif
 
 %changelog
+* Thu Oct 24 2024 Sjoerd Mullender  - 11.51.5-20241024
+- Rebuilt.
+- GH#7281: UDFs defined at compile time in a user schema should not become
+  system functions
+- GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW`
+- GH#7567: creating remote table from subquery crashes the server
+- GH#7569: Column of temporary table changes when another is updated
+- GH#7570: BUG in the "str_to_timestamp" function
+- GH#7571: Crash when integer overflow in `ORDER BY`
+- GH#7572: column max length is not stored as specified and accepted at
+  creation time
+- GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with
+  restart.
+- GH#7576: unescaping UTF-16 code units goes wrong in json.text
+- GH#7577: Crash when using `CHECK` constraint
+- GH#7580: statistics optimizer handles date difference incorrectly
+- GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN
+  EXISTS (..)
+- GH#7583: Query slowdown after deleting rows from large table
+- GH#7584: SO_KEEPALIVE should be configured sensibly
+- GH#7585: rel2bin_join: Assertion `sql->session->status == -10' failed.
+- GH#7587: Line/row numbers get out of sync with COPY INTO .. BEST EFFORT
+
+* Mon Oct 21 2024 Lucas Pereira  - 
11.51.5-20241024
+- sql: Improve casting to generic decimal type by choosing a better fit for
+  precision and scale instead of defaulting to 18 and 3, respectively.
+
+* Thu Oct 17 2024 Sjoerd Mullender  - 11.51.5-20241024
+- sql: When for whatever reason the upgrade code produces an error, we now
+  exit the server.  Before the server would limp on with what is basically
+  a broken database.
+
+* Mon Oct 14 2024 stefanos mavros  - 11.51.5-20241024
+- monetdb5: The server prints out an informative message for the case of a 
graceful
+  termination.
+
+* Mon Oct  7 2024 Joeri van Ruth  - 
11.51.5-20241024
+- merovingian: Tweak socket parameters to simulate network activity on client 
connections.
+  This prevents firewalls from killing connections that seem idle but are
+  actually waiting for a long-running query. Can be controlled with a new
+  'keepalive' option to monetdbd.
+
+* Thu Sep 26 2024 Martin van Dinther  
- 11.51.5-20241024
+- sql: Improved the violation message of CHECK constraints when violated. It
+  now includes the schema name of the constraint and the check clause.
+
+* Fri Aug 23 2024 Joeri van Ruth  - 
11.51.5-20241024
+- sql: Increase the buffer size used by hot snapshot from 64kiB to 1MiB,
+  and make it configurable through setting 'hot_snapshot_buffer_size'.
+  It must be a multiple of 512.
+
 * Mon Aug 19 2024 Sjoerd Mullender  - 11.51.3-20240819
 - Rebuilt.
 - GH#7562: Assertion failure when comparing `INTERVAL` value
diff --git a/debian/changelog b/debian/changelog
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,75 @@
+monetdb (11.51.5) unstable; urgency=low
+
+  * Rebuilt.
+  * GH#7281: UDFs defined at compile time in a user schema should not become
+system functions
+  * GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW`
+  * GH#7567: creating remote table from subquery crashes the server
+  * GH#7569: Column of temporary table changes when another is updated
+  * GH#7570: BUG in the "str_to_timestamp" function
+  * GH#7571: Crash when integer overflow in `ORDER BY`
+  * GH#7572: column max length is not stored as specified and accepted at
+creation time
+  * GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with
+restart.
+  * GH#7576: unescaping UTF-16 code units goes wrong in json.text
+  * GH#7577: Crash when using `CHECK` constraint
+  * GH#7580: statistics optimizer handles date difference incorrectly
+  * GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN
+EXISTS (..)
+  

MonetDB: json-extend - make the parser reentrant, i.e. get rid o...

2024-10-25 Thread Yunus Koning via checkin-list
Changeset: ac00dcf01c75 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ac00dcf01c75
Modified Files:
monetdb5/modules/atoms/pg_jsonpath/jsonpath.h
monetdb5/modules/atoms/pg_jsonpath/jsonpath_gram.y
monetdb5/modules/atoms/pg_jsonpath/jsonpath_internal.h
monetdb5/modules/atoms/pg_jsonpath/jsonpath_scan.l
Branch: json-extend
Log Message:

make the parser reentrant, i.e. get rid of global variables


diffs (truncated from 793 to 300 lines):

diff --git a/monetdb5/modules/atoms/pg_jsonpath/jsonpath.h 
b/monetdb5/modules/atoms/pg_jsonpath/jsonpath.h
--- a/monetdb5/modules/atoms/pg_jsonpath/jsonpath.h
+++ b/monetdb5/modules/atoms/pg_jsonpath/jsonpath.h
@@ -174,8 +174,6 @@ extern const char *jspOperationName(Json
  * Parsing support data structures.
  */
 
-extern struct Node * init_escontext(char* errmsg);
-
 extern JsonPathParseResult *parsejsonpath(const char *str, int len,

allocator* sa, char* errmsg);
 /*
diff --git a/monetdb5/modules/atoms/pg_jsonpath/jsonpath_gram.y 
b/monetdb5/modules/atoms/pg_jsonpath/jsonpath_gram.y
--- a/monetdb5/modules/atoms/pg_jsonpath/jsonpath_gram.y
+++ b/monetdb5/modules/atoms/pg_jsonpath/jsonpath_gram.y
@@ -15,6 +15,8 @@
  */
 
 
+typedef void* yyscan_t;
+
 #include "jsonpath_internal.h"
 
 static JsonPathParseItem *makeItemType(struct Node *escontext, 
JsonPathItemType type);
@@ -50,9 +52,10 @@ static bool makeItemLikeRegex(JsonPathPa
 %}
 
 /* BISON Declarations */
-%pure-parser
+%define api.pure full
 %expect 0
 %name-prefix="jsonpath_yy"
+%param {yyscan_t scanner}
 %parse-param {JsonPathParseResult **result}
 %parse-param {struct Node *escontext}
 %lex-param {JsonPathParseResult **result}
diff --git a/monetdb5/modules/atoms/pg_jsonpath/jsonpath_internal.h 
b/monetdb5/modules/atoms/pg_jsonpath/jsonpath_internal.h
--- a/monetdb5/modules/atoms/pg_jsonpath/jsonpath_internal.h
+++ b/monetdb5/modules/atoms/pg_jsonpath/jsonpath_internal.h
@@ -14,6 +14,10 @@
 #ifndef JSONPATH_INTERNAL_H
 #define JSONPATH_INTERNAL_H
 
+#include "postgres_defines.h"
+#include "postgres_defines_internal.h"
+
+#include "jsonpath.h"
 
 /* struct JsonPathString is shared between scan and gram */
 typedef struct JsonPathString
@@ -23,19 +27,17 @@ typedef struct JsonPathString
int total;
 } JsonPathString;
 
-#include "jsonpath.h"
-#include "postgres_defines_internal.h"
 #include "jsonpath_gram.h"
 
-#define YY_USER_INIT (void) result;
-#define YY_DECL extern int jsonpath_yylex(YYSTYPE *yylval_param, \
+#define YY_DECL extern int jsonpath_yylex(YYSTYPE *yylval_param, yyscan_t 
yyscanner, \
  JsonPathParseResult 
**result, \
  struct Node 
*escontext)
 YY_DECL;
-extern int jsonpath_yyparse(JsonPathParseResult **result,
-struct Node 
*escontext);
-extern void jsonpath_yyerror(JsonPathParseResult **result,
+extern void jsonpath_yyerror(yyscan_t yyscanner, JsonPathParseResult **result,
 struct Node *escontext,
 const char *message);
 
+extern int jsonpath_yyparse(yyscan_t yyscanner, JsonPathParseResult 
**result,
+struct Node 
*escontext);
+
 #endif /* JSONPATH_INTERNAL_H 
*/
diff --git a/monetdb5/modules/atoms/pg_jsonpath/jsonpath_scan.l 
b/monetdb5/modules/atoms/pg_jsonpath/jsonpath_scan.l
--- a/monetdb5/modules/atoms/pg_jsonpath/jsonpath_scan.l
+++ b/monetdb5/modules/atoms/pg_jsonpath/jsonpath_scan.l
@@ -19,29 +19,27 @@
  * NB: include jsonpath_gram.h only AFTER including jsonpath_internal.h,
  * because jsonpath_internal.h contains the declaration for JsonPathString.
  */
-#include "jsonpath_internal.h"
-#include "jsonpath_gram.h"
+
+/* struct JsonPathString is shared between scan and gram */
 }
 
 %{
-static JsonPathString scanstring;
 
-/* Handles to the buffer that the lexer uses internally */
-static YY_BUFFER_STATE scanbufhandle;
-static char *scanbuf;
-static int scanbuflen;
+#include "jsonpath_internal.h"
 
-static void addstring(bool init, char *s, int l);
-static void addchar(bool init, char c);
-static enum yytokentype checkKeyword(void);
-static bool parseUnicode(char *s, int l, struct Node *escontext);
-static bool parseHexChar(char *s, struct Node *escontext);
-
-#define palloc GDKmalloc
-#define repalloc   GDKrealloc
-#define pfree  GDKfree
+static void addstring(yyscan_t yyscanner, bool init, char *s, int l);
+static void addchar(yyscan_t yyscanner, bool init, char c);
+static enum yytokentype checkKeyword(yyscan_t yyscanner);
+static bool parseUnicode(yyscan_t yyscanner, char *s, int l, struct Node 
*escontext);
+static bo

MonetDB: Aug2024 - Single value should return NULL always. Fixes...

2024-10-25 Thread Lucas Pereira via checkin-list
Changeset: 9bb6f9520673 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9bb6f9520673
Modified Files:
sql/backends/monet5/sql_rank.c
sql/test/BugTracker-2024/Tests/bin_find_smallest_column-Bug-7482.test
Branch: Aug2024
Log Message:

Single value should return NULL always. Fixes #7588


diffs (31 lines):

diff --git a/sql/backends/monet5/sql_rank.c b/sql/backends/monet5/sql_rank.c
--- a/sql/backends/monet5/sql_rank.c
+++ b/sql/backends/monet5/sql_rank.c
@@ -1682,8 +1682,6 @@ do_stddev_and_variance(Client cntxt, Mal
msg = createException(SQL, op, GDK_EXCEPTION);
} else {
dbl *res = getArgReference_dbl(stk, pci, 0);
-   ValRecord *input1 = &(stk)->stk[(pci)->argv[1]];
-
switch (tpe) {
case TYPE_bte:
case TYPE_sht:
@@ -1694,7 +1692,7 @@ do_stddev_and_variance(Client cntxt, Mal
 #endif
case TYPE_flt:
case TYPE_dbl:
-   *res = VALisnil(input1) ? dbl_nil : 0;
+   *res = dbl_nil;
break;
default:
msg = createException(SQL, op, SQLSTATE(42000) 
"%s not available for %s", op, ATOMname(tpe));
diff --git 
a/sql/test/BugTracker-2024/Tests/bin_find_smallest_column-Bug-7482.test 
b/sql/test/BugTracker-2024/Tests/bin_find_smallest_column-Bug-7482.test
--- a/sql/test/BugTracker-2024/Tests/bin_find_smallest_column-Bug-7482.test
+++ b/sql/test/BugTracker-2024/Tests/bin_find_smallest_column-Bug-7482.test
@@ -1,5 +1,5 @@
 query R nosort
 SELECT var_samp ( '12' ) OVER ( ORDER BY CAST ( ( CASE WHEN ( 99 ) THEN COUNT 
( * ) ELSE CASE WHEN 1 THEN ( FALSE ) END END ) AS BIGINT ) )
 
-0.000
+NULL
 
___
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org


MonetDB: strimps_v3 - Merge with default branch

2024-10-25 Thread Lucas Pereira via checkin-list
Changeset: 65afca2a7f6c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/65afca2a7f6c
Branch: strimps_v3
Log Message:

Merge with default branch


diffs (truncated from 83747 to 300 lines):

diff --git a/.hgeol b/.hgeol
--- a/.hgeol
+++ b/.hgeol
@@ -13,8 +13,10 @@
 **.gz  = BIN
 **.ico = BIN
 **.jpg = BIN
+**.lz4 = BIN
 **.pdf = BIN
 **.png = BIN
+**.xz  = BIN
 **.zip = BIN
 
 # all the rest is text
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -831,3 +831,6 @@ e1e9e22bf3d734dc50b56151c657a57c18f56561
 cde7d8f7c99540a8c95856df052a9f123b0c1643 Dec2023_11
 cde7d8f7c99540a8c95856df052a9f123b0c1643 Dec2023_SP4_release
 ae474f7fda0a3f2ebefc6c0b2cd969ef0854fad1 Aug2024_1
+dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_3
+dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_release
+ab5d60be21cd1c65e9de476d71a86c2995f70785 Aug2024_5
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -57,7 +57,7 @@ monetdb_default_compiler_options()
 
 include(monetdb-defines)
 
-# required for symbol existance tests
+# required for symbol existence tests
 if(${CMAKE_SYSTEM_NAME} STREQUAL "Linux")
   add_definitions(-D_XOPEN_SOURCE -D_GNU_SOURCE)
   set(CMAKE_REQUIRED_DEFINITIONS "${CMAKE_REQUIRED_DEFINITIONS} -D_GNU_SOURCE")
diff --git a/ChangeLog b/ChangeLog
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,9 @@
 # ChangeLog file for devel
 # This file is updated with Maddlog
 
+* Mon Sep 16 2024 Joeri van Ruth 
+- Hot snapshot: allow member files larger than 64 GiB. By member files we mean
+  the files inside the resulting .tar file, not the tar file itself. Huge 
member
+  files are written using a GNU tar extension to the original tar format, which
+  doesn't support more than 8 GiB.
+
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -36,7 +36,7 @@
 # for Enterprise Linux (EPEL) repository is not available, you can
 # disable its use by providing rpmbuild or mock with the "--without
 # epel" option.
-# If the EPEL repository is availabe, or if building for Fedora, most
+# If the EPEL repository is available, or if building for Fedora, most
 # optional sub packages can be built.  We indicate that here by
 # setting the macro fedpkgs to 1.  If the EPEL repository is not
 # available and we are not building for Fedora, we set fedpkgs to 0.
@@ -95,7 +95,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/Aug2024/MonetDB-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Aug2024-SP1/MonetDB-%{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
@@ -815,7 +815,6 @@ developer, but if you do want to test, t
 
 %files testing-python
 %defattr(-,root,root)
-%{_bindir}/Mconvert.py
 %{_bindir}/Mtest.py
 %{_bindir}/Mz.py
 %{_bindir}/mktest.py
@@ -976,6 +975,7 @@ fi
 rm 
"${RPM_BUILD_ROOT}"%{_bindir}/{M{convert.py,test.py,z.py},bincopydata,example_proxy,m{alsample.pl,client,ktest.py,onetdb{,d},s{erver5,qldump},urltest},s{ample{0,1,4},hutdowntest,mack0{0,1},ql{logictest.py,sample.p{hp,l}},treamcat},testcondvar}
 rm -r "${RPM_BUILD_ROOT}"%{_datadir}/doc/MonetDB*
 rm "${RPM_BUILD_ROOT}"%{_datadir}/selinux/*/monetdb.pp
+rm -r "${RPM_BUILD_ROOT}"%{_datadir}/monetdb
 rm -r "${RPM_BUILD_ROOT}"%{_includedir}/monetdb
 rm "${RPM_BUILD_ROOT}"%{_libdir}/*.so 
"${RPM_BUILD_ROOT}"%{_libdir}/libmonetdbe.so.*
 rm -r "${RPM_BUILD_ROOT}"%{_libdir}/pkgconfig
@@ -989,6 +989,62 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd
 %endif
 
 %changelog
+* Thu Oct 24 2024 Sjoerd Mullender  - 11.51.5-20241024
+- Rebuilt.
+- GH#7281: UDFs defined at compile time in a user schema should not become
+  system functions
+- GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW`
+- GH#7567: creating remote table from subquery crashes the server
+- GH#7569: Column of temporary table changes when another is updated
+- GH#7570: BUG in the "str_to_timestamp" function
+- GH#7571: Crash when integer overflow in `ORDER BY`
+- GH#7572: column max length is not stored as specified and accepted at
+  creation time
+- GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with
+  restart.
+- GH#7576: unescaping UTF-16 code units goes wrong in json.text
+- GH#7577: Crash when using `CHECK` constraint
+- GH#7580: statistics optimizer handles date difference incorrectly
+- GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN
+  EXISTS (..)
+- GH#7583: Query slowdown after deleting rows from large table
+- GH#7584: SO_KEEPALIVE should be configured sensibly
+- GH#7585: rel2bin_join: Assertion `sql->session->status == -10' failed.
+- GH#7587: Line/row numbers get out of sync with COPY INTO .. BEST EFFORT
+
+* Mon Oct 21 2024 Lucas Pereira  - 
11.51.5-20241024
+- sql: Improve casting to generic decimal type by choosing

MonetDB: resource_management - put default InstrRecord size on f...

2024-10-25 Thread svetlin via checkin-list
Changeset: 2884c10a99b0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2884c10a99b0
Modified Files:
monetdb5/mal/mal_instruction.c
Branch: resource_management
Log Message:

put default InstrRecord size on freelist only


diffs (25 lines):

diff --git a/monetdb5/mal/mal_instruction.c b/monetdb5/mal/mal_instruction.c
--- a/monetdb5/mal/mal_instruction.c
+++ b/monetdb5/mal/mal_instruction.c
@@ -479,7 +479,9 @@ freeInstruction(InstrPtr p)
 {
if (p && p->blk && p->blk->ma) {
// size_t sz = (p->maxarg - 1)*(sizeof(p->argv[0])) + 
(sizeof(InstrRecord));
-   sa_free(p->blk->ma, p);
+   // only free default size
+   if (p->maxarg == 8)
+   sa_free(p->blk->ma, p);
}
//GDKfree(p);
 }
@@ -489,7 +491,9 @@ freeInstructionX(InstrPtr p, MalBlkPtr m
 {
if (p && mb && mb->ma) {
// size_t sz = (p->maxarg - 1)*(sizeof(p->argv[0])) + 
(sizeof(InstrRecord));
-   sa_free(mb->ma, p);
+   // only free default size
+   if (p->maxarg == 8)
+   sa_free(mb->ma, p);
}
 }
 
___
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org