[
https://issues.apache.org/jira/browse/DERBY-4087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-4087:
---------------------------------
Attachment: sample.log
dumpquery
Attaching a bash script and a sample output which I find useful sometimes for
looking at the query trees. It finds the dumped query tree(s) from a given
query on derby.log and prints it on std out., and also adds helper vertical
lines to help match up tree levels. If an existing database is not given, it
will create a sample one on the fly with one table.
Example:
dumpquery -pboie 'select * from t order by j' > sample.log
> Clean up debug printing of the abstract syntax trees after parsing, binding
> and optimization
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-4087
> URL: https://issues.apache.org/jira/browse/DERBY-4087
> Project: Derby
> Issue Type: Improvement
> Components: Miscellaneous, SQL
> Reporter: Dag H. Wanvik
> Assignee: Dag H. Wanvik
> Priority: Trivial
> Attachments: derby-4087-a.diff, derby-4087-a.stat, dumpquery,
> sample.log
>
>
> Currently, the printing is often inconsistent:
> - some subtrees not printed
> - wrong indentation due to missing newlines, or lacking level increments
> - redundant printing of subtrees (AST is really a DAG, would be nice to print
> only once and then refer back to show aliasing)
> - some items printed twice due to inconsistent usage of pattern
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
