Changeset: 234695dd4e75 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/234695dd4e75
Modified Files:
README.rst
clients/mapiclient/mclient.1
documentation/source/build.rst
monetdb5/modules/kernel/bat5.c
tools/merovingian/daemon/merovingian.c
Branch: Jan2022
Log Message:
Merge with Jul2021 branch.
diffs (truncated from 675 to 300 lines):
diff --git a/MacOSX/summary.rtf b/MacOSX/summary.rtf
--- a/MacOSX/summary.rtf
+++ b/MacOSX/summary.rtf
@@ -7,4 +7,4 @@
\f0\b\fs24 \cf0 Installation was successful.
\b0 \
\
-You can now start MonetDB from your Terminal. For a tutorial how to operate
and use MonetDB, please visit {\field{\*\fldinst{HYPERLINK
"https://www.monetdb.org/Documentation/UserGuide/Tutorial"}}{\fldrslt
https://www.monetdb.org/Documentation/UserGuide/Tutorial}}.}
\ No newline at end of file
+You can now start MonetDB from your Terminal. For a tutorial how to operate
and use MonetDB, please visit {\field{\*\fldinst{HYPERLINK
"https://www.monetdb.org/Documentation/UserGuide/Tutorial"}}{\fldrslt
https://www.monetdb.org/documentation/user-guide/tutorials/voc-tutorial/}}.}
diff --git a/README.rst b/README.rst
--- a/README.rst
+++ b/README.rst
@@ -6,7 +6,7 @@ research group`__ (see https://www.monet
shifted to the spin-off company `MonetDB Solutions`__.
Via the MonetDB project we have brought the MonetDB system in open
-source, where it is accessible at https://www.monetdb.org/Downloads/.
+source, where it is accessible at https://www.monetdb.org/easy-setup/.
Even though development happens mostly in a company, the MonetDB
database system will remain open source. It is available under the
`Mozilla Public License 2.0`__.
@@ -137,7 +137,7 @@ Please note that we do not accept github
.. _github: https://github.com/MonetDB/MonetDB/issues
__ github_
-.. _developers: https://www.monetdb.org/Developers
+.. _developers: https://www.monetdb.org/documentation/dev-guide/
__ developers_
Copyright Notice
diff --git a/clients/mapiclient/mclient.1 b/clients/mapiclient/mclient.1
--- a/clients/mapiclient/mclient.1
+++ b/clients/mapiclient/mclient.1
@@ -525,7 +525,7 @@ in the above query can also be a URL. I
.IR e . g .,
.IR https://www.example.org/dumpdata.csv .
.PP
-See https://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto
+See
https://www.monetdb.org/documentation/user-guide/sql-manual/data-loading/copy-from/
for more information about the COPY INTO query.
.SH SEE ALSO
.IR msqldump (1),
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -49,18 +49,18 @@ SQLhelp sqlhelp1[] = {
"ALTER TABLE [ IF EXISTS ] qname DROP TABLE qname [ RESTRICT | CASCADE
]\n"
"ALTER TABLE [ IF EXISTS ] qname SET TABLE qname AS PARTITION
partition_spec",
"qname,partition_spec",
- "See also
https://www.monetdb.org/Documentation/ServerAdministration/DistributedQueryProcessing/DataPartitioning"},
+ "See also
https://www.monetdb.org/documentation/admin-guide/distributed-query-processing/"},
{"ALTER SCHEMA",
"",
"ALTER SCHEMA [ IF EXISTS ] ident RENAME TO ident",
"ident",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/SchemaDefinitions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/schema-definitions/"},
{"ALTER SEQUENCE",
"",
"ALTER SEQUENCE qname [ AS seq_int_datatype] [ RESTART [WITH intval]]
[INCREMENT BY intval]\n"
"[MINVALUE intval | NO MINVALUE] [MAXVALUE intval | NO MAXVALUE]
[CACHE intval] [[NO] CYCLE]",
"seq_int_datatype,intval",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataTypes/SerialDatatypes"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-types/serial-types/"},
{"ALTER TABLE",
"",
"ALTER TABLE [ IF EXISTS ] qname ADD [ COLUMN ] column_def\n"
@@ -76,7 +76,7 @@ SQLhelp sqlhelp1[] = {
"ALTER TABLE [ IF EXISTS ] qname SET { INSERT ONLY | READ ONLY | READ
WRITE }\n"
"ALTER TABLE [ IF EXISTS ] qname SET SCHEMA ident",
"qname,column_def,table_constraint,ident",
- "See also
https://www.monetdb.org/Documentation/SQLreference/TableDefinitions/AlterStatement"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/alter-statement/"},
{"ALTER USER",
"Change a user's login name or password or default schema",
"ALTER USER ident RENAME TO ident\n"
@@ -85,17 +85,17 @@ SQLhelp sqlhelp1[] = {
"ALTER USER ident [WITH [ENCRYPTED | UNENCRYPTED] PASSWORD string] SET
SCHEMA ident\n"
"ALTER USER ident [WITH [ENCRYPTED | UNENCRYPTED] PASSWORD string]
SCHEMA PATH string",
"ident",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/Users"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/privileges/"},
{"ANALYZE",
"Collect column/table/schema data statistics for analysis and
optimizer usage",
"ANALYZE ident [ . ident [ column_list ] ] [SAMPLE size] [MINMAX]",
"ident,column_list",
- "See also
https://www.monetdb.org/Documentation/ServerAdministration/TableStatistics"},
+ "See also
https://www.monetdb.org/documentation/admin-guide/monitoring/table-statistics/"},
{"CALL",
"Call a stored procedure",
"CALL qname '(' [ scalar_expression [',' ...] ] ')' | CALL ident '.'
ident",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/Flowofcontrol"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-programming/flow-of-control/"},
{"COMMENT",
"Add, update or remove a comment or description for a database object",
"COMMENT ON { SCHEMA | TABLE | VIEW | COLUMN | INDEX | SEQUENCE |
function_type }\n"
@@ -106,12 +106,12 @@ SQLhelp sqlhelp1[] = {
"Commit the current transaction",
"COMMIT [ WORK ] [ AND CHAIN | AND NO CHAIN ]",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/Transactions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/transactions/"},
{"COPY BINARY",
"Append binary representations into a table",
"COPY [( BIG | LITTLE | NATIVE) ENDIAN] BINARY INTO qname
[column_list] FROM string [',' ...] [ON { CLIENT | SERVER }] [NO CONSTRAINT]",
"qname,column_list",
- "See also
https://www.monetdb.org/Documentation/ServerAdministration/LoadingBulkData/BinaryBulkLoad"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-loading/binary-loading/"},
{"COPY INTO",
"Parse a csv file into a table or write a query result to a csv file",
"COPY [nrofrecords] INTO qname [column_list] FROM string [',' ...]
[headerlist] [ON { CLIENT | SERVER }] [ separators]\n"
@@ -120,7 +120,7 @@ SQLhelp sqlhelp1[] = {
" [NULL [AS] string] [LOCKED] [BEST EFFORT] [NO CONSTRAINT]\n"
"COPY query_expression INTO [STDOUT | string [ON { CLIENT | SERVER }]]
[separators] [NULL [AS] string]",
"nrofrecords,qname,column_list,headerlist,separators",
- "See also
https://www.monetdb.org/Documentation/ServerAdministration/LoadingBulkData"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-loading/copy-from/"},
{"COPY LOADER",
"Copy into using a user supplied parsing function",
"COPY LOADER INTO qname FROM qname '(' [ scalar_expression ... ] ')'",
@@ -136,14 +136,14 @@ SQLhelp sqlhelp1[] = {
" RETURNS function_return_data_type\n"
" LANGUAGE language_keyword external_code",
"qname,param,function_return_data_type,ident,language_keyword,external_code",
- "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-programming/function-definitions/"},
{"CREATE FILTER FUNCTION",
"Create a user-defined filter function. Currently only MAL
definitions\n"
"CREATE [ OR REPLACE ] FILTER [ FUNCTION ] qname '(' { '*' | [ param
[',' ...]] } ')'\n"
" RETURNS function_return_data_type\n"
" EXTERNAL NAME ident ',' ident",
"qname,param,function_return_data_type,ident",
- "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-programming/function-definitions/"},
{"CREATE FUNCTION",
"Create a user-defined function (UDF). The body of the function can be
defined in\n"
" PL/SQL or programming languages such as Python, R, C or CPP when
embedded on the server.",
@@ -157,23 +157,23 @@ SQLhelp sqlhelp1[] = {
" RETURNS function_return_data_type\n"
" LANGUAGE language_keyword external_code",
"qname,param,function_return_data_type,statement,ident,language_keyword,external_code",
- "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-programming/function-definitions/"},
{"CREATE INDEX",
"Create a hint for a secondary index on a column or set of columns of
a table",
"CREATE [ UNIQUE | ORDERED | IMPRINTS ] INDEX ident ON qname '('
ident_list ')'",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/TableDefinitions/IndexDefinitions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/index-definitions/"},
{"CREATE LOADER",
"Create a custom (external) data loader function. The body is defined
in Python language",
"CREATE [ OR REPLACE ] LOADER [ FUNCTION ] qname '(' [ param [','
...]] ')'\n"
" LANGUAGE PYTHON external_code",
"qname,param,external_code",
- "See also
https://www.monetdb.org/blog/monetdbpython-loader-functions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/blog-archive/python-loader/"},
{"CREATE MERGE TABLE",
"",
"CREATE MERGE TABLE [ IF NOT EXISTS ] qname table_source [
partition_by ]",
"table_source,partition_by",
- "See also
https://www.monetdb.org/Documentation/ServerAdministration/DistributedQueryProcessing/DataPartitioning"},
+ "See also
https://www.monetdb.org/documentation/admin-guide/distributed-query-processing/"},
{"CREATE PROCEDURE",
"Create a user-defined procedure",
"CREATE [ OR REPLACE ] PROCEDURE qname '(' { '*' | [ param [',' ...]]
} ')'\n"
@@ -181,7 +181,7 @@ SQLhelp sqlhelp1[] = {
"CREATE [ OR REPLACE ] PROCEDURE qname '(' { '*' | [ param [',' ...]]
} ')'\n"
" EXTERNAL NAME ident ',' ident",
"qname,param,procedure_statement,ident",
- "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Procedures"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-programming/procedure-definitions/"},
{"CREATE REMOTE TABLE",
"",
"CREATE REMOTE TABLE [ IF NOT EXISTS ] qname ON string [WITH [USER
'username'] [[ENCRYPTED] PASSWORD 'password']]",
@@ -191,38 +191,38 @@ SQLhelp sqlhelp1[] = {
"",
"CREATE REPLICA TABLE [ IF NOT EXISTS ] qname table_source",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLReference/TableDefinitions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/table-definition/"},
{"CREATE ROLE",
"Create a new role. You can grant privileges to a role and next\n"
"grant a role (or multiple roles) to specific users",
"CREATE ROLE ident [ WITH ADMIN { CURRENT_USER | CURRENT_ROLE } ]",
"ident",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/Roles"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/privileges/#roles"},
{"CREATE SCHEMA",
"Create a new schema",
"CREATE SCHEMA [ IF NOT EXISTS ] schema_name [default_char_set]
[path_spec] [schema_element]",
"schema_name,default_char_set,path_spec,schema_element",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/SchemaDefinitions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/schema-definitions/"},
{"CREATE SEQUENCE",
"Define a new integer number sequence generator",
"CREATE SEQUENCE qname [ AS seq_int_datatype] [ START [WITH intval]]
[INCREMENT BY intval]\n"
"[MINVALUE intval | NO MINVALUE] [MAXVALUE intval | NO MAXVALUE]
[CACHE intval] [[NO] CYCLE]",
"seq_int_datatype,intval",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataTypes/SerialDatatypes"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-types/serial-types/"},
{"CREATE TABLE",
"Create a new table",
"CREATE TABLE [ IF NOT EXISTS ] qname table_source [STORAGE ident
string]\n"
"CREATE TABLE [ IF NOT EXISTS ] qname FROM LOADER function_ref\n"
"CREATE [ LOCAL | GLOBAL ] { TEMPORARY | TEMP } TABLE [ IF NOT EXISTS
] qname table_source [on_commit]",
"table_source,on_commit,function_ref",
- "See also
https://www.monetdb.org/Documentation/SQLReference/TableDefinitions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/table-definition/"},
{"CREATE TRIGGER",
"Define a triggered action for a table data update event",
"CREATE [ OR REPLACE ] TRIGGER ident { BEFORE | AFTER }\n"
" { INSERT | DELETE | TRUNCATE | UPDATE [ OF ident_list ] }\n"
" ON qname [ REFERENCING trigger_reference [...] ] triggered_action",
"qname,ident_list,trigger_reference,triggered_action",
- "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Triggers"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-programming/trigger-definition/"},
{"CREATE TYPE",
"Add user defined type to the type system ",
"CREATE TYPE qname EXTERNAL NAME ident",
@@ -232,13 +232,13 @@ SQLhelp sqlhelp1[] = {
"Create a new database user",
"CREATE USER ident WITH [ENCRYPTED | UNENCRYPTED] PASSWORD string NAME
string SCHEMA ident [SCHEMA PATH string]",
"ident",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/Users"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/privileges/"},
{"CREATE VIEW",
"Create a new view",
"CREATE [ OR REPLACE ] VIEW qname [ column_list ] AS {
query_expression | '(' query_expression ')' }\n"
"[ WITH CHECK OPTION ]",
"qname,column_list,query_expression",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/ViewDefinitions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/view-definition/"},
{"CREATE WINDOW",
"Create a user-defined window function. Currently only MAL
definitions\n"
"are supported.",
@@ -246,7 +246,7 @@ SQLhelp sqlhelp1[] = {
" RETURNS function_return_data_type\n"
" EXTERNAL NAME ident ',' ident",
"qname,param,function_return_data_type,ident",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/WindowFunctions"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-manipulation/window-expressions/"},
{"CURRENT_DATE",
"Pseudo column or function to get the current date",
"CURRENT_DATE [ '(' ')' ]",
@@ -291,7 +291,7 @@ SQLhelp sqlhelp1[] = {
"Debug a SQL statement using MAL debugger",
"DEBUG statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/Debug"},
+ "See also
https://www.monetdb.org/documentation/admin-guide/debugging-features/debug-sql-stmt/"},
{"DECLARE",
"Define a local variable",
"DECLARE ident_list data_type",
@@ -387,12 +387,12 @@ SQLhelp sqlhelp1[] = {
"Execute a prepared SQL statement with supplied parameter values",
"EXECUTE { intnr | ** } '(' [ value [, ...] ] ')'",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/PrepareExec"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-manipulation/prepare-statement/"},
{"EXPLAIN",
"Give MAL execution plan for the SQL statement",
"EXPLAIN statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/Explain"},
+ "See also
https://www.monetdb.org/documentation/admin-guide/debugging-features/explain-sql-stmt/"},
{"EXTRACT",
"Built-in function",
"EXTRACT '(' { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND | CENTURY |
DECADE | QUARTER | WEEK | DOW | DOY | EPOCH } FROM scalar_expression ')'",
@@ -403,13 +403,13 @@ SQLhelp sqlhelp1[] = {
"[ WITH cte_list ] INSERT INTO qname [ column_list ]\n"
" [ { DEFAULT VALUES | VALUES row_values | query_expression } ]",
"cte_list,column_list,row_values,query_expression",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/TableUpdates"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-manipulation/table-updates/"},
{"GRANT",
"Define access privileges",
"GRANT privileges TO grantee [',' ...] [ WITH GRANT OPTION ]\n"
"GRANT role [',' ...] TO grantee [',' ...] [ WITH ADMIN OPTION]",
"privileges,table_privileges,global_privileges,role,grantee",
- "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/GrantAndRevoke"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/privileges/#grant-and-revoke"},
{"LOCALTIME",
"Pseudo column or function to get the current client time excluding
timezone",
"LOCALTIME [ '(' ')' ]",
@@ -429,12 +429,12 @@ SQLhelp sqlhelp1[] = {
"Give relational execution plan for the SQL statement",
"PLAN statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/PlanSQL"},
+ "See also
https://www.monetdb.org/documentation/admin-guide/debugging-features/plan-sql-stmt/"},
{"PREPARE",
"Prepare a SQL DML statement with optional question-mark parameter
markers",
"PREPARE statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/PrepareExec"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-manipulation/prepare-statement/"},
{"RELEASE SAVEPOINT",
"",
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
