Changeset: f192a9ddc6d3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f192a9ddc6d3
Modified Files:
clients/mapiclient/mhelp.c
Branch: Dec2025
Log Message:
Correct the syntax of EXPLAIN, based on sql_parse.y
diffs (30 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -421,19 +421,17 @@ SQLhelp sqlhelp1[] = {
NULL,
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-manipulation/prepare-statement/"},
{"EXPLAIN",
- "Display logical or physical execution plan for the SQL statement.",
- "EXPLAIN [BEFORE|AFTER] [step] [SHOW DETAILS] statement\n"
- "\twhere step is LOGICAL UNNEST | LOGICAL REWRITE [posint] [posint] |
PHYSICAL",
+ "Display logical or physical execution plan for an SQL statement.",
+ "EXPLAIN [ [BEFORE|AFTER] {LOGICAL UNNEST | LOGICAL REWRITE [posint]
[posint] | PHYSICAL} ]\n"
+ " [SHOW DETAILS] sql-statement",
NULL,
- "Plain EXPLAIN defaults to logical plan.\n"
- "Use LOGICAL UNNEST|LOGICAL REWRITE|PHYSICAL to specify compilation
step to show.\n"
- "Use BEFORE|AFTER to specify moment of compilation step to output.\n"
- "The default is AFTER.\n"
+ "Plain EXPLAIN sql-statement returns the logical plan.\n"
+ "Use LOGICAL UNNEST or LOGICAL REWRITE or PHYSICAL to specify the
compilation step to show.\n"
+ "Optionally add BEFORE or AFTER to specify moment of compilation step
to output. The default is AFTER.\n"
"Two positive numbers can be passed to LOGICAL REWRITE to stop at
specific\n"
"rewriter index or rewrite loop cycle, respectively.\n"
"If only one positive number is passed to LOGICAL REWRITE, rewrite
stop cycle defaults to 0.\n"
- "SHOW DETAILS displays column properties, rewriter number of changes\n"
- "and time spent.\n"
+ "SHOW DETAILS displays column properties, rewriter number of changes
and time spent.\n"
"See also
https://www.monetdb.org/documentation/admin-guide/debugging-features/explain-sql-stmt/"},
{"EXTRACT",
"Built-in function",
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
