June 16th, 2008 at 11:12pm
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
April 23rd, 2008 at 11:59pm
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)
April 17th, 2008 at 6:34pm
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.
April 11th, 2008 at 11:26pm
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.
February 15th, 2008 at 11:26pm
QOT version 0.0.1 is available for download here. Also a Quick Start Guide is available.
