I had to disable write access for anonymous mantis account because of the spam in comments. Will enable it one I add some kind of protection. For now - please register to report a bug. Thanks.
I moved all the QOT code to Launchpad. This includes code for the tool, tests and a small experimental utility qot-predictor, which based on query analysis tries to predict which queries are likely to be executed next. Project URL for branching is lp:qot. If you want to push your own changes just create a new project branch.
It has been quite some time since the last 0.0.3 release, and now QOT 0.0.4 is finally available.
Here’s the ChangeLog of the new release:
- added ORDER BY analysis for index generation
- added an ORDER BY-specific rewrite (const-field removal)
- added ORDER BY-specific static checks (unoptimizable ORDER BY cases)
- added table and field alias support
- improved error reporting
- fixed: bug 0000002: Segfault if query-file doesn’t start with create database and use commands general
- fixed: bug 0000003: Segfault for queries that use table alias
- fixed: bug 0000005: Various segfaults
- fixed: bug 0000006: crash with bigint, datetime, enum field types
- minor output formatting improvements
- improved covering indexes gneeration algorithm
The new version is avaialble for download.
In this release:
- added: windows port
- added: multitable select star warning
- added: multicolumn IN clause warning
- added: numeration for output messages
- fixed: bug 0000001: Compilation fails
(a compilation problem on 3.x g++ compilers)
My article in the latest issue of the MySQL Magazine explains the features of the new QOT version 0.0.2, and shows how the tool can be used during the physical schema design stage.
The new version is avaialble for download.
Featues:
- added error reporting for unresolved identifiers to –info option
- added a new –static-checks option which should perform what is usually called static code checking, i.e. find constructs that are formally valid but has proven to be dangerous. Here you can find the full list of QOT static checks.
- added a new –rewrite option. Here you can find the full list of available QOT rewrites.
QOT version 0.0.1 is available for download here. Also a Quick Start Guide is available.