Changeset: 45c1923fb279 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/45c1923fb279
Branch: default
Log Message:

Merge with Jan2022 branch.


diffs (truncated from 1059 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/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
@@ -682,7 +682,7 @@
 [ "bat",       "reuseMap",     "command bat.reuseMap(X_0:bat[:any_1], 
X_1:bat[:oid]):bat[:oid] ",      "BKCreuseBATmap;",      "Derive the oid 
mapping for reuse BAT based on list of to-be-deleted"   ]
 [ "bat",       "save", "command bat.save(X_0:bat[:any_1]):void ",      
"BKCsave2;",    ""      ]
 [ "bat",       "save", "command bat.save(X_0:str):bit ",       "BKCsave;",     
"Save a BAT to storage, if it was loaded and dirty.  \nReturns whether IO was 
necessary.  Please realize that \ncalling this function violates the atomic 
commit protocol!!"    ]
-[ "bat",       "setAccess",    "command bat.setAccess(X_0:bat[:any_1], 
X_1:str):bat[:any_1] ", "BKCsetAccess;",        "Try to change the update 
access priviliges \nto this BAT. Mode:\nr[ead-only]      - allow only read 
access.\na[append-only]   - allow reads and update.\nw[riteable]      - allow 
all operations.\nBATs are updatable by default. On making a BAT read-only, 
\nall subsequent updates fail with an error message.\nReturns the BAT itself."  
  ]
+[ "bat",       "setAccess",    "command bat.setAccess(X_0:bat[:any_1], 
X_1:str):bat[:any_1] ", "BKCsetAccess;",        "Try to change the update 
access privileges \nto this BAT. Mode:\nr[ead-only]      - allow only read 
access.\na[append-only]   - allow reads and update.\nw[riteable]      - allow 
all operations.\nBATs are updatable by default. On making a BAT read-only, 
\nall subsequent updates fail with an error message.\nReturns the BAT itself."  
  ]
 [ "bat",       "setColumn",    "command bat.setColumn(X_0:bat[:any_1], 
X_1:str):void ",        "BKCsetColumn;",        "Give a logical name to the 
tail column of a BAT."      ]
 [ "bat",       "setHash",      "command bat.setHash(X_0:bat[:any_1]):bit ",    
"BKCsetHash;",  "Create a hash structure on the column" ]
 [ "bat",       "setImprints",  "command bat.setImprints(X_0:bat[:any_1]):bit 
",        "BKCsetImprints;",      "Create an imprints structure on the column"  
  ]
@@ -8391,7 +8391,7 @@
 [ "clients",   "getprofile",   "pattern clients.getprofile() (X_0:str, 
X_1:int, X_2:int, X_3:int, X_4:int) ",  "CLTgetProfile;",       "Retrieve the 
profile settings for a client"    ]
 [ "clients",   "md5sum",       "command clients.md5sum(X_0:str):str ", 
"CLTmd5sum;",   "Return hex string representation of the MD5 hash of the given 
string"  ]
 [ "clients",   "quit", "unsafe pattern clients.quit():void ",  "CLTquit;",     
"Terminate the client session." ]
-[ "clients",   "quit", "unsafe pattern clients.quit(X_0:int):void ",   
"CLTquit;",     "Terminate the session for a single client using a soft 
error.\nIt is the privilige of the console user."       ]
+[ "clients",   "quit", "unsafe pattern clients.quit(X_0:int):void ",   
"CLTquit;",     "Terminate the session for a single client using a soft 
error.\nIt is the privilege of the console user."       ]
 [ "clients",   "removeUser",   "unsafe pattern 
clients.removeUser(X_0:str):void ",     "CLTremoveUser;",       "Remove the 
given user from the system" ]
 [ "clients",   "ripemd160sum", "command clients.ripemd160sum(X_0:str):str ",   
"CLTripemd160sum;",     "Return hex string representation of the RIPEMD160 hash 
of the given string"    ]
 [ "clients",   "setListing",   "unsafe pattern clients.setListing(X_0:int):int 
",      "CLTsetListing;",       "Turn on/off echo of MAL instructions:\n1 - 
echo input,\n2 - show mal instruction,\n4 - show details of type resolutoin, 
\n8 - show binding information."       ]
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
@@ -797,7 +797,7 @@
 [ "bat",       "reuseMap",     "command bat.reuseMap(X_0:bat[:any_1], 
X_1:bat[:oid]):bat[:oid] ",      "BKCreuseBATmap;",      "Derive the oid 
mapping for reuse BAT based on list of to-be-deleted"   ]
 [ "bat",       "save", "command bat.save(X_0:bat[:any_1]):void ",      
"BKCsave2;",    ""      ]
 [ "bat",       "save", "command bat.save(X_0:str):bit ",       "BKCsave;",     
"Save a BAT to storage, if it was loaded and dirty.  \nReturns whether IO was 
necessary.  Please realize that \ncalling this function violates the atomic 
commit protocol!!"    ]
-[ "bat",       "setAccess",    "command bat.setAccess(X_0:bat[:any_1], 
X_1:str):bat[:any_1] ", "BKCsetAccess;",        "Try to change the update 
access priviliges \nto this BAT. Mode:\nr[ead-only]      - allow only read 
access.\na[append-only]   - allow reads and update.\nw[riteable]      - allow 
all operations.\nBATs are updatable by default. On making a BAT read-only, 
\nall subsequent updates fail with an error message.\nReturns the BAT itself."  
  ]
+[ "bat",       "setAccess",    "command bat.setAccess(X_0:bat[:any_1], 
X_1:str):bat[:any_1] ", "BKCsetAccess;",        "Try to change the update 
access privileges \nto this BAT. Mode:\nr[ead-only]      - allow only read 
access.\na[append-only]   - allow reads and update.\nw[riteable]      - allow 
all operations.\nBATs are updatable by default. On making a BAT read-only, 
\nall subsequent updates fail with an error message.\nReturns the BAT itself."  
  ]
 [ "bat",       "setColumn",    "command bat.setColumn(X_0:bat[:any_1], 
X_1:str):void ",        "BKCsetColumn;",        "Give a logical name to the 
tail column of a BAT."      ]
 [ "bat",       "setHash",      "command bat.setHash(X_0:bat[:any_1]):bit ",    
"BKCsetHash;",  "Create a hash structure on the column" ]
 [ "bat",       "setImprints",  "command bat.setImprints(X_0:bat[:any_1]):bit 
",        "BKCsetImprints;",      "Create an imprints structure on the column"  
  ]
@@ -11676,7 +11676,7 @@
 [ "clients",   "getprofile",   "pattern clients.getprofile() (X_0:str, 
X_1:int, X_2:int, X_3:int, X_4:int) ",  "CLTgetProfile;",       "Retrieve the 
profile settings for a client"    ]
 [ "clients",   "md5sum",       "command clients.md5sum(X_0:str):str ", 
"CLTmd5sum;",   "Return hex string representation of the MD5 hash of the given 
string"  ]
 [ "clients",   "quit", "unsafe pattern clients.quit():void ",  "CLTquit;",     
"Terminate the client session." ]
-[ "clients",   "quit", "unsafe pattern clients.quit(X_0:int):void ",   
"CLTquit;",     "Terminate the session for a single client using a soft 
error.\nIt is the privilige of the console user."       ]
+[ "clients",   "quit", "unsafe pattern clients.quit(X_0:int):void ",   
"CLTquit;",     "Terminate the session for a single client using a soft 
error.\nIt is the privilege of the console user."       ]
 [ "clients",   "removeUser",   "unsafe pattern 
clients.removeUser(X_0:str):void ",     "CLTremoveUser;",       "Remove the 
given user from the system" ]
 [ "clients",   "ripemd160sum", "command clients.ripemd160sum(X_0:str):str ",   
"CLTripemd160sum;",     "Return hex string representation of the RIPEMD160 hash 
of the given string"    ]
 [ "clients",   "setListing",   "unsafe pattern clients.setListing(X_0:int):int 
",      "CLTsetListing;",       "Turn on/off echo of MAL instructions:\n1 - 
echo input,\n2 - show mal instruction,\n4 - show details of type resolutoin, 
\n8 - show binding information."       ]
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 [, ...] ] ')'",
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to