MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: adec2c7a34ea for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/adec2c7a34ea
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (20 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,16 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Tue Nov  9 2021 Pedro Ferreira 
+- The method to compute the 'side_effect' effect property was changed
+  for SQL functions defined in the backend engine (eg. ``CREATE FUNCTION 
+  ... EXTERNAL NAME "module"."function"''). It was changed from being
+  computed by the SQL layer to the backend engine itself. As a consequence,
+  the computed 'side_effect' value may be different, thus bringing
+  incompatibilities. After an upgrade, if a 'side_effect' incompatibility
+  arises, either the 'side_effect' value in the backend should be changed or
+  the function should be re-created in SQL.
+
 * Thu Nov  4 2021 Martin van Dinther 
 - Removed deprecated system view sys.systemfunctions. It was marked
   as deprecated from release Apr2019 (11.33.3).  Use query:
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: 926d0d52cb8c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/926d0d52cb8c
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (15 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,11 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Tue Oct 12 2021 Pedro Ferreira 
+- Many improvements were done for REMOTE table plans. As a consequence,
+  master or slave servers from this feature release are not compatible
+  with older releases.
+
 * Tue Sep  7 2021 Sjoerd Mullender 
 - The view sys.ids has been changed to give more information about the
   objects in the system.  In particular, there is an extra column
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: fabdb8a19541 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fabdb8a19541
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (15 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,11 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Wed Apr 28 2021 Pedro Ferreira 
+- Merge statements could not produce correct results on complex join
+  conditions, so a renovation was made. As a consequence, subqueries
+  now have to be disabled on merge join conditions.
+
 * Tue Mar 16 2021 Pedro Ferreira 
 - Use of CTEs inside UPDATE and DELETE statements are now more
   restrict. Previously they could be used without any extra specification
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: 2e078ca5094d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2e078ca5094d
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (21 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -37,3 +37,17 @@
 
 * Tue Jun 16 2020 Pedro Ferreira 
 - Removed obsolete json.output(json) function.
+
+* Tue Jun 30 2020 Pedro Ferreira 
+- Removed compability between interval types and other numeric types in
+  favor for a more strict SQL standard compliance. This means operations
+  between temporal types and other numeric types such as INT and 
+  DECIMAL are no longer possible, instead use interval types.
+  e.g. SELECT date '2020-01-01' + 1; now gives the error. Instead do:
+  SELECT date '2020-01-01' + interval '1' day; if 1 was meant to be a
+  day interval.
+  Setting an interval variable such as the session's current timezone
+  with a number e.g. SET current_timezone = 1; is no longer possible.
+  Instead do SET current_timezone = interval '1' hour;
+  Casting between interval and other numeric types is no longer possible
+  as well, because they are not compatible.
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: 73d89253bc47 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=73d89253bc47
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (38 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,3 +1,34 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Tue Jun  2 2020 Pedro Ferreira 
+- Removed '@' syntax used to refer into a variable in a query. It
+  was a non-standard method, which was replaced by a schema addition to
+  variables. Variables in the global scope now have schema. All default
+  global variables are set under schema "sys". However variables
+  inside PSM don't have a schema, because there are no transaction
+  semantics inside PSM at the moment.
+- Removed declared variables and tables from the global scope. They were
+  transaction agnostic and incompatible with the SQL standard, i.e. they
+  are valid exclusively under PSM (e.g. functions, procedures and 
+  triggers).
+- Scoping semantics were added for both variables and tables. Variables
+  with the same name at a query are now resolved under the following
+  precedence rules:
+1. Tables, Views and CTEs at the FROM clause.
+2. Variable declared in the body of function/procedure, i.e. local
+   variable.
+3. Function/procedure parameter.
+4. Variable from the global scope.
+  Tables with the same name now have the following precedence rules at a
+  SQL query: 
+1. Table declared in the body of function/procedure, ie local table.
+2. Temporary table.
+3. Table from the current session schema.
+  This means the query: SELECT * FROM "keys"; will list keys from
+  temporary tables instead of persisted ones, because "keys" table
+  is available for both "sys" and "tmp" schemas.
+- The table returning function "var" was extended with more details
+  about globally declared variables, namely their schema, type and
+  current value.
+
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: 6904bf4cd5c0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6904bf4cd5c0
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (21 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,17 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Wed Jan 29 2020 Pedro Ferreira 
+- Implemented 'covar_pop' and 'covar_samp' aggregate functions, as well
+  as their window function counterparts. Implemented 'stddev_samp',
+  'stddev_pop', 'var_samp', 'var_pop', 'corr' and 'group_concat'
+  window function correspondents.
+- Extended SQL catalog with CREATE WINDOW syntax for user-defined 
+  SQL:2003 window functions. At the moment, window functions must be
+  defined on the backend engine, ie on this case MAL. At the current
+  implementation, the backend code generation, creates two additional
+  columns of lng type with the start and end offsets for each row.
+
 * Thu Jan 23 2020 Pedro Ferreira 
 - Added sys.sleep(int n) procedure, which makes the client's thread to
   sleep for n milliseconds. Also added the function version, where it
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: 28f3e2ece26c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=28f3e2ece26c
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (15 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,11 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Thu Jan 23 2020 Pedro Ferreira 
+- Added sys.sleep(int n) procedure, which makes the client's thread to
+  sleep for n milliseconds. Also added the function version, where it
+  returns the input value as result.
+
 * Tue Dec 17 2019 Pedro Ferreira 
 - Added prepared_statements_args view, which details the arguments for
   the prepared statements created in the current session.
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog and tests approval

[Pedro Ferreira]

Changeset: 2f7b76be7873 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2f7b76be7873
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
sql/ChangeLog
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/deallocate.sql
sql/test/miscellaneous/Tests/deallocate.stable.err
sql/test/miscellaneous/Tests/deallocate.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: default
Log Message:

Updated ChangeLog and tests approval


diffs (truncated from 509 to 300 lines):

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
@@ -11757,6 +11757,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",   "password", "pattern sql.password(user:str):str ",  
"db_password_wrap;","Return password hash of user"  ]
 [ "sql",   "percent_rank", "pattern sql.percent_rank(b:any_1, p:bit, 
o:bit):dbl ", "SQLpercent_rank;", "return the percentage into the total 
number of groups for each row"]
 [ "sql",   "prelude",  "pattern sql.prelude():void ",  "SQLprelude;",  
""  ]
+[ "sql",   "prepared_statements",  "pattern sql.prepared_statements() 
(sessionid:bat[:int], user:bat[:str], statementid:bat[:int], 
statementt:bat[:str], createdd:bat[:timestamp]) ",  
"SQLsession_prepared_statements;",  "Available prepared statements in the 
current session"  ]
 [ "sql",   "prod", "pattern sql.prod(b:bte, s:lng, e:lng):lng ",   
"SQLprod;", "return the product of groups"  ]
 [ "sql",   "prod", "pattern sql.prod(b:dbl, s:lng, e:lng):dbl ",   
"SQLprod;", "return the product of groups"  ]
 [ "sql",   "prod", "pattern sql.prod(b:flt, s:lng, e:lng):dbl ",   
"SQLprod;", "return the product of groups"  ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128 
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -16163,6 +16163,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",   "password", "pattern sql.password(user:str):str ",  
"db_password_wrap;","Return password hash of user"  ]
 [ "sql",   "percent_rank", "pattern sql.percent_rank(b:any_1, p:bit, 
o:bit):dbl ", "SQLpercent_rank;", "return the percentage into the total 
number of groups for each row"]
 [ "sql",   "prelude",  "pattern sql.prelude():void ",  "SQLprelude;",  
""  ]
+[ "sql",   "prepared_statements",  "pattern sql.prepared_statements() 
(sessionid:bat[:int], user:bat[:str], statementid:bat[:int], 
statementt:bat[:str], createdd:bat[:timestamp]) ",  
"SQLsession_prepared_statements;",  "Available prepared statements in the 
current session"  ]
 [ "sql",   "prod", "pattern sql.prod(b:bte, s:lng, e:lng):hge ",   
"SQLprod;", "return the product of groups"  ]
 [ "sql",   "prod", "pattern sql.prod(b:bte, s:lng, e:lng):lng ",   
"SQLprod;", "return the product of groups"  ]
 [ "sql",   "prod", "pattern sql.prod(b:dbl, s:lng, e:lng):dbl ",   
"SQLprod;", "return the product of groups"  ]
diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -2,9 +2,11 @@
 # This file is updated with Maddlog
 
 * Fri Dec 13 2019 Pedro Ferreira 
+- Added sys.prepared_statements view, which depicts the available prepared
+  statements in the current session.
 - Added deallocate statements with the syntax 'DEALLOCATE [PREPARE]
-  { number | ALL }', to close an existing prepared statement or all, 
-  through the SQL layer. Previously this feature was available via MAPI 
+  { number | ALL }', to close an existing prepared statement or all,
+  through the SQL layer. Previously this feature was available via MAPI
   exclusively with the "release" command.
 
 * Wed Nov 27 2019 Pedro Ferreira 
diff --git a/sql/test/emptydb/Tests/check.stable.out 
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -118,6 +118,7 @@ stdout of test 'check` in directory 'sql
 \dSv sys.geometry_columns
 \dSv sys.ids
 \dSv sys.optimizers
+\dSv sys.prepared_statements
 \dSv sys.querylog_calls
 \dSv sys.querylog_catalog
 \dSv sys.querylog_history
@@ -217,6 +218,7 @@ stdout of test 'check` in directory 'sql
 \dSf sys."optimizers"
 \dSf sys."password_hash"
 \dSf sys."pause"
+\dSf sys."prepared_statements"
 \dSf sys."quantile"
 \dSf sys."quantile_avg"
 \dSf sys."querycache"
@@ -436,6 +438,7 @@ SYSTEM VIEW  sys.environment
 SYSTEM VIEW  sys.geometry_columns
 SYSTEM VIEW  sys.ids
 SYSTEM VIEW  

MonetDB: default - Updated ChangeLog and updated test

[Pedro Ferreira]

Changeset: cf9bf545606d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cf9bf545606d
Modified Files:
sql/ChangeLog
sql/test/miscellaneous/Tests/deallocate.sql
sql/test/miscellaneous/Tests/deallocate.stable.err
Branch: default
Log Message:

Updated ChangeLog and updated test


diffs (57 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,12 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Fri Dec 13 2019 Pedro Ferreira 
+- Added deallocate statements with the syntax 'DEALLOC[ATE] [PREPARE]
+  { number | ALL }', to close an existing prepared statement or all, 
+  through the SQL layer. Previously this feature was available via MAPI 
+  exclusively with the "release" command.
+
 * Wed Nov 27 2019 Pedro Ferreira 
 - Implemented ROLLUP, CUBE and GROUPING SETS from SQL:1999. They define
   grouping subsets used at GROUP BY clause in order to compute partial
diff --git a/sql/test/miscellaneous/Tests/deallocate.sql 
b/sql/test/miscellaneous/Tests/deallocate.sql
--- a/sql/test/miscellaneous/Tests/deallocate.sql
+++ b/sql/test/miscellaneous/Tests/deallocate.sql
@@ -1,10 +1,13 @@
 prepare select "system" or ? from _tables WHERE false;
-
 EXEC **(false);
 dealloc **;
 exec **(false); --error, the last prepared statement, no longer exists;
+DEALLOCATE **; --error, last prepared statement already closed
 
 prepare select "system" or ? from _tables WHERE false;
 execute **(false);
 DEALLOCATE prepare all;
 EXECUTE **(false); --error, the last prepared statement, no longer exists;
+
+DEALLOCATE 10; --error, it doesn't exist
+DEALLOCATE ALL;
diff --git a/sql/test/miscellaneous/Tests/deallocate.stable.err 
b/sql/test/miscellaneous/Tests/deallocate.stable.err
--- a/sql/test/miscellaneous/Tests/deallocate.stable.err
+++ b/sql/test/miscellaneous/Tests/deallocate.stable.err
@@ -30,10 +30,18 @@ MAPI  = (monetdb) /var/tmp/mtest-170269/
 QUERY = exec  3(false); --error, the last prepared statement, no longer exists;
 ERROR = !No prepared statement with id: 3
 CODE  = 07003
-MAPI  = (monetdb) /var/tmp/mtest-170269/.s.monetdb.35105
+MAPI  = (monetdb) /var/tmp/mtest-174632/.s.monetdb.34143
+QUERY = DEALLOCATE  3; --error, last prepared statement already closed
+ERROR = !No prepared statement with id: 3
+CODE  = 07003
+MAPI  = (monetdb) /var/tmp/mtest-174156/.s.monetdb.39989
 QUERY = EXECUTE  5(false); --error, the last prepared statement, no longer 
exists;
 ERROR = !No prepared statement with id: 5
 CODE  = 07003
+MAPI  = (monetdb) /var/tmp/mtest-175193/.s.monetdb.31597
+QUERY = DEALLOCATE 10; --error, it doesn't exist
+ERROR = !No prepared statement with id: 10
+CODE  = 07003
 
 # 13:56:29 >  
 # 13:56:29 >  "Done."
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: fc8a04a82937 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fc8a04a82937
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (18 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,14 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Wed Nov 27 2019 Pedro Ferreira 
+- Implemented ROLLUP, CUBE and GROUPING SETS from SQL:1999. They define
+  grouping subsets used at GROUP BY clause in order to compute partial
+  groupings. At the same time, the GROUPING aggregate was added. This
+  aggregate is a bitmask identifying the grouping columns not present
+  in the generated grouping row when used with the operators described
+  above.
+
 * Tue Nov 19 2019 Pedro Ferreira 
 - Updated user session procedures by adding te possibility to set properties
   based on a session identifier. The optimizer pipeline, number of worker
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog

[Pedro Ferreira]

Changeset: cfafb1ae6f55 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cfafb1ae6f55
Modified Files:
monetdb5/ChangeLog
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog


diffs (32 lines):

diff --git a/monetdb5/ChangeLog b/monetdb5/ChangeLog
--- a/monetdb5/ChangeLog
+++ b/monetdb5/ChangeLog
@@ -1,6 +1,14 @@
 # ChangeLog file for MonetDB5
 # This file is updated with Maddlog
 
+* Tue Nov 19 2019 Pedro Ferreira 
+- Added session identifier, number of workers and memory claim to the
+  sysmon queue. 
+- The worker (number of threads), memory (in MB) and optimizer pipeline 
+  limits can now be set per user session basis. The query and session
+  timeouts are now set in seconds.
+- With required privileges an user can set resource limits for a session.
+
 * Wed Nov 13 2019 Sjoerd Mullender 
 - There are now versions of group.(sub)group(done) that produce a single
   output containing just the groups.
diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,3 +1,10 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Tue Nov 19 2019 Pedro Ferreira 
+- Updated user session procedures by adding te possibility to set properties
+  based on a session identifier. The optimizer pipeline, number of worker
+  threads and memory limits can be set per user session. As a consequence,
+  the procedures sys.settimeout(bigint), sys.settimeout(bigint,bigint)
+  and sys.session(bigint) are now deprecated.
+
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog.

[Pedro Ferreira]

Changeset: 6b3ebb1dab8e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6b3ebb1dab8e
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog.


diffs (18 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,14 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Fri Jul 12 2019 Pedro Ferreira 
+- Added sys.deltas ("schema" string, "table" string, "column" string)
+  returns table ("values" bigint) system function which returns a single
+  column with 4 values: the count of the RDONLY, RD_INS and RD_UPD_ID
+  deltas of the column itself, as well as the level of the current
+  transaction in the transaction level tree. It should be used for
+  debugging purposes only.
+
 * Mon May  6 2019 Pedro Ferreira 
 - Added "VALUES row_list" statement as a top SQL projection statement.
 
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog.

[Pedro Ferreira]

Changeset: aab0913b3954 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=aab0913b3954
Modified Files:
monetdb5/ChangeLog
tools/merovingian/ChangeLog
Branch: default
Log Message:

Updated ChangeLog.


diffs (27 lines):

diff --git a/monetdb5/ChangeLog b/monetdb5/ChangeLog
--- a/monetdb5/ChangeLog
+++ b/monetdb5/ChangeLog
@@ -1,6 +1,11 @@
 # ChangeLog file for MonetDB5
 # This file is updated with Maddlog
 
+* Thu May  2 2019 Pedro Ferreira 
+- Added "mapi_ipv6" property to monet_options to force ipv6 address
+  binding only.  This property is inherited while forking from
+  monetdbd if it is also set there.
+
 * Thu Apr 18 2019 Sjoerd Mullender 
 - Removed (bat)calc.between_symmetric and changed (bat)calc.between
   by adding a number of extra arguments, all of type :bit: symmetric,
diff --git a/tools/merovingian/ChangeLog b/tools/merovingian/ChangeLog
--- a/tools/merovingian/ChangeLog
+++ b/tools/merovingian/ChangeLog
@@ -1,3 +1,8 @@
 # ChangeLog file for sql/src/backends/monet5/merovingian
 # This file is updated with mchangelog
 
+* Thu May  2 2019 Pedro Ferreira 
+- Added ipv6 property to monetdbd properties to force IPv6 addresses
+  binding only.  By default this property is false to allow IPv4
+  addresses as well.
+
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated Changelog.

[Pedro Ferreira]

Changeset: a320e5f0a5f5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a320e5f0a5f5
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated Changelog.


diffs (18 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,14 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Thu Dec 20 2018 Pedro Ferreira 
+- Allow usage of custom expressions in GROUP BY and PARTITION BY
+  clauses. The same expressions can be used in the projection phase as
+  long as it is exactly the same used in the grouping clause (textual
+  lookup is performed). As an example the query:
+  SELECT col1*2 FROM t1 GROUP BY col1*2; is correct, while
+  SELECT sin(col1+5) FROM t1 GROUP BY col1*2; is wrong.
+
 * Mon Dec 17 2018 Pedro Ferreira 
 - Implemented merge statements from SQL:2003 standard. Using a source
   relation R, a target table T is updating depending on the result of
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated changelog and fixed typo.

[Pedro Ferreira]

Changeset: 7a848287c67b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7a848287c67b
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated changelog and fixed typo.


diffs (42 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,29 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Mon Nov 26 2018 Pedro Ferreira 
+- Extended windowing functions catalog with SQL standard semantics.
+  Standard aggregation functions can now be used in windowing
+  functions: (avg,max,min,sum,prod,count). Other windowing specific
+  functions were also implemented: (percent_rank,cume_dist,ntile,
+  lag,lead,first_value,last_value,nth_value).
+- The standard frame specification was implemented for aggregation
+  functions as well as first_value, last_value and nth_value
+  functions. The available frames are rows, range and groups.
+  Bounds can be unbounded (partition limit), the current row, a fixed
+  number of rows (constant), or variable (column as input).
+  (e.g SELECT COUNT(col1) OVER (PARTITION BY col2 ORDER BY col3 RANGE
+  BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM t1;).
+- Added WINDOW keyword which is optionally provided after the FROM
+  clause, with window specifications used in the projection
+  (e.g SELECT SUM(col1) OVER w1, LAST_VALUE(col2) OVER w2 FROM t1
+  WINDOW w1 AS (ROWS BETWEEN 5 PRECEDING AND 0 FOLLOWING),
+  w2 AS (w1);).
+- Our previous partitioning implementation didn’t impose order in the
+  input. With this reexamination, partitioning now imposes ascending
+  order by default, thus pairing with the industry standard
+  implementation.
+
 * Fri Nov 23 2018 Sjoerd Mullender 
 - Implemented X'...' style binary string literals.
 - Implemented U&'...' Unicode character string literals and
@@ -15,7 +38,7 @@
   in a future release.
 
 * Thu Nov  8 2018 Sjoerd Mullender 
-- Imlemented the NULLS FIRST and NULLS LAST option to ORDER BY.  The
+- Implemented the NULLS FIRST and NULLS LAST option to ORDER BY.  The
   default is NULLS FIRST for ASC(ending) and NULLS LAST for DESC(ending).
 
 * Thu Oct 18 2018 Pedro Ferreira 
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated changelog with rename-sql branch chan...

[Pedro Ferreira]

Changeset: ef7198eb51ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ef7198eb51ba
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated changelog with rename-sql branch changes.


diffs (19 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,15 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Thu Oct 18 2018 Pedro Ferreira 
+- Added possibility to rename SQL schemas, tables and columns with ALTER
+  statements:
+  > ALTER SCHEMA [ IF EXISTS ] ident RENAME TO ident
+  > ALTER TABLE [ IF EXISTS ] qname RENAME TO ident
+  > ALTER TABLE [ IF EXISTS ] qname RENAME [ COLUMN ] ident TO ident
+  Also added optional IF EXISTS clause to other existing ALTER TABLE
+  statements.
+
 * Tue Okt  9 2018 Aris Koning 
 - The sql SAMPLE syntax is extended to include an optional integral SEED
   parameter that sets the seed for the internal random number generator
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated ChangeLog.

[Pedro Ferreira]

Changeset: d73685e40d12 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d73685e40d12
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated ChangeLog.


diffs (30 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,3 +1,26 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Fri Aug  3 2018 Pedro Ferreira 
+- Extended merge tables with partitioning using a predicate:
+  > CREATE MERGE TABLE [ IF NOT EXISTS ] table_name (... columns ...)
+  [ PARTITION BY { RANGE | VALUES }
+  { ON '(' column_name ')' | USING '(' expression ')' } ]
+  The partitioning can occur by range or list of values using one of
+  the table's columns or an expression. The domain of the partitioning
+  scheme will be covered by each child table added with alter statements
+  depending if the table is partitioned by range or list of values:
+  > ALTER TABLE merge_table_name { ADD | SET } TABLE child_table_name
+  AS PARTITION IN '(' expression [ ',' ... ] ')' [ WITH NULL ]
+  > ALTER TABLE merge_table_name { ADD | SET } TABLE child_table_name
+  AS PARTITION BETWEEN { RANGE MINVALUE | expression } AND
+  { RANGE MAXVALUE | expression } [ WITH NULL ]
+  > ALTER TABLE merge_table_name { ADD | SET } TABLE child_table_name
+  AS PARTITION WITH NULL
+  When updating a single partition range/list of values, the SET
+  keyword should be used instead of ADD.
+  INSERT, UPDATE and DELETE statements are possible on partitioned
+  tables with corresponding validation on each partition domain.
+  The system tables sys.table_partitions, sys.range_partitions and
+  sys.value_partitions were added to store meta-information about
+  each existing partition.
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated changelog for the '-f rowcount' mclie...

[Ying Zhang]

Changeset: 0feacc767547 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0feacc767547
Modified Files:
ChangeLog
Branch: default
Log Message:

Updated changelog for the '-f rowcount' mclient option


diffs (13 lines):

diff --git a/ChangeLog b/ChangeLog
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,5 +1,9 @@
 # ChangeLog file for devel
 # This file is updated with Maddlog
 
+* Fri May 25 2018 Ying Zhang 
+- Added a '-f rowcount' option in mclient to repress printing the actual
+  data of a resultset, but only print the number of returned tuples
+
 * Tue Feb 13 2018 Pedro Ferreira 
 - Added support for lz4 compressed files on stream library
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Updated changelog

[Jennie Zhang]

Changeset: 5844a59a5ca1 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5844a59a5ca1
Modified Files:
sql/ChangeLog
Branch: default
Log Message:

Updated changelog


diffs (14 lines):

diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,10 @@
 # ChangeLog file for sql
 # This file is updated with Maddlog
 
+* Mon Oct 19 2015 Jennie Zhang 
+- Disallow GRANT  TO .  Only explicitly
+  created roles can be granted.
+
 * Sun Oct 18 2015 Jennie Zhang 
 - Extended grantable schema privileges: when a user is granted the
   "sysadmin" role, the user now hcan not only create schemas, but
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list