Changeset: 63163f776662 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=63163f776662
Modified Files:
clients/mapiclient/mhelp.c
Branch: Jun2020
Log Message:
Fixed broken URLs
diffs (truncated from 345 to 300 lines):
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/Cookbooks/SQLrecipes/DataPartitioning"},
+ "See also
https://www.monetdb.org/Documentation/ServerAdministration/DistributedQueryProcessing/DataPartitioning"},
{"ALTER SCHEMA",
"",
"ALTER SCHEMA [ IF EXISTS ] ident RENAME TO ident",
"ident",
- "See also https://www.monetdb.org/Documentation/SQLreference/Alter"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/SchemaDefinitions"},
{"ALTER SEQUENCE",
"",
"ALTER SEQUENCE qname [ AS int_datatype] [ RESTART [WITH intval]]
[INCREMENT BY intval]\n"
"[MINVALUE intval | NO MINVALUE] [MAXVALUE intval | NO MAXVALUE]
[CACHE intval] [[NO] CYCLE]",
"int_datatype,intval",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/SerialTypes"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataTypes/SerialDatatypes"},
{"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/Alter"},
+ "See also
https://www.monetdb.org/Documentation/SQLLanguage/DataDefinition/AlterStatements"},
{"ALTER USER",
"Change a user's login name or password or default schema",
"ALTER USER ident RENAME TO ident\n"
@@ -84,12 +84,12 @@ SQLhelp sqlhelp1[] = {
"ALTER USER ident WITH [ENCRYPTED | UNENCRYPTED] PASSWORD string\n"
"ALTER USER ident [ WITH [ENCRYPTED | UNENCRYPTED] PASSWORD string ]
SET SCHEMA ident",
"ident",
- "See also https://www.monetdb.org/Documentation/SQLreference/Users"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/Users"},
{"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/Cookbooks/SQLrecipes/statistics"},
+ "See also
https://www.monetdb.org/Documentation/ServerAdministration/TableStatistics"},
{"CALL",
"Call a stored procedure",
"CALL qname '(' [ scalar_expression [',' ...] ] ')' | CALL ident '.'
ident",
@@ -110,7 +110,7 @@ SQLhelp sqlhelp1[] = {
"Append binary representations into a table",
"COPY [nrofrecords] BINARY INTO qname [column_list] FROM string [','
...] [ON { CLIENT | SERVER }] [NO CONSTRAINT]",
"nrofrecords,qname,column_list",
- "See also
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad"},
+ "See also
https://www.monetdb.org/Documentation/ServerAdministration/LoadingBulkData/BinaryBulkLoad"},
{"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"
@@ -119,7 +119,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/Cookbooks/SQLrecipes/LoadingBulkData"},
+ "See also
https://www.monetdb.org/Documentation/ServerAdministration/LoadingBulkData/CSVBulkLoads"},
{"COPY LOADER",
"Copy into using a user supplied parsing function",
"COPY LOADER INTO qname FROM qname '(' [ scalar_expression ... ] ')'",
@@ -135,14 +135,14 @@ SQLhelp sqlhelp1[] = {
" RETURNS data_type\n"
" LANGUAGE language_keyword external_code",
"qname,param,data_type,ident,language_keyword,external_code",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
{"CREATE FILTER FUNCTION",
"",
"CREATE [ OR REPLACE ] FILTER FUNCTION qname '(' { '*' | [ param [','
...]] } ')'\n"
" RETURNS { data_type | TABLE '(' function_return [',' ...] ')' }\n"
" EXTERNAL NAME ident ',' ident",
"qname,param,data_type,function_return,ident",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
{"CREATE FUNCTION",
"Create an user-defined function. Besides standard SQL the body of the
function\n"
"can also be defined in other programming languages such as Python, R,
C or CPP.",
@@ -156,12 +156,12 @@ SQLhelp sqlhelp1[] = {
" RETURNS { data_type | TABLE '(' function_return [',' ...] ')' }\n"
" LANGUAGE language_keyword external_code",
"qname,param,data_type,function_return,statement,ident,language_keyword,external_code",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
{"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/Manuals/SQLreference/Indices"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/TableDefinitions/IndexDefinitions"},
{"CREATE LOADER",
"Create a custom (external) data loader function. The body is defined
in Python language",
"CREATE [ OR REPLACE ] LOADER qname '(' [ param [',' ...]] ')'\n"
@@ -172,7 +172,7 @@ SQLhelp sqlhelp1[] = {
"",
"CREATE MERGE TABLE [ IF NOT EXISTS ] qname table_source [
partition_by ]",
"table_source,partition_by",
- "See also
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/TableDefinitions"},
{"CREATE PROCEDURE",
"Create an user-defined procedure",
"CREATE [ OR REPLACE ] PROCEDURE qname '(' { '*' | [ param [',' ...]]
} ')'\n"
@@ -180,7 +180,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/Manuals/SQLreference/Procedures"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Procedures"},
{"CREATE REMOTE TABLE",
"",
"CREATE REMOTE TABLE [ IF NOT EXISTS ] qname ON string [WITH [USER
'username'] [[ENCRYPTED] PASSWORD 'password']]",
@@ -190,24 +190,24 @@ SQLhelp sqlhelp1[] = {
"",
"CREATE REPLICA TABLE [ IF NOT EXISTS ] qname table_source",
NULL,
- "See also
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/TransactionReplication"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/TableDefinitions"},
{"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/Roles"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/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/Schema"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/SchemaDefinitions"},
{"CREATE SEQUENCE",
"Define a new integer number sequence generator",
"CREATE SEQUENCE qname [ AS int_datatype] [ START [WITH intval]]
[INCREMENT BY intval]\n"
"[MINVALUE intval | NO MINVALUE] [MAXVALUE intval | NO MAXVALUE]
[CACHE intval] [[NO] CYCLE]",
"int_datatype,intval",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/SerialTypes"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataTypes/SerialDatatypes"},
{"CREATE STREAM TABLE",
"Temporary table, locked during updates/ continues query processing",
"CREATE STREAM TABLE [ IF NOT EXISTS ] qname table_source\n",
@@ -219,14 +219,14 @@ SQLhelp sqlhelp1[] = {
"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/Manuals/SQLreference/Tables"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/TableDefinitions"},
{"CREATE TRIGGER",
"Define a triggered action for a table data update event",
"CREATE [ OR REPLACE ] TRIGGER qname { 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/Triggers"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Triggers"},
{"CREATE TYPE",
"Add user defined type to the type system ",
"CREATE TYPE qname EXTERNAL NAME ident",
@@ -236,13 +236,13 @@ SQLhelp sqlhelp1[] = {
"Create a new database user",
"CREATE USER ident WITH [ENCRYPTED | UNENCRYPTED] PASSWORD string NAME
string SCHEMA ident",
"ident",
- "See also https://www.monetdb.org/Documentation/SQLreference/Users"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/Users"},
{"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/Manuals/SQLreference/Views"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/ViewDefinitions"},
{"CREATE WINDOW",
"Create an user-defined window function. Currently only MAL
definitions\n"
"are supported.",
@@ -250,7 +250,7 @@ SQLhelp sqlhelp1[] = {
" RETURNS data_type\n"
" EXTERNAL NAME ident ',' ident",
"qname,param,data_type,function_return,ident",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/WindowFunctions"},
{"CURRENT_DATE",
"Pseudo column or function to get the current date",
"CURRENT_DATE [ '(' ')' ]",
@@ -290,7 +290,7 @@ SQLhelp sqlhelp1[] = {
"Debug a SQL statement using MAL debugger",
"DEBUG statement",
NULL,
- "https://www.monetdb.org/Documentation/Manuals/SQLreference/Debug"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/Debug"},
{"DECLARE",
"Define a local variable",
"DECLARE ident_list data_type",
@@ -380,12 +380,12 @@ SQLhelp sqlhelp1[] = {
"Execute a prepared SQL statement with supplied parameter values",
"EXECUTE { intnr | ** } '(' [ value [, ...] ] ')'",
NULL,
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/PrepareExec"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/PrepareExec"},
{"EXPLAIN",
"Give MAL execution plan for the SQL statement",
"EXPLAIN statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Explain"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/Explain"},
{"EXTRACT",
"Built-in function",
"EXTRACT '(' { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND | CENTURY |
DECADE | QUARTER | WEEK | DOW | DOY } FROM scalar_expression ')'",
@@ -396,13 +396,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/Updates"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/TableUpdates"},
{"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/Permissions"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/GrantAndRevoke"},
{"LOCALTIME",
"Pseudo column or function to get the current client time excluding
timezone",
"LOCALTIME [ '(' ')' ]",
@@ -422,12 +422,12 @@ SQLhelp sqlhelp1[] = {
"Give relational execution plan for the SQL statement",
"PLAN statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/PlanSQL"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/PlanSQL"},
{"PREPARE",
"Prepare a SQL DML statement with optional question-mark parameter
markers",
"PREPARE statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/PrepareExec"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/PrepareExec"},
{"RELEASE SAVEPOINT",
"",
"RELEASE SAVEPOINT ident",
@@ -438,7 +438,7 @@ SQLhelp sqlhelp1[] = {
"REVOKE [GRANT OPTION FOR] privileges FROM { grantee [',' ...] |
CURRENT_USER | CURRENT_ROLE }\n"
"REVOKE [ADMIN OPTION FOR] role [',' ...] FROM { grantee [',' ...] |
CURRENT_USER | CURRENT_ROLE }",
"privileges,table_privileges,global_privileges,grantee,role",
- "See also
https://www.monetdb.org/Documentation/SQLreference/Permissions"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataDefinition/Privileges/GrantAndRevoke"},
{"ROLLBACK",
"Rollback the current transaction",
"ROLLBACK [WORK] [ AND CHAIN | AND NO CHAIN ] [TO SAVEPOINT ident]",
@@ -465,12 +465,12 @@ SQLhelp sqlhelp1[] = {
"[ OFFSET { count | param } ]\n"
"[ SAMPLE size [ SEED size ] ]",
"cte_list,expression,group_by_element,window_definition",
- "See also
https://www.monetdb.org/Documentation/SQLreference/TableExpressions"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/TableExpressions"},
{"SET",
"Assign a value to a variable or column",
"SET ident '=' simple_atom",
"simple_atom",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Variables"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Variables"},
{"SET LOCAL TRANSACTION",
"",
"START LOCAL TRANSACTION transactionmode",
@@ -515,7 +515,7 @@ SQLhelp sqlhelp1[] = {
"Change transaction mode from auto-commit to user controlled
commit/rollback",
"{ START | BEGIN } TRANSACTION transactionmode",
"transactionmode,isolevel",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Transactions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/Transactions"},
{"TABLE JOINS",
"",
"'(' joined_table ') |\n"
@@ -524,12 +524,12 @@ SQLhelp sqlhelp1[] = {
"table_ref UNION JOIN table_ref { ON search_condition | USING
column_list } |\n"
"table_ref [ INNER | LEFT | RIGHT | FULL ] JOIN table_ref { ON
search_condition | USING column_list }",
"table_ref,search_condition,column_list",
- "See also
https://www.monetdb.org/Documentation/SQLreference/TableExpressions"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/TableExpressions"},
{"TRACE",
"Give execution trace for the SQL statement",
"TRACE statement",
NULL,
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Trace"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/Trace"},
{"TRUNCATE",
"Remove all rows from a table",
"TRUNCATE [ TABLE ] qname [ CONTINUE IDENTITY | RESTART IDENTITY ] [
CASCADE | RESTRICT ]",
@@ -550,7 +550,7 @@ SQLhelp sqlhelp1[] = {
"",
"{ window_aggregate_function | window_rank_function } OVER { ident |
'(' window_specification ')' }",
"window_aggregate_function,window_rank_function,window_specification",
- "See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/WindowFunctions"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataManipulation/WindowFunctions"},
{NULL, NULL, NULL, NULL, NULL} /* End of list marker */
};
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
