Changeset: c71d1ae893e6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c71d1ae893e6
Modified Files:
clients/mapiclient/mhelp.c
sql/storage/bat/bat_storage.c
sql/storage/store.c
Branch: default
Log Message:
Merge with Oct2020 branch.
diffs (truncated from 377 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/TableDefinitions/AlterStatement"},
{"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/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/SQLreference/TableDefinitions/AlterStatement"},
{"ALTER USER",
"Change a user's login name or password or default schema",
"ALTER USER ident RENAME TO ident\n"
@@ -85,12 +85,12 @@ 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/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",
@@ -106,12 +106,12 @@ SQLhelp sqlhelp1[] = {
"Commit the current transaction",
"COMMIT [ WORK ] [ AND CHAIN | AND NO CHAIN ]",
NULL,
- NULL},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/Transactions"},
{"COPY BINARY",
"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"
@@ -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/Cookbooks/SQLrecipes/LoadingBulkData"},
+ "See also
https://www.monetdb.org/Documentation/ServerAdministration/LoadingBulkData"},
{"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/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
{"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/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
{"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,12 +157,12 @@ 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/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 [ FUNCTION ] qname '(' [ param [','
...]] ')'\n"
@@ -173,7 +173,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/ServerAdministration/DistributedQueryProcessing/DataPartitioning"},
{"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/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']]",
@@ -197,32 +197,32 @@ SQLhelp sqlhelp1[] = {
"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 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/Manuals/SQLreference/SerialTypes"},
+ "See also
https://www.monetdb.org/Documentation/SQLReference/DataTypes/SerialDatatypes"},
{"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/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 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/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",
@@ -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/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 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/Manuals/SQLreference/Functions"},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/ProgrammingSQL/Functions"},
{"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,
- "https://www.monetdb.org/Documentation/Manuals/SQLreference/Debug"},
+
"https://www.monetdb.org/Documentation/SQLreference/RuntimeFeatures/Debug"},
{"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/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 | 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/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 [ '(' ')' ]",
@@ -429,12 +429,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",
@@ -445,12 +445,12 @@ 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]",
NULL,
- NULL},
+ "See also
https://www.monetdb.org/Documentation/SQLreference/Transactions"},
{"SAVEPOINT",
NULL,
"SAVEPOINT ident",
@@ -472,12 +472,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",
"",
"SET LOCAL TRANSACTION [ transactionmode ]",
@@ -531,12 +531,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 ]",
@@ -557,7 +557,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 */
};
@@ -608,7 +608,7 @@ SQLhelp sqlhelp2[] = {
"[ CONSTRAINT ident ] { NOT NULL | NULL | UNIQUE | PRIMARY KEY | CHECK
'(' search_condition ')' |\n"
" REFERENCES qname [ column_list ] [ match_options ] [
reference_action ] }\n",
"column_list,search_condition,match_options,reference_action",
- "See also
https://www.monetdb.org/Documentation/SQLreference/TableIdentityColumn"},
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
